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.