Microsoft® Office Access™ 2007: Level 3

Course Specifications

Course length: 1.0 day(s)

Course Description

Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Prerequisites: To ensure the successful completion of Microsoft® Office Access 2007™: Level 3, the following Element K courses or equivalent knowledge are recommended for familiarity with: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as:

• Microsoft® Office Access™ 2007: Level 1

• Microsoft® Office Access™ 2007: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

Microsoft® Access™ 2007: Level 3 is one of a series of Element K courseware titles that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

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