Welcome to ONLC Training Centers

Microsoft Access Training Classes & Learning Courses

Learn Microsoft Access in a training format that's best for you at ONLC. Our live, hands-on Microsoft Access classes are led and supported by seasoned instructors with decades of experience teaching and using Access software. Or choose to learn on your own schedule at your own pace with our self-study On-Demand Microsoft Access online courses.

Microsoft's Access is a powerful relational database management application that is included in Microsoft Office / Office 365. This information management tool by Microsoft lets users easily manage business data using tables, queries, forms and reports, and connects those elements together with macros. Access databases can also be used to analyze large amounts of information and manage related business data.

ONLC has Access classes for those new to the program on up through advanced topics that will expand your knowledge of relational database design and allow you to write advanced queries, structure existing data, share data across applications, and customize reports from databases. There's also an Access VBA class in which users learn to write rich solutions with advanced data manipulation and user control.

Our Microsoft Access classes can be used to prep for Microsoft Office Specialist (MOS) Access certification. Becoming MOS certified proves your Access skills and dedication to your career and value to business. Start learning Microsoft Access with classes at ONLC where you get to learn data analysis in the format that works best for you!

Two Ways to Learn Microsoft Access

At ONLC you pick the class format that's best for your learning style

Instructor-led Training (ILT) -or- On-Demand
Instructor-led Training (ILT ) classes are live and hands-on. They are led and supported by an online instructor. ILT classes are available at convenient ONLC centers or attend from home. Alternatively, Access On-Demand courses are self-study learning (typically a blend of video tutorials, labs and exercises) for which you get 24/7 access for a period of months. See Access titles, prices & schedule.

Extra Value & Savings for Microsoft Access Courses

Get more value adds and savings options when you train with ONLC

You get more with ONLC! Train with confidence knowing we have a money-back satisfaction guarantee plus see the class a 2nd time with our optional free refresher course . These ONLC value-adds are available when you attend our public, instructor-led training classes. Does your business need multiple courses or multiple people trained? Discount Access courses are available for volume purchases. See Savings Options .

Access Group Training

Group Training from ONLC

Our Group Training solutions can help save both time and money upskilling your staff on Microsoft Access. Training can be public or private with instruction online or onsite. We can even customize Microsoft Access course content to meet specific business learning objectives, schedules and budgets! Whether training is for a team of 10 or a division of a thousand, ONLC has the experience and resources to make your training goals a reality. To learn more and for a price quote see Group Training .

 

 

Microsoft Access Class Titles, Schedule & Costs


Attend our live, instructor-led Microsoft Access classes from any of ONLC's training centers coast to coast or from your own location. On-Demand titled courses are eLearning you take from your own location using your own equipment. ONLC makes learning Microsoft Access available in these options so you can choose the learning format you like best!

Microsoft Access: Instructor-led Courses Click for FAQs about remote instructor-led training

Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes. Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information

Click Title for Dates & Outlines Days Fee
Microsoft Access
Access Introduction 2 $695
Access Advanced 2 $695
Access Programming with VBA 3 $1195

  Related Topics

  See all Microsoft Office training classes at ONLC

Microsoft Access On-Demand: eLearning Courses Self-study, self-paced training

Class Information

Click Title for Dates & Outlines Days Fee
Access 2016
Access 2016 On-Demand: Comprehensive (Introduction & Advanced) 3 $495
Access On-Demand: Access 2013/2016 Programming with VBA 3 $795
Access 2013
Access On-Demand: Access 2013/2016 Programming with VBA 3 $795
Related Topics
Office 2019 On-Demand: Comprehensive (Excel, Word, Outlook, PowerPoint, Access) 14 $995

  Related Topics

  See other Microsoft Office On-Demand Courses

Save with an Access Bundle!

Bundles must be purchased by phone: 1-800-288-8221 (weekdays). For course outline and upcoming ILT dates click the course title in the table. Below the table you'll find learning paths for MOS Access certification.

Access Training Bundles
Complete
(ILT+On-Demand)
All ILT
(ILT only)
On-Demand
(Self-study only)
Instructor-Led Training (ILT)      
On-Demand Training      
Access On-Demand Comprehensive
Comparable to Intro & Advanced titles
Hard copy workbook for On-Demand
Retail Total:
$1,885
$1,390
$495
Training Bundle:
$1,395
$1,195
$495
Optional MOS Certification Add-on (retail value over $200) *      
Access Exam Prep Software & Study Guide
Exam Voucher with Exam Pass Guarantee
Training Bundle with MOS Add-on:
$1,570
$1,370
$670

* Certification Add-on not sold separately. Retail value varies with Bundle type. See Bundle Terms & Conditions

MOS exams are administered by Certiport. A test from home option is available for current ONLC students. Qualified ONLC students should complete the Home Exam request form to schedule an at home exam (other restrictions and requirements may apply). Those who prefer a testing location and non-ONLC students should visit Certiport's list of locations to schedule a MOS exam.

 

Purchase Your Bundle Today!

Bundles are available for purchase via our toll free number. We accept all major credit cards. To place your order contact an ONLC Advisor...

1.800.288.8221
(weekdays)


Microsoft Access Certification Learning Path

MOS Access certification

Microsoft Office Specialist: Microsoft Access Expert (Access 365 & Access 2019)

To achieve MOS Access Expert certification for versions 2019 or 365 you must pass the authorized exam. Microsoft recommends that you have hands-on experience with the application and that you use training resources before attempting the exam. Below is the MOS Access learning path. Prep for MOS certification with our live, hands-on courses led by expert trainers, or with our self-study, On-Demand course. Either learning format will help candidates prepare for the Access MOS authorized exam.

MOS Access 2019 / 365 Learning Path
(click course title for outline & dates)

  • Microsoft Access Introduction  (2 days)
    During this hands-on, instructor-led course you will establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. View outline & dates

  • Microsoft Access Advanced  (2 days)
    In this hands-on, instructor-led course you will gain intermediate-level skills including constructing relational databases, performing database maintenance, creating advanced queries and reports, and integrating Access with other programs. View outline & dates

    —OR—

  • Access On-Demand Comprehensive: (Introduction & Advanced)
    This is a self-study course. You are given 24/7 unlimited access for up to 6-months. The course is a blend of video tutorials, labs and exercises that covers Microsoft Access Introduction & Advanced topics. View outline

MOS Access Certification Exam

  • MO-500: Microsoft Access Expert (Access & Access 2019)

MOS exams are performance-based and include multiple projects to gauge skills. Microsoft changes exam elements frequently to maintain integrity. As such, training alone may not cover all exam topics. It is recommended candidates review the exam guide before attempting the authorized exam.

MOS authorized exams are through Certiport. Certiport has approved ONLC to provide a test from home option for current ONLC students only. ONLC students should complete the Home Exam request form to schedule their at home authorized exam (other restrictions and requirements may apply). Those who prefer a testing site and non-ONLC students should use Certiport's list of testing locations to schedule an exam.

When you pass the authorized MOS exam you will receive a digital badge for that credential. Anyone who views your badge can select it to learn about your skills and verify its authenticity.

TIP: Get MOS Access training PLUS value-adds at a discount with an ONLC MOS Access Bundle. See Access Bundle


 

MOS Access certification

Microsoft Office Specialist (MOS) Certification: Access 2016

To achieve MOS certification you must pass the designated exam. Microsoft recommends that you have hands-on experience with the product and that you use training resources.

VERSION NOTE: Our live, instructor-led courses are appropriate for candidates using Microsoft Access versions 365, 2019, 2016 or 2013. There are very few differences between those versions from a user perspective. ONLC's classes are taught using Access 2019 software. ONLC's expert instructors have used all versions and will be able to quickly highlight any changes in the user interface.

MOS Access 2016 Learning Path
(click course title for outline & dates)


  • Microsoft Access Introduction  (2 Days)
    During this hands-on, instructor-led course you will establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. View outline & dates

  • Microsoft Access Advanced  (2 Days)
    In this hands-on, instructor-led course you will gain intermediate-level skills including constructing relational databases, performing database maintenance, creating advanced queries and reports, and integrating Access with other programs. View outline & dates

    —OR—

  • Access On-Demand Comprehensive: (Introduction & Advanced)
    This is a self-study course. You are given 6-months unlimited access and the course includes Microsoft Access 2016 Introduction & Advanced content. View outline

MOS Access Certification Exam

77-730: Microsoft Access 2016

For this exam you need to be able to create and maintain a basic Access database, create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. You should also be able to construct and modify basic relationships among database entities and be able to instruct others in basic Access functionality and usage. The following courses can help you get started, though may not cover all exam topics. It is recommended that you review the exam guide and practice the skills listed before attempting the authorized exam.

Learn more about Exam 77-730 .

 

MOS authorized exams are through Certiport. Certiport has approved ONLC to provide a test from home option for current ONLC students only. Qualified ONLC students should complete the Home Exam request form to schedule (other restrictions and requirements may apply). Those who prefer a testing location and non-ONLC students should visit Certiport's list of locations to schedule an exam.


Microsoft Access Resources

News & Offers

Microsoft Access Versions 365 / 2019 / 2016
These versions are very similar. The difference is mostly a matter of how you're accessing the software. Microsoft Access 365 is accessed via the cloud. You pay a monthly subscription to use the software. Since it's not static on your device, you'll get updates to the software when they happen. On the otherhand, 2019 / 2016 and earlier PC versions are purchased outright and installed directly onto your computer (aka "on-premise"). Access features and functions are the same no matter which of these versions you're using and as such students with any of those versions can attend the same classes.

 

Call an ONLC Education Advisor for certification and course selection assistance

ONLC Education Advisors for Assistance
Our advisors can answer questions about our training options as well as Microsoft certification. They can also help determine a training path that's right for you based on your background and career goals. Advisors are available weekdays toll free or chat.

 

ONLC centers coast to coast

ONLC Training Centers Coast to Coast
We schedule every instructor-led (ILT) class at each of our ONLC Training Centers locations. Our training rooms are outfitted with the equipment needed for class and provide an interruption-free space so you can concentrate fully on learning. See ONLC locations.

 

Train at Home

Live Microsoft Access Classes from Home
You can attend our live, instructor-led Microsoft Access classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software on your device. Follow our easy setup video. If you're still not sure about the setup contact an ONLC Advisor toll free for assistance.

 

Bundle your training to save!

Save a Bundle on Microsoft Access Training!
We have discounted bundles for those who need more than one Microsoft Access course. You get to select your preferred class format and can opt for a MOS Certification Add-on—all at a discount. See Access Bundles

 

Group training available from ONLC

Microsoft Access Group Training
ONLC has complete solutions so training coordinators can successfully upskill their teams while maintaining their budget. Microsoft Access training can be via our public schedule or private sessions taught virtually or onsite. For private training, content can be customized to meet your specific needs and technologies. To explore how we can minimize your training costs while maximizing learning and to receive a price quote see Group Training .

 

Earn Professional credits for attending some of ONLC's classes

Earn Professional Credits
Many of ONLC's courses are approved for professional credits including CEUs (Continuing Education Unit), CPEs (Continuing Professional Education) and PDUs (Professional Development Units). Each credit program has its own requirements and process. The course certificate an ONLC student receives is proof of course completion for credit submission. Learn more about professional credits click link.

 

Microsoft Office Training: Get 5 days for Price of 4

Train on Multiple Topics in Microsoft Office / Office 365 at a Savings!
Our 5/4 Office Saver gives you 5 training days on programs within Office for the price of 4. Your choice of topics (Excel, Word, PowerPoint and more), plus upgrade options. Find out more

spacer

Questions?

Our knowledgeable Education Advisors can provide personal guidance on our courses, certification and more. Contact an advisor via CHAT or by calling:

1.800.288.8221
(weekdays)

 

Locations

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com