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 |