Microsoft Access Intermediate

Duration: 2 day course

1. Maintain Data Integrity

Restricting the Type of Data
Restricting the Amount of Data
Restricting the Format of Data
Restricting Data by Using Validating Rules
Restricting Data to Values in Lists
Restricting Data to Values in Other Tables

2. Create Custom Forms

Modifying Forms Created by Using a Wizard
Adding Controls
Adding Subforms
Using E-Mail forms to Collect Data

3. Create Queries

Creating Queries by Using a Wizard
Creating Queries Manually
Using Queries to Summarize Data
Using Queries to Perform Calculations
Using Queries to Updated Records
Using Queries to Delete Records

4. Create Custom Reports

Creating Reports Manually
Modifying Report Content
Adding Sub-reports