Microsoft® Office Access 2010:  Advanced Topics

Open Enrollment Course Dates: 9/23

Course Objective: You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Target Student: This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Prerequisites: To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended.

 Course Objectives

Upon successful completion of this course, students will be able to:

  • restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • write advanced queries to analyze and summarize data.
  • create macros.
  • customize reports by using various Access features.
  • maintain your database using Access tools.


Course Content

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