Microsoft Access 2010 Training Course Advanced

In this course you will learn how to create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

After completing this course you will know how to restructure data into appropriate tables to ensure data dependency and minimize redundancy, write advanced queries to analyze and summarize data, create and revise Microsoft® Office Access® 2010 macros, customize reports by using various Microsoft® Office Access® 2010 features and maintain their databases using Microsoft® Office Access® 2010 tools.

Microsoft Access 2010 Training Course (Advanced) Outline -

Structuring Existing Data

Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure

Writing Advanced Queries

Create SubQueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

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

Creating Effective Reports

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish Reports as PDF

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

Microsoft-Access-2010-Training-Course-Advanced

Course Duration: 1 Day

Microsoft Access 2010 Training Course Advanced