Microsoft Office Access 2010: Level 3 Training

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

Course Description

 
You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

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

Course Outline

 


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
     Group and Summarize 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 Reports as 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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.