Microsoft Office Access 2010: Level 3 Training in Nashville

Enroll in or hire us to teach our Microsoft Office Access 2010: Level 3 class in Nashville, Tennessee by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2010: Level 3 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2010: Level 3 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

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.