Access Level 3

Click here to view course dates 

Overview

Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.  

Audience

This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access™ 2007, and it is a prerequisite to take more advanced courses in Microsoft® Office Access™ 2007.

Course Contents 

Lesson 1: Structuring Existing Data

1A: Analyse TablesTopic

1B: Create a Junction TableTopic

1C: Improve Table Structure 

Lesson 2: Writing Advanced Queries

2A: Create SubqueriesTopic

2B: Create Unmatched and Duplicate QueriesTopic

2C: Group and Summarize Records Using CriteriaTopic

2D: Summarize Data Using a Crosstab QueryTopic

2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

3A: Create a MacroTopic

3B: Attach a MacroTopic

3C: Restrict Records Using a ConditionTopic

3D: Validate Data Using a MacroTopic

3E: Automate Data Entry Using a Macro 

Lesson 4: Making Effective Use of Forms

4A: Display a Calendar on a FormTopic

4B: Organise Information with Tab PagesTopic

4C: Display a Summary of Data in a Form 

Lesson 5: Making Reports More Effective

5A: Include a Chart in a Report

5B: Print Data in ColumnsTopic

5C: Cancel Printing of a Blank ReportTopic

5D: Create a Report Snapshot 

Lesson 6: Maintaining an Access Database

6A: Link Tables to External Data SourcesTopic

6B: Manage a DatabaseTopic

6C: Determine Object DependencyTopic

6D: Document a DatabaseTopic

6E: Analyze the Performance of a Database