|
|
Lesson 1: An Overview of Microsoft Access |
Relational Databases
The Access Environment
The Database Environment
Examine an Access Table
|
|
Lesson 2: Managing Data |
Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report
|
|
Lesson 3: Establishing Table Relationships |
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets
|
|
Lesson 4: Querying the Database |
The Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping
|
|
Lesson 5: Designing Forms |
Form Design Guidelines
Create AutoForms
Create a Form Using the Form Wizard
Modify the Design of a Form
|
|
Lesson 6: Producing Reports |
Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report
|
|
Lesson 7: Planning a Database |
Design a Relational Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys
|
|
Lesson 8: Building the Structure of a Database |
Create a New Database
Create a Table Using a Wizard
Create Tables in Design View
Create Relationships between Tables
|
|
Lesson 9: Controlling Data Entry |
Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field
|
|
Lesson 10: Finding and Joining Data |
Find Data with Filters
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table
|
|
Lesson 11: Creating Flexible Queries |
Set Select Query Properties
Create Parameter Queries
Create Action Queries
|
|
Lesson 12: Improving Your Forms |
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add Command Buttons
Create a Subform
|
|
Lesson 13: Customizing Your Reports |
Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels
|
|
Lesson 14: Expanding the Reach of Your Data |
Publish Access Data as a Word Document
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document
|
|
|
