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 Access is a powerful relational database management application that is part of Microsoft's Office / 365 suite. 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 be a value to business. Start learning Microsoft Access now by attending classes with ONLC where you get to learn data analysis in the format that works best for you!
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. Jump to Microsoft Access class titles, prices & dates.
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 .
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 .
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!
In the list below, click the title of the Microsoft Access course 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.
| 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
| 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 other Microsoft Office On-Demand Courses
Bundles must be purchased by phone: 1-800-288-8221 (weekdays). For course outlines and upcoming ILT dates click the course title in the table. Access MOS certification learning paths are provided below the table.
| Access Training Bundles | Complete (ILT+On-Demand) |
All ILT (ILT only) |
On-Demand (Self-study only) |
| Instructor-Led Training (ILT) | |||
Access Introduction
(2 days) |
✔ |
✔ |
— |
Access Advanced
(2 days) |
✔ |
✔ |
— |
| On-Demand Training | |||
Access On-Demand Comprehensive
Comparable to Intro & Advanced titles |
✔ |
— |
✔ |
Hard copy workbook for On-Demand |
✔ |
— |
✔ |
Retail Total: |
$495 |
||
Training Bundle: |
$1,395 |
$1,195 |
$495 |
| Optional MOS Certification Add-on (retail value over $200) * | |||
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
|
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.
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)
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 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
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 or 2016. 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.
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 has a learning curve, but it's manageable for most users. With structured training and practice, beginners can grasp the basics within a few weeks. The difficulty level depends on your prior database experience and familiarity with other Microsoft Office products. Our training classes are designed to make learning Access accessible and straightforward for all skill levels.
The time required to learn Microsoft Access varies depending on your goals and prior experience. Basic proficiency can typically be achieved in 20-30 hours of focused study and practice. Mastering advanced features may take several months. Our training courses are structured to provide a solid foundation in just a few sessions, with options for more in-depth learning.
The best way to learn Microsoft Access is through a combination of hands-on practice, structured training, and online resources. Start by taking an introductory course, either online or in-person, that covers the basics of database creation, table relationships, queries, and forms. Follow this up with hands-on practice by building your own databases or using sample databases to reinforce key concepts. Additionally, there are many free resources available, including Microsoft�s tutorials, YouTube videos, and Access-specific forums where you can find solutions to common challenges. As your skills improve, consider more advanced training to learn automation techniques using macros and VBA.
While knowledge of Excel can be helpful, it's not a prerequisite for learning Microsoft Access. The two programs serve different purposes - Excel is a spreadsheet tool, while Access is a relational database management system. However, understanding Excel may give you a head start in grasping some concepts in Access, especially if you're familiar with functions and data organization.
Access and Excel are designed for different tasks, so one isn't necessarily "better" than the other. Excel is ideal for spreadsheets, calculations, and simple data storage. Access is superior for managing large amounts of related data, creating complex queries, and building data-driven applications. For database management and relational data structures, Access is the more powerful tool.
Microsoft Access doesn't require coding for basic operations. Many tasks can be accomplished using the graphical interface and built-in wizards. However, learning some VBA (Visual Basic for Applications) can greatly enhance your ability to automate tasks and create more sophisticated database applications. Our training courses cover both code-free usage and introductory programming concepts.
Microsoft Access remains in demand as a vital database management tool, particularly in small to medium-sized businesses and enterprise departments. Organizations continue to rely on Access for custom business applications, data management solutions, and process automation. Its seamless integration with Microsoft 365 makes it especially valuable. The job market consistently seeks professionals skilled in Access database development, custom forms and reports, VBA solutions, and system maintenance. Learning Microsoft Access is a valuable investment for IT professionals, business analysts, and data management specialists looking to enhance their career opportunities.
Microsoft Access training is a structured learning program designed to teach users how to effectively use the Access database management system. It typically covers database creation, table design, query building, form and report generation, and data analysis techniques. Our training classes offer hands-on experience, expert instruction, and practical exercises to help you become proficient in using Access for your specific needs.
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.
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 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 .
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.
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 Microsoft Access Bundles
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
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 .
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
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)
Looking for Microsoft Access classes near you? All of our Microsoft Access training is available at our locations listed below. Click the plus sign on the right to expand and show the sites grouped by state.
Facebook
LinkedIn