Access 2010 – Level 3

Working World provides training on many of the leading software programs and applications.  To book your next computer training course please call our main office number at (800) 463-3074.

Course Length

• 1 Day

Objectives

• 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.
• maintain their databases using Microsoft® Office Access® 2010 tools.

Prerequisites

• Access 2010 – Level 2

Content

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