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
Lesson 2: Writing Advanced Queries
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
Lesson 3: Simplifying Tasks with Macros
Create a macro that opens a form from an existing form to display
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
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.