76 Page Access 2003 Tutorial

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