Welcome to ONLC Training Centers
Learn Microsoft Access with training from ONLC!

Microsoft Office Access Training Classes

Learn Microsoft Access with the training experience that's best for you at ONLC. Our live, hands-on 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 with our self-study On-Demand Access classes.

Microsoft Access is the powerful relational database in Microsoft Office / Office 365. This information management tool lets users easily create tables, queries, forms and reports, and connects those elements together with macros. Access can also be used to analyze large amounts of information and manage related 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. There's also a VBA class in which users learn to write rich solutions with advanced data manipulation and user control.

Many of these 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. Get started learning Microsoft Access with classes at ONLC where you get to learn in the format that works best for you!

Two Ways to Learn

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, hands-on available at convenient ONLC centers or home. On-Demand courses are self-study (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.

Savings Options

Choose classes a la carte or our money-saving Bundles

Individuals needing multiple Access courses or MOS Access certification prep should check out our Microsoft Access Bundles for possible discounts and certification value-adds. Those with a volume need (multiple people, classes or topics) can receive discounting when training is purchased as an ONLC Saver Plan .

Access Group Training

Group Training from ONLC

Our Access Group Training solutions can help save both time and money upskilling your staff. Training can be public or private with instruction virtually or in-person. We can even customize course content to meet specific learning objectives, schedules and budgets! To learn more and for a price quote see Group Training .

 

 

Access Class Titles, Schedule & Prices


Attend our live, instructor-led 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!

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

 

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

 

Or

 See all Microsoft Office training classes at ONLC

 

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)


Learning Path for Microsoft Access Certification

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 product 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 6-months unlimited access and covers Microsoft Access 2016 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. Though taught using Access 2019 software, there are very few differences between those versions from a user's perspective. 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.


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

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 is 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 Access Classes from Home
You can attend our live, instructor-led 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 Access Training!
We have discounted bundles for those who need more than one 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. Training can be via our public schedule or private sessions delivered virtually or in-person on-site. 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 .

 

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

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
Virtual Access training
AlabamaBirmingham Access trainingHuntsville Access training
Mobile Access trainingMontgomery Access training
ArkansasBentonville Access trainingLittle Rock Access training
ArizonaMesa Access trainingPhoenix Access training
Scottsdale Access trainingTucson Access training
CaliforniaBakersfield Access trainingGlendale Access training
Irvine Access trainingLos Angeles Access trainingLos Angeles Access training
Manhattan Beach Access trainingOrange Access trainingPleasanton Access training
Riverside Access trainingSacramento Access trainingSan Diego Access training
San Diego Access trainingSan Diego Access trainingSan Francisco Access training
San Jose Access trainingWalnut Creek Access trainingWoodland Hills Access training
ColoradoBoulder Access trainingCentennial Access training
Colorado Springs Access trainingDenver Access trainingFt. Collins Access training
Grand Junction Access trainingLakewood Access trainingLoveland Access training
ConnecticutCheshire Access trainingDanbury Access training
Rocky Hill Access trainingShelton Access trainingStamford Access training
District of ColumbiaWashington Access training
DelawareWilmington Access training
FloridaBoca Raton Access trainingBonita Springs Access training
Bradenton Access trainingFort Lauderdale Access trainingFort Myers Access training
Fort Walton Beach Access trainingJacksonville Access trainingKissimmee Access training
Lakeland Access trainingMelbourne Access trainingMiami Access training
Miramar Beach Access trainingOrange Park Access trainingOrlando Access training
Orlando Access trainingPensacola Access trainingPlantation Access training
Tallahassee Access trainingTampa Access training
GeorgiaAlpharetta Access trainingAtlanta Access training
Duluth Access trainingKennesaw Access trainingMacon Access training
Martinez Access trainingSavannah Access training
IowaBettendorf Access trainingDes Moines Access training
IdahoBoise Access training
IllinoisChicago Access trainingGurnee Access training
Joliet Access trainingOak Brook Access trainingPeoria Access training
Schaumburg Access trainingWarrenville Access training
IndianaCarmel Access trainingEvansville Access training
Fort Wayne Access trainingGreenwood Access trainingIndianapolis Access training
South Bend Access training
KansasLenexa Access trainingWichita Access training
KentuckyFlorence Access trainingLexington Access training
Louisville Access training
LouisianaBaton Rouge Access trainingLafayette Access training
New Orleans Access training
MassachusettsBoston Access trainingBraintree Access training
Danvers Access trainingEast Longmeadow Access trainingNorth Andover Access training
Norwell Access trainingWoburn Access trainingWorcester Access training
MarylandAnnapolis Access trainingBethesda Access training
Columbia Access trainingFrederick Access trainingGermantown Access training
Greenbelt Access trainingOwings Mills Access trainingRockville Access training
Towson Access training
MainePortland Access training
MichiganAnn Arbor Access trainingGrand Rapids Access training
Kalamazoo Access trainingLivonia Access trainingNovi Access training
Southfield Access trainingTroy Access training
MinnesotaBloomington Access trainingMaple Grove Access training
Minneapolis Access trainingWoodbury Access training
MissouriColumbia Access trainingLee's Summit Access training
O'Fallon Access trainingSpringfield Access trainingSt. Louis Access training
St. Louis Access training
MississippiRidgeland Access training
MontanaGreat Falls Access training
North CarolinaAsheville Access trainingChapel Hill Access training
Charlotte Access trainingCharlotte Access trainingFayetteville Access training
Greensboro Access trainingRaleigh Access trainingRaleigh Access training
Wilmington Access training
North DakotaFargo Access trainingGrand Forks Access training
NebraskaOmaha Access training
New HampshireBedford Access trainingConcord Access training
Portsmouth Access training
New JerseyBridgewater Access trainingMahwah Access training
Morristown Access trainingMount Laurel Access trainingParamus Access training
Princeton Access trainingRed Bank Access training
New MexicoAlbuquerque Access training
NevadaHenderson Access trainingLas Vegas Access training
Reno Access training
New YorkAlbany Access trainingBohemia Access training
Brooklyn Access trainingBuffalo Access trainingLiverpool Access training
Mt. Kisco Access trainingNew York Access trainingRochester Access training
Uniondale Access training
OhioBeachwood Access trainingBeavercreek Access training
Cincinnati Access trainingCincinnati Access trainingCleveland Access training
Columbus Access trainingColumbus Access trainingDublin Access training
Independence Access trainingToledo Access trainingWestlake Access training
OklahomaOklahoma City Access trainingTulsa Access training
OregonPortland Access trainingSalem Access training
PennsylvaniaAllentown Access trainingConshohocken Access training
Erie Access trainingHuntingdon Valley Access trainingLancaster Access training
Malvern Access trainingMechanicsburg Access trainingPhiladelphia Access training
Pittsburgh Access trainingPittsburgh Access trainingSouth York Access training
State College Access trainingWexford Access training
Rhode IslandWest Warwick Access training
South CarolinaColumbia Access trainingGreenville Access training
Mt. Pleasant Access trainingNorth Charleston Access training
TennesseeKnoxville Access trainingMemphis Access training
Murfreesboro Access trainingNashville Access training
TexasAllen Access trainingAmarillo Access training
Austin Access trainingAustin Access trainingBryan Access training
Dallas Access trainingDallas Access trainingDenton Access training
El Paso Access trainingFort Worth Access trainingHouston Access training
Irving Access trainingKaty Access trainingKeller Access training
Plano Access trainingSan Antonio Access trainingSan Antonio Access training
Southlake Access trainingSugar Land Access trainingThe Woodlands Access training
UtahProvo Access trainingSalt Lake City Access training
VirginiaAlexandria Access trainingArlington Access training
Charlottesville Access trainingFairfax Access trainingForest Access training
Fredericksburg Access trainingGlen Allen Access trainingHerndon Access training
Manassas Access trainingMcLean Access trainingNorfolk Access training
Reston Access trainingRichmond Access trainingRoanoke Access training
Stafford Access trainingVirginia Beach Access training
WashingtonBellevue Access trainingBothell Access training
Federal Way Access trainingLacey Access trainingPuyallup Access training
Seattle Access training
WisconsinBrookfield Access trainingGreen Bay Access training
Madison Access training
West VirginiaMartinsburg Access training
WyomingCasper Access trainingCheyenne Access training
ONLC TRAINING CENTERS
800-288-8221
www.onlc.com