Fee: $250.00 per person

Prerequesites:
Microsoft Access 2007
Intermediate

Materials: Participants receive reference materials related to course topics. Follow up support by email or phone, on topics covered, is available to participants for 90 days (4 hour limit).

Further Learning:
Microsoft Access 2007
Introduction to VBA

Objectives:

Upon successful completion of this course, students will be able to:

• restructure data into appropriate tables to ensure data dependency and minimize redundancy.

• write advanced queries to analyze and summarize data.

• create and revise Microsoft® Office Access™ 2007 macros.

• display data more effectively in a form.

• customize reports by using various Microsoft® Office Access™ 2007 features, making them more effective.

• maintain your database using tools provided by Microsoft® Office Access™ 2007.

Lesson 1: Structuring Existing Data

Analyze Tables

Create a Junction Table

Improve 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