Centriq Training Print Logo


July 4 12:08 PM


Microsoft Office Access: Level 2 Training Class:

  • Ways to Train:
  • Live Classroom
    Class is delivered at a Centriq location with a live instructor actually in the classroom.
  • Live Virtual Class
    Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
  • HD Class
    Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
  • Ways to Buy:
  • Retail
    Class can be purchased directly via check, credit card, or PO.
  • CV Centriq Vouchers
    Class is available for students using Centriq Vouchers.
  • CP Centriq Choice Pass Eligible
    Class is available to students utilizing Centriq Choice Pass program.
Start Date End Date Duration Days Start Time End Time Time Zone Location Ways to Train Ways to Buy Price
09.30.22 09.30.22 1 Day F 8:30AM 4:00PM Central Virtual Only Live Virtual Classroom Cash CV Centriq Vouchers CP Centriq Choice Pass Eligible $249.00
1.0 CV
Enroll Now
The course assumes you have completed Access 2019 Level 1, or you have equivalent skills in using Access. You will benefit most from this course if you want to be an advanced user of Access 2019.

*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Access 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.


This course provides the concepts and skills for the advanced use of Microsoft Access: How to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

View the Microsoft Office Access: Level 2 Training Course Outline

Lesson 1: Promoting Quality Data Input
  •  Topic A: Restrict Data Input Through Field Validation
  •  Topic B: Restrict Data Input Through Forms and Record Validation
Lesson 2: Improving Efficiency and Data Integrity
  • Topic A: Data Normalization
  • Topic B: Associate Unrelated Tables
  • Topic C: Enforce Referential Integrity
Lesson 3: Improving Table Usability
  •  Topic A: Create Lookups Within a Table
  •  Topic B: Work with Subdatasheets
Lesson 4: Creating Advanced Queries
  • Topic A: Create Query Joins
  • Topic B: Create Subqueries
  • Topic C: Summarize Data
Lesson 5: Improving Form Presentation
  •  Topic A: Apply Conditional Formatting
  •  Topic B: Create Tab Pages with Subforms and Other Controls
Lesson 6: Creating Advanced Reports
  •  Topic A: Apply Advanced Formatting to a Report
  •  Topic B: Add a Calculated Field to a Report
  •  Topic C: Control Pagination and Print Quality
  •  Topic D: Add a Chart to a Report
Enroll Now!