Microsoft Access Advanced

Creating Queries to Validate and
Analyze Data

Creating Crosstab Queries

Editing Crosstab Queries

Creating Crosstabs Using Dates

Finding Duplicate Records

Finding Matches and Non-Matches
Between Tables

Creating Union Queries

Adding Advanced Form Elements

Changing the View of Subforms

Naming Objects in Forms

Creating Forms Using the Form Tool

Using Tab Controls on Forms

Showing or Hiding Form Headers and Footers

Adding Titles and Captions to Forms

Creating Reports from Forms

Adding Advanced Report Elements

Viewing the Record Source of Objects

Modifying Queries from Within the
Report Designer

Including Parameters in Report Titles

Hiding Duplicate Field Values

Creating Basic Macros

Creating Macros to Preview Reports
from Forms

Attaching Macros to Command Buttons

Running Macros

Creating Macros to Open Forms

Creating a Switchboard or Main Menu

Creating Main Menu Switchboards

Adding Items to Switchboards

Opening Switchboards

Creating Additional Switchboards

Navigating Between Switchboards

Viewing Switchboard Items

Displaying Switchboards on Startup

Sharing and Maintaining a Database

Sharing Databases on a Network

Opening Databases in Exclusive Mode

Setting Database Passwords

Linking Tables Between Databases

Compacting and Repairing Databases

Using the Back Up Database Feature

Printing Database Object Information