Microsoft Office Access Level 3

Module: Microsoft Office Access Level 3 (Advanced)

Lesson 1: Structuring Existing Data
 Restructure existing data using the Table Analyzer Wizard.
 Create a junction table to minimize redundant data.
 Modify the structure of tables to meet a change in target
specification.

Lesson 2: Writing Advanced Queries
 Create subqueries.
 Create unmatched and duplicate queries using wizards.
 Filter records using criteria.
 Summarize data using a crosstab query.
 Create a PivotTable and PivotChart to effectively summarize query
data.

Lesson 3: Simplifying Tasks with Macros
 Create a macro that opens a form from an existing form to display
records.
 Attach a macro to a command button in a form.
 Restrict records by adding a condition.
 Create a macro that makes data entry mandatory to ensure data
validation.
 Create a macro that inputs data automatically when a predefined
condition is fulfilled.

Lesson 4: Creating Effective Reports
 Add a chart to a report to increase its visual impact.
 Create a multiple-column report that uses functions and operators
to control the printing of data.
 Create a macro that cancels the printing of a blank report.
 Publish a report as a PDF, so that it can be viewed by users who do
not have the Access program installed in their computer.

Lesson 5: Maintaining an Access Database
 Link tables to external data sources.
 Manage an Access database.
 Determine interdependency of Access objects.
 Document a database using the Database Documenter tool.
 Analyze the performance of the database.