Learn Microsoft Access with live, hands-on training classes that are led and supported by a seasoned instructor with decades of experience teaching and using Access software.
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 courses 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, dedication to your career and be a value to business. Start learning Microsoft Access now by attending training classes with ONLC where you get to learn data analysis in the format that works best for you!
Experience hands-on learning with our live, instructor-led Microsoft Access classes, delivered by an expert trainer online. Through our interactive format, the trainer can view your work in real time and provide immediate assistance directly on your computer. You can ask questions or receive personalized feedback throughout the class, ensuring an engaging and fully interactive experience. Access training classes are available at convenient ONLC centers or attend from your own location. Ready to get started? 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 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. We ensure your team gains the essential knowledge and expertise to master Access. 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.
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
"J. really knew the content and made it easy to understand. I was very anxious about taking the course, but the instructor made it easy to navigate."
– Kathy P.
"I enjoyed the class and am excited to start using what i learned to create reports."
– Peggy C.
"Thanks for making it easy to take it remotely from my office, saved trip into the city!"
– Bharati L.
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.
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.
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.
Though there are several formats available, one of the most thorough and common ways to learn Microsoft Access is by attending instructor-led training. In this format a professional already familiar with the software and possibly how it interacts with other programs within the Microsoft Office suiste, will work with you directly so you can gain knowledge and know-how using the product. As you become more comfortable with hands-on practice and use, its easy to then progress to more advanced topics like 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").
Microsoft 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 training (ILT) class for every ONLC center. 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 .
Attend 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.
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 offered at our locations listed below. (Click the plus sign to show sites grouped by state.)
LinkedIn
YouTube
Instagram
TikTok
Facebook