Microsoft Access 365 / 2021 / 2019 / 2016 MOS Live Hands-On Instructor-Led Training Class & Certification Pack

Virtual Online Live Training (VOLT™) Access from Anywhere

Print this Page
Outline & Course Information

Duration & Times: 2 Days – 8:30AM-3:00PM EST

Locations for Training:

Course Description In this hands-on, two-day course, you will learn how to create and manage an Access database, and move into more advanced features that will allow you to optimize the database.

Optional Upon Checkout: Our MOS Access 365 / 2021 / 2019 / 2016 Certification Training Pack gives you a test prep tool, a testing voucher with a free retake, and a proctor fee all included, to become a Microsoft Office Specialist in Access! The Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their Office skills and advance their careers.

Note: This course covers the following Course Numbers:
• Access Part 1 Course Number: 091083
• Access Part 2 Course Number: 091084

Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications and files, as well as navigate to other folders.

Required Technical Set-Up:
• Primary computer connected to a second monitor OR second computer to view instructor live
• Reliable High-speed internet connection
• Web Browser: Google Chrome Preferred (Alternative: Microsoft Edge)
• 3-Button Computer mouse
• Audio Speaker/Microphone (built-in to computer or external)

Microsoft Access Core MOS Training & Certification Course Outline

1. Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access

2. Working with Table Data
Modify Table Data
Sort and Filter Records

3. Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query

4. Using Forms
Create Basic Access Forms
Work with Data on Access Forms

5. Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports

6. Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships

7. Joining Tables
Create Query Joins
Relate Data Within a Table
Work with Subdatasheets

8. Using Data Validation
Use Field Validation
Use Form and Record Validation

9. Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries

10. Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure

11. Using Advanced Reporting Techniques
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.

Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.

What You Get
  • Hands-On Official Authorized Training & Certification
  • Training Delivered from Certified Instructors that are Senior Consultants
  • Official Curriculum Courseware & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Remote Access to ThinkB!G Class Computer with Software licenses & Class Files Pre-Installed for Use During Training--No Installs or Downloads
  • Instructor's Real-Time View of ThinkB!G Class Computer Screen for Immediate Live Interactive Support
  • If Certification Training is Selected, It May Include a Test Prep Tool, Testing Voucher with Free Retake, and Proctor Fee (if taken with ThinkB!G Virtually)
  • Note: IT Support is Available to Pre-Flight Virtual Class Set Up Before & During Training
Pricing

Public Enrollment Training Pricing

MOS Cert Pack Commercial Price Per Person 4-Day Class: $939.00
MOS Cert Pack GSA/Government Price Per Person 4-Day Class: $784.81
MOS Cert Pack Non-Profit/Education Price Per Person 4-Day Class: $889.00
Commercial Price Per Person 4-Day Class: $795.00
GSA/Government Price Per Person 4-Day Class: $640.81
Non-Profit/Education Price Per Person 4-Day Class: $745.00

Need Private Custom Training for Your Team?

Request a Quote

Dates to Register

Event Venue Start Date End Date
Microsoft Access MOS Instructor-Led Online Live
  • July 26, 2023 8:30 am EDT
  • July 27, 2023 3:00 pm EDT
Register
Microsoft Access MOS Instructor-Led Online Live
  • October 4, 2023 8:30 am EDT
  • October 5, 2023 3:00 pm EDT
Register
Microsoft Access MOS Instructor-Led Online Live
  • December 13, 2023 8:30 am EST
  • December 14, 2023 3:00 pm EST
Register

Certification

A Microsoft Office Specialist (MOS) Exam is Available for Access!

See Latest Exam Available!

Microsoft Office Specialist Logo

What is a Microsoft Office Specialist Certification?

The Microsoft Office Specialist (MOS) Certification demonstrates that you have the skills needed to get the most out of Office by earning this certification in a specific Office program.

Our Access MOS Training & Certification Pack Includes:

If you choose the Certification Pack option in the pricing dropdown upon checkout, this Includes:

✓ Training Based on Exam Objectives (2 Day Class, Virtual Online Live Training–VOLT™)

✓ Online Test Prep Tool (Simulates actual test & provides targeted learning based on your assessed needs)

✓ Exam Voucher with 1 Free Retake (Scheduled at your convenience)

✓ Testing Proctor Fee (Only included if you take your test Online from home with ThinkB!G)

Custom Private Training

We offer this course as Custom Private Training or Project Based Training®!

If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives!

What's Included?

  • Custom Outline to include Targeted Topics Based on Your Learning Needs
  • Hands-On Official Authorized Training & Certification
  • Training Delivered from Certified Instructors that are Senior Consultants
  • Official Curriculum Courseware & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Remote Access to ThinkB!G Class Computer with Software licenses & Class Files Pre-Installed for Use During Training--No Installs or Downloads
  • Instructor's Real-Time View of ThinkB!G Class Computer Screen for Immediate Live Interactive Support
  • If Certification Training is Selected, It May Include a Test Prep Tool, Testing Voucher with Free Retake, and Proctor Fee (if taken with ThinkB!G Virtually)
  • Note: IT Support is Available to Pre-Flight Virtual Class Set Up Before & During Training

Submit details and a formal training quote will be sent to you!

Request a Quote

Policies

Payment Policy for Public Enrollment Classes

Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training class.

 

Payment Policy for Private & Project Based Training® Classes

Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training service.  Pricing provided is firm fixed price based on number of students.  Client is responsible for entire amount regardless of change in number of registrations.

 

Cancellation/Rescheduling Policy for Public Enrollment Classes

  • Classes may be canceled if less than 4 students are registered. We will notify you of cancellations no later than 16 business days prior to class.
  • Canceling/Rescheduling more than 16 business days prior to class: You are eligible for a refund or free reschedule. Registration is transferable to another student for the same class & date.
  • Canceling/Rescheduling less than 16 business days prior to class: No refund. No Reschedule. Registration is transferable to another student for the same class & date.
  • No Shows without contact: No refund. No Reschedule.

Cancellation/Rescheduling Policy for Custom/Private and On-Site Training Classes

  • No penalty if cancellation/reschedule is 16 Business Days (Monday-Friday) prior to the first date of class.
  • 50% penalty will be incurred if cancellation/reschedule is less than 16 Business Days (Monday-Friday) prior to the first date of class. This fee is to cover instructor expenses, travel, and course materials purchased.

Cancellation/Rescheduling Policy for Individual Students in Custom/Private Training Classes

  • Individual students registered in a private class, who cancel or do not show, are not eligible for a partial refund or reschedule. Registration is transferable to another student. Please contact your class organizer or manager if you need to cancel. 
Reviews

Average Review: 5 out of 5 - 2 Reviews

U.S. Army Logo
Great Class!
"The class is great. I feel we covered a lot, given the time frame we had to complete it. I will keep the learning material and use Access to implement it in my everyday workplace." - ArmyEd - Stacy - (Microsoft Access MOS Certification Training)
U.S. Army Logo
Language Everyone Can Understand
"Very knowledgeable instructor who uses language everyone can understand. This class has inspired me to replace excel with data we are storing in a more manageable format." - ArmyEd, Jim - (Microsoft Access Training Course)