Microsoft Office Access Level 2
Course Description
| Lesson 1: Structuring Existing Data |
| Restructure the Data in a Table Create a Junction Table Improve the Table Structure |
| Lesson 2: Writing Advanced Queries |
| Create Subqueries Create Unmatched and Duplicate Queries Filter 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: Creating Effective Reports |
| Include a Chart in a Report Print Data in Columns Cancel Printing of a Blank Report Publish a Report as a PDF |
| Lesson 5: 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 |