INTERMEDIATE
Course length: 2 half-day sessions
Who should attend: Anyone responsible for the setup of a relational
database for others to use
Suggested Background: Access Introduction or equivalent experience
You will maintain data consistency and
integrity; improve queries, forms, and reports; and also integrate Access 2007
with other applications.
Upon completion of this course, you will be able
to:
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
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Sub form
Lesson 5: Customizing Reports
Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Sub report to an Existing
Report
Create a
Mailing Label Report
Lesson 6: Sharing Data Across Applications
Import & Export Data
Analyze Access Data in Excel
Merge Access
Data with a Word Document