Session 1: Defining Relationships
Overview of Relationships
Establishing One-to-Many Relationships
Establishing One-to-One Relationships
Establishing Many-to Many Relationships
Enforcing Referential Integrity
Set Cascade Update and Cascade Delete Options

Session 2: Creating and Modifying Tables
Creating and Modifying Lookup Fields
Using Data Validation
Creating Custom Input Masks
Optimize Data Type Usage
Display Related Records in a Subdatasheet
Linking Existing Data

Session 3: Creating and Modifying Forms
Creating Forms in Design View
Modifying Form Properties
Creating Subforms
Creating a Switchboard
Setting and Modifying Startup Options

Session 4: Introduction to Queries
Multi-Table Select Queries
Modifying Query Properties
Specify Criteria in Multiple Fields
Set Join Properties
Applying a Filter
Optimizing Queries

Session 5: Types of Queries
Query Types
Creating a Parameter Query
Types of Action Queries
Creating an Action Query (Append)
Creating an Action Query (Delete)
Creating a Totals Query
Using Aggregate Functions in Queries