HARTMANN software group

Microsoft Office Access 2010: Level 3 Training in Salem

Enroll in or hire us to teach our Microsoft Office Access 2010: Level 3 class in Salem, Oregon 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.

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.
get more information

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]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
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.