To get started, simply click one of the topics below.
IntroductionIntroductionDesign BasicsExample DatabasesThe 6 Access ObjectsOne to Many RelationshipsAccess BasicsStarting Access97Screen TipsKeyboard SetupAccessing HelpHelp MenuThe Office AssistantSetting OptionTable Structure && Data TypesThe Structure of a TableData TypesField PropertiesIntro/Field Size
Format
Input Mask
Caption
Default Value
Validation Rule/Text
Required
Indexed
Primary KeY
Working with an Existing DBOpen an Existing Database
Passwords
Relationships
Documenter
Working in DataSheet ViewDataSheet View
Sort && Find
Filter by Selection
Filter by Form
Saving a Filter
Navigating DataSheets
Adjust Column Width
Freeze/Unfreeze
Appearance
Data Entry
Delete, Copy, Paste
Printing DataSheets
Save && Close DataSheets
Using FormsIntroduction to Forms
Form Design Basics
Form Types
Form Views
Data Entry using Forms
Printing Forms
Save and Close Forms
Pop-up and Modal Forms
Using QueriesIntroduction to Queries
Query Types
Query DataSheet View
Query Design View
SQL View
Saving Queries
Using ReportsIntroduction to Reports
Viewing a Report
Report Types
Printing Reports
Create a New DatabaseDatabase Structure
Create a Database
Creating TablesWays to Create a Table
Creating Fields
Setting Properties
Adding Fields
Setting a Primary Key
Lookup Wizard
Table Wizard
The Contacts Table
Setting up RelationshipsRelationship - Why?
Prerequisites
The Relationships Window
Referential Integrity
Creating FormsCreate Forms Manually
Autoforms
Forms Wizards
Form Design Facilities
Controls Overview
Moving && Sizing Controls
Formatting Controls
Alignment
Add && Delete Controls
Changing Form Size
Headers && Footers
Calculations (1)
Calculations (2)
Calculations(3)
Creating Command Buttons
Add a Combo-box
Create a Main && SubForm
Creating QueriesIntroduction to Queries
New Query Options
Query Design View
Adding fields to QBE grid
Adding a Table
Running Queries
Sorting in a Query
Entering Criteria
Ranges in Criteria
Tips on Criteria
More Tips on Criteria
And/Or
Calculated Fields
Names && Numbers Query
Saving Queries
Parameter Queries
Totals Queries
Expression Builder
Creating ReportsIntroduction to Reports
Creating Reports
Report Design View
Sorting && Grouping
More Sorting and Grouping
Layout Problems
Layout Problems, continued
Mailing Labels
Adding Calculated Fields
Adding Group Totals
Adding Sum Totals
External DataIntroduction
Importing Data
Importing from Excel
Mailmerging with Word
Linking/Attaching Tables
ReplicationReplication Introduction
Replication Help
Considerations
Security/Backing UpSecurity Introduction
Further Information
Everything about backing up
MacrosMacro Introduction
Example Macro
Conditional Macros
Publish on the WebIntroduction
The Web Wizard
View the Web Page
SwitchboardsCreate a Switchboard
Add Buttons
Improve Appearance
Click here to find out more about the Microsoft Access 97 Training CD 
