Microsoft Access 2003 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2007 Introduction or equivalent experience |
| Course Materials: | Course manual with CD containing exercises, 168 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications. |
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