Target Student: The Level III course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Course Content:

Lesson 1: Structuring Existing Data

Analyze Tables

Create a Junction Table

Improve the Table Structure

Lesson 2: Writing Advanced Queries

Create Subqueries

Create Unmatched and Duplicate Queries

Group and Summarize Records Using Criteria

Summarize Data Using a Crosstab Query

Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Create a Macro

Attach a Macro

Restrict Records Using a Condition

Validate Data Using a Macro

Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

Display a Calendar on a Form

Organize Information with Tab Pages

Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Include a Chart in a Report

Print Data in Columns

Cancel Printing of a Blank Report

Create a Report Snapshot

Lesson 6: Maintaining an Access Database

Link Tables to External Data Sources

Manage a Database

Determine Object Dependency

Document a Database

Analyze the Performance of a Database

This website and its contents are copyright © 2008, Knowledge Source Inc.