Microsoft® Office Access 2007: Level 2

Course Objective: You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications.

Prerequisites: To ensure the successful completion of Microsoft Office Access 2007: Level 2, the completion of the Microsoft Office Access 2007: Level 1 course, or equivalent knowledge, is recommended.

Training Course Content

Lesson 1: Controlling Data Entry

Topic 1A: Restrict Data Entry Using Field Properties
Topic 1B: Establish a Pattern for Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

Topic 2A: Create Query Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Topic 3A: Set Select Query Properties
Topic 3B: Create Parameter Queries
Topic 3C: Create Action Queries

Lesson 4: Improving Forms

Topic 4A: Design a Form Layout
Topic 4B: Enhance the Appearance of a Form
Topic 4C: Restrict Data Entry in Forms
Topic 4D: Add a Command Button to a Form
Topic 4E: Create a Subform

Lesson 5: Customizing Reports

Topic 5A: Organize Report Information
Topic 5B: Format the Report
Topic 5C: Set Report Control Properties
Topic 5D: Control Report Pagination
Topic 5E: Summarize Report Information
Topic 5F: Add a Subreport to an Existing Report
Topic 5G: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Topic 6A: Import Data into Access
Topic 6B: Export Data
Topic 6C: Analyze Access Data in Excel
Topic 6D: Export Data to a Text File
Topic 6E: Merge Access Data with a Word Document

Access 2007 Training Class Outlines:

Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced 1
Level 4 - Advanced 2
Level 5 - Access SQL and VBA
Levels 1 - 4 (PDF Document)

Microsoft Access 2007 Additional Information:

Microsoft Access Database Basics
Microsoft Access Whitepaper