|
|
Lesson 1: Structuring Existing Data |
Analyze Tables
Create a Junction Table
Improve Table Structure
|
|
Lesson 2: Writing Advanced Queries |
Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
|
|
Lesson 3: Simplifying Tasks with Macros |
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
|
|
Lesson 4: Making Effective Use of Forms |
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form
|
|
Lesson 5: Making Reports More Effective |
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot
|
|
Lesson 6: Maintaining an Access Database |
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
|
|
|
