This
Access 2003 Tutorial, titled An
Introduction to Databases using Microsoft Access 2003,
from Durham University, will teach you the fundamentals of creating and
working with relational databases using Microsoft Access 2003.
Access features and topics covered include: data tables, sorting
records, using filters, defining and using queries, edit and replace,
keys and indexes, linking tables, creating entry forms, creating
reports, and converting databases from one Access version to another.
(788kb, 76 pages, pdf format)
Contents
of Access Tutorial:
1
Introduction
1.1 About Microsoft Access
1.2 What you should know already
1.3 Giving commands
2
Database concepts
3 Starting up Access
4
A first look at the Access environment
4.1 The
Access screen
5 A first look at an Access
database
5.1 Obtaining a copy of the sample database
5.2 Opening an existing database
5.3 The Default
Database Folder
5.4 Looking at the data
tables
5.5 Moving around in a table
5.6 Sorting records
5.7 Locating specific records
6
Using filters
6.1 Using Filter By
Selection
6.2 Using Filter By Form
6.3 Using Filter For Input
6.4 Sorting filtered
records
6.5 Advanced Filter/Sort
6.6 Saving a filter
6.6.1
Saving a filter as a query
6.6.2 Saving a filter with a table, form or query
7
Defining and using queries
7.1 Creating a simple
query
7.2 Running a query on selected fields
7.3 Searching for particular records
7.4 Searching
for non-equalities
7.5 Calculated fields
7.6 Summary statistics
7.7 Summary of operators
available in queries
8 Properties of
objects
8.1 What are objects?
8.2 Changing object properties
9 More
advanced queries
9.1 Searching multiple tables
9.2 Sorting the recordset
9.3 Saving queries
9.4 Saving and printing a recordset
9.5 Parameter
queries
9.6 Query wizards
10 Printing
datasheets
11 Exiting Access
12 Creating tables,
entering and editing data
12.1 Defining fields
12.2 Checking and modifying table structure
12.3
Entering and editing data in a table
12.4 Inserting
and deleting records
12.4.1
Inserting new records
12.4.2
Deleting records
12.5 Making global changes to data
12.5.1 Using Edit | Replace
12.5.2 Action queries
12.6 Validity checks
12.7 Keys and indexes
12.7.1
What is a key?
12.7.2 Defining
a primary key
12.7.3 Defining
indexes
12.8 Printing a table design
13
Linking tables and referential integrity
13.1 Creating a link between two tables
13.2
Referential integrity
14 Creating data entry forms
14.1 Using the AutoForm Wizard
14.2
Adding new records using the data entry form
14.3
Editing records using the data entry form
14.4
Deleting a record using the data entry form
14.5
Simple modifications to the data entry form
14.6
Further modifications
14.6.1
Moving fields
14.6.2
Removing a field
14.6.3 Adding
fields
14.6.4 Resizing the form
14.6.5 Adding text to a form
14.6.6 Adding special controls
14.7 Saving a form 60
14.8 Creating a form from multiple tables
15 Producing reports
15.1 Producing a simple report
15.2 Modifying
reports
15.3 Adding summary data to a
report
15.4 Preparing a set of labels
16
Miscellaneous
16.1 Exporting and Importing data and
other database objects
16.2 Compacting an Access
database file
16.3 Converting from Access 97 to
Access 2000
16.4 Converting from Access 2000 to
Access 97
17 Further information
17.1 The Access online help
17.2 Books, manuals and
other documents
17.3 Special interest group