Orientation to Microsoft Access

Create a Simple Access Database

Get Help in Microsoft Access

Modify Table Data

Sort and Filter Records

Create Lookups

Join Data from Different Tables in a Query

Sort and Filter Data in a Query

Perform Calculations in a Query

Create Parameter Queries

Create Action Queries

Create Unmatched and Duplicate Queries

Summarize Data

Create a Report

Add Controls to a Report

Enhance the Appearance of a Report

Prepare a Report for Print

The Access Options Dialog Box

Relational Database Design

Create a Table

Create Table Relationships

Create Query Joins

Join Tables That Have No Common Fields

Relate Data within a Table

Work with Subdatasheets

Create Subqueries

Data Normalization

Create a Junction Table

Improve Table Structure

Import Data into Access

Export Data to Text File Formats

Export Access Data to Excel

Create a Mail Merge

Organize Report Information

Format Reports

Include Control Formatting in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report

Add Controls to Forms

Create Subforms

Organize Information with Tab Pages

Enhance Navigation of Forms

Apply Conditional Formatting

Field and Record Validation

Form Validation

Create a Macro

Restrict Records Using a Condition

Validate Data Using a Macro

Automate Data Entry Using a Macro

Convert a Macro to VBA

Link Tables to External Data Sources

Manage a Database

Determine Object Dependency

Document a Database

Analyze the Performance of a Database

Splitting a Database for Multiple User Access

Implement Security

Set Passwords

Convert an Access Database to an ACCDE File

Package a Database with a Digital Signature

Create a Database Switchboard

Modify a Database Switchboard

Set Startup Options