Free Access 2003 Training Manual

Here is an excellent Free Access 2003 Training Manual, courtesy of Mousetraining.co.uk. This Access training guide is 164 pages in length, and you need to unzip it after downloading (ZIP file is 2.0mb, resulting DOC file is 4.3mb after unzip). This manual can also be used as an Access reference guide.  It covers all the topics taught by the site’s Access course. The free Access training manual is divided into sections, as listed below. If you already have experience using an Access database you may not need to read explanations about each command, and instead can go right to the instructions to find out how to do it. Look for the hand icon preceding the step-by-step instructions for each Access command.

If you need assistance with learning about and using Access Macros, also download their Microsoft Access Macros Training Manual (82 pages, 523kb, doc format after unzipped). This Macro training document contains six sections: Intro to  Macros, Macro Groups, Auto Keys, Event Procedures, Conditional Macros, and Start Up Options.


Table of Contents of Access 2003 Training Manual:

Section 1:
Screen Layout
Windows Concepts
The Screen Layout
Using Help

Section 2:
What is a database?
  Tables
  Query
  Form
  Report
  Pages
  Macro
  Modules
Naming Conventions
Planning a Database
  Step 1: Task Analysis
  Step 2:  Data Analysis
  Step 3: Table Design

Section 3:
Creating a Database
Starting and naming a database
Creating a Table
Setting a Primary Key
Field Properties
Other Field Properties
Editing the Table Structure
Saving Tables
Creating a Table using a Table Wizard

Section 4:
Switch between Views of a Table
Adding New Records
Selecting Fields & Records in Datasheet View
Editing Table Data
Moving Around a Table
The Undo/Redo Command
Spell Checking Feature
Searching & Replacing Information

Section 5:
Table Properties
Changing the Table Appearance
Sorting Data in a Table

Section 6:
Importing and Linking Data
Importing from Access and Excel
Importing form Excel
Linking to Access and Excel
Round Tripping between versions
Renaming and Copying Tables

Section 7:
Using Filter and Select Queries
Running a Select Query
Specifying text, numeric, date, and logic criteria
Calculated Fields
Using Query Wizards

Section 8:
Relationships
Why do we need relationships
Different Types of Relationships
Creating a relationship

Section 9:
Multi-table Queries
Multiple Table Queries
Joining Tables in Queries
Find Unmatched Query Wizard
Find Duplicates Query Wizard

Section 10:
Creating Forms
Using Forms
Viewing Forms
The Form Wizard

Section 11:
Form Layout and Formatting
Editing Forms
The Field List box
Formatting Controls

Section 12:
Creating Reports
Creating Reports
Page Components
Grouping and Summarising Data
Viewing Reports
Mailing Labels