|
|
Lesson 1: Exploring the Microsoft® Office AccessT 2007 Environment |
Examine Database Concepts
Explore the User Interface
Explore the Ribbon
Customize the Access Environment
Obtain Help
Use an Existing Access Database
|
|
Lesson 2: Designing a Database |
Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
|
|
Lesson 3: Building a Database |
Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version
|
|
Lesson 4: Managing Data in a Table |
Modify Table Data
Sort Records
Work with Subdatasheets
|
|
Lesson 5: Querying a Database |
Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
|
|
Lesson 6: Designing Forms |
View Data Using an Access Form
Create a Form
Modify the Design of a Form
|
|
Lesson 7: Generating Reports |
View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat to a Report
Prepare a Report for Print
|
|
Lesson 8: 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 9: Joining Tables |
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table
|
|
Lesson 10: Creating Flexible Queries |
Set Select Query Properties
Create Parameter Queries
Create Action Queries
|
|
Lesson 11: 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 12: 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 13: 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
|
|
|
