Microsoft Access 2007 Level 2
Controlling Data Entry
Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field
Joining Tables
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table
Creating Flexible Queries
Set Select Query Properties
Create Parameter Queries
Create Action Queries
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
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
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
Class Information
Duration: 1 day
Prerequisite: Microsoft Access 2007 Level 1 or equivalent experience.
Course Materials: Course manual (084482S3)
Description: Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications.