Microsoft^® Access 2007 Level II Intermediate

Target Student: Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007.

Course Content

Lesson 1: Controlling Data Entry

Restrict Data Entry Using Field Properties

Establish a Pattern for Entering Field Values

Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins

Join Unrelated Tables

Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set Select Query Properties

Create Parameter Queries

Create Action Queries

Lesson 4: Improving Forms

Design a Form Layout

Enhance the Appearance of a Form

Restrict Data Entry in Forms

Add a Command Button to a Form

Create a Subform

Lesson 5: Customizing Reports

Organize Report Information

Format the Report

Set Report Control Properties

Control Report Pagination

Summarize Report Information

Add a Subreport to an Existing Report

Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Import Data into Access

Export Data

Analyze Access Data in Excel

Export Data to a Text File

Merge Access Data with a Word Document