|
ACC-207
Access 2007 Intermediate
Course Length:
1
day
*Prerequisite*
Introduction to
Access or equivalent working knowledge
Course
Contents
Introduction
Lesson 1: Structuring Existing Data
Topic 1A: Analyze Tables
Topic 1B: Create a
Junction Table
Topic 1C: Improve Table
Structure
Lesson 2: Writing Advanced Queries
Topic 2A: Create
Sub-queries
Topic 2B: Create Unmatched
and Duplicate Queries
Topic 2C: Group and
Summarize Records Using Criteria
Topic 2D: Summarize Data
Using a Crosstab Query
Topic 2E: Create a
PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records
Using a Condition
Topic 3D: Validate Data
Using a Macro
Topic 3E: Automate Data
Entry Using a Macro
Lesson 4: Making Effective Use of Forms
Topic 4A: Display a
Calendar on a Form
Topic 4B: Organize
Information with Tab Pages
Topic 4C: Display a
Summary of Data in a Form
Lesson 5: Making Reports More Effective
Topic 5A: Include a Chart
in a Report
Topic 5B: Print Data in
Columns
Topic 5C: Cancel Printing
of a Blank Report
Topic 5D: Create a Report
Snapshot
Lesson 6: Maintaining an Access Database
Topic 6A: Link Tables to
External Data Sources
Topic 6B: Manage a
Database
Topic 6C: Determine Object
Dependency
Topic 6D: Document a
Database
Topic 6E: Analyze the
Performance of a Database
|
