Module 1: Working with Tables and Fields in access 2002
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Changing a Field’s Data Type
Using Field Descriptions
Adding a Caption
Changing the Field Size
Formatting Number, Currency, and Date/Time Fields
Formatting Number, Currency, and Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Modifying a Lookup List

Module 2: Creating Relational Databases in access 2002
Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Testing Referential Integrity
Printing Table Relationships
Deleting Table Relationships
Understanding Relationship Types

Module 3: Working with Queries in access 2002
A Quick Review
Understanding the Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IIF Function
Summarizing Groups of Records
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
MakeTable Queries