We are generating data all the time. It’s important to take control of that data, and organize and display it to gain meaningful insights. That’s where Microsoft Access – a database management system – comes into play.

Software developers, data architects and power users, as well as non-developers use Microsoft Access to create database apps. Access is supported by Visual Basic for Applications (VBA, a programming language) that helps automate processes.

This Best Courses Guide (BCG) has a selection of the best Microsoft Access online courses from over 90 Microsoft Access courses in our catalog, including popular offerings from Udemy, LinkedIn Learning, and YouTube. From beginner to more advanced techniques, you can elevate your MS Access skills by learning from experts.

Check our BCGs on other Microsoft software: Microsoft Word, Microsoft Excel and Microsoft PowerPoint.

Click on the shortcuts for more details:

• Our Top Picks
• BCG Stats
• Why You Should Trust Us
• How We Made Our Picks and Tested Them

Our Top Picks

BCG Stats

• Combined, these courses have accrued over 297K enrollments
• 3 courses are free and 5 courses are paid
• The most-represented course provider in the ranking is Udemy, with 3 courses
• The Microsoft Access subject is followed by over 9.6K learners on Class Central.

Best Microsoft Access Course for Beginners (Udemy)

If you’re just starting out with Access 2016 or want to learn more advanced skills, Microsoft Access 2016 Master Class: Beginner to Advanced takes you through the basics to complex concepts, complete with practice opportunities.

In this course, you’ll:

• Understand the construction of Access and familiarize yourself with its main objects
• Learn the layout and components of the interface
• Master the properties and functions of tables, reports, and queries
• Comprehend the essentials of form objects
• Implement automation in forms using buttons and macros
• Create a multi-page invoice.

Fun Facts

• Parys is an online instructor, entrepreneur and international speaker, who is also the founder of The Joe Parys Academy
• He also teaches cryptocurrency, business, entrepreneurship and investment on his YouTube channel
• Myron is a self-employed Access programmer and general computer consultant to small and medium sized businesses.

Also Great Microsoft Access for Beginners (Udemy)

Fine tune and expand your database management skills. Microsoft Access: Complete MS Access Mastery for Beginners is for learners starting from scratch. You will gradually move up the difficulty and become more comfortable with the software.

In this course, you’ll:

• Create a simple database from scratch in Access
• Learn to create and modify tables for data organization
• Design forms for data entry into tables
• Develop queries to extract and analyze database information
• Generate reports for effective data sharing and presentation.

Fun Facts

• McDonald has over 400K students on Udemy. He teaches Excel, Access and Photoshop.

Best Short Microsoft Access 2019 Training (LinkedIn Learning)

If you want to learn the essential concepts of Access 2019 quickly and easily, Access 2019 Essential Training is a great course. Within a matter of hours, you’ll get started with Access and implement your skills in building better databases.

In this course, you will learn:

• Get acquainted with Access fundamentals, including database creation, Trust Center, and Ribbon interface
• Learn table creation, data types, key usage, and table importation
• Set field properties, manage data integrity, and utilize input controls
• Organize records through sorting, filtering, and data manipulation
• Utilize queries to search and structure data, including using wizards and criteria
• Generate and customize forms for data entry and navigation
• Create detailed reports with sorting, calculations, and formatting
• Perform database maintenance, such as compacting, repairing, and securing data.

Fun Facts

• Wilbert has spent over 5 years as a consultant and trainer helping clients use Access and Excel
• He has developed Access databases for National Park Service managers and U.S. Geological Survey scientists
• His training events benefit private firms such as Boeing and Verizon, NGOs, and government employees.

Best Short Course on Building Dashboards for Excel (LinkedIn Learning)

Learn how you can combine Microsoft Access and Excel to create interactive dashboards with Access 2019: Building Dashboards for Excel. Once you complete this course, you’ll be able to create charts, graphs and engaging visualizations that update in real time.

In this course, you will learn:

• Overcome Excel’s limitations using Access for advanced data management
• Access’s structure, including table views and linking external data
• Database tables, focusing on normalization and understanding relationships and keys
• Data querying in Access with sorting, filtering, and SQL view for unique datasets
• Export and refresh data between Access and Excel, maintaining connections
• Dynamic Excel charts, pivots, and layouts using advanced visualization tools
• Excel dashboards automation with tailored macros for filtering and navigation.

Fun Facts

• Hunt teaches Excel, Power Query, PowerBI, database design and SQL querying and Data+.

Best Intro to Macros and VBA Course (Udemy)

In Microsoft Access Complete Beginner to Advanced, you’ll start at the basic level and progress to more advanced levels with each section. This comprehensive course aims to give you a complete understanding of Access from the foundation to intermediate and advanced level.

It consists of four different sub-courses:

• Microsoft Access 101 – Access and table design
• Microsoft Access 102 – Access queries
• Microsoft Access 103 – Form and reports
• Automate Microsoft Access Tasks with Macros and VBA – Macros and VBA

Fun Facts

• Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor
• He has provided training for top companies such as Brocade, Chevron, Genentech, Facebook, Levi Strauss, PMI Mortgage Insurance, State Fund, Bank of the West, VISA, Walmart, and many more!

Best YouTube Tutorials

Microsoft Access Tutorial: 7 Hours of Beginner to Advanced Training (Simon Sez IT)

Work with your databases more efficiently with Microsoft Access Tutorial: 7 Hours of Beginner to Advanced Training. This free course takes you from the very basics of Microsoft Access 2019 to more advanced concepts. It also includes practical exercises with downloadable files.

In this course, you will learn:

• Introduction to Access basics: Utilizing database templates, managing databases, navigating the Access interface, and using help resources
• Table operations: Creating and indexing tables, importing from Excel, and managing data in Datasheet View
• Advanced database concepts: Working with Primary Keys, customizing views, and linking to external tables
• Technical database management: Installing SQL Server Express, splitting databases, and configuring macro security settings.

Microsoft Access Complete FULL Courses (Computer Learning Zone)

Everything you need to know to get up and running with Access, you will find in Microsoft Access Complete FULL Courses. Even though there are only two videos in this free course, it is quite comprehensive. This course is useful for any version of Access.

In this course, you will learn:

• Discover the basics of Microsoft Access, including its purpose and database terminology
• Learn to create and structure databases, tables, and fields
• Master the Access Interface, including document views and table creation
• Understand data management, including editing, sorting, and filtering data in tables
• Explore query creation with sorting and criteria to analyze data
• Gain skills in form and report design, and apply advanced formatting techniques
• Review practical applications, security settings, and course material consolidation.

Fun Facts

• Computer Learning Zone specializes in teaching Microsoft Access, Word, Excel, Windows, and more
• They also give free computer lessons on their official website
• Rost was awarded Microsoft MVP in 2014 and 2015, and has been a computer consultant and trainer since the early 90s.

Access Beginner Tutorial (Learnit Training)

Access Beginner Tutorial is a short and beginner-friendly free course. It teaches you Microsoft Access from the ground up so that you can be confident in your database creation and management skills. Knowledge of spreadsheet programs like Excel is recommended for this course. It also includes practical exercises with downloadable files.

In this course, you will:

• Familiarize yourself with Access by opening a sample database, navigating through tables, queries, forms, and reports, and learning basic operations
• Learn table creation in Design View, record your first entry, use Quick Starts for tables and data, and draft a preliminary database design
• Understand relationship creation using Lookup lists, explore the Relationships window, and practice relating fields by dragging names
• Develop 1-to-1 relationships, convert relationships to Lookup relationships, manage limit-to-list properties, enforce referential integrity, and apply cascading edits and deletions.

Fun Facts

• Learnit Training provides courses on a wide range of software and subjects from Microsoft Excel to Adobe Photoshop and Microsoft Teams
• You can find more learning resources on their official website.

Why You Should Trust Us

Class Central, a Tripadvisor for online education, has helped 60 million learners find their next course. We’ve been combing through online education for more than a decade to aggregate a catalog of 200,000 online courses and 200,000 reviews written by our users. And we’re online learners ourselves: combined, the Class Central team has completed over 400 online courses, including online degrees.

I used Microsoft Access during my school days. When we were being taught SQL (Structured Query Language) using MySQL (an open-source relational database management system), my father taught me to run the same commands in Microsoft Access. I also watched him do more complex tasks in Access which I am yet to master.

Besides that, I am a Guided Project Instructor and a Beta Tester at Coursera, having tested many courses before they’re officially launched. I have taken over 50 online courses in various subjects. My experience as an online learner and teacher has given me some perspective on what to look for in an online course. I used my experience to evaluate each course in this list.

How We Made Our Picks and Tested Them

Trying to find “the best” can be daunting, even for those of us who live and breathe online courses. Here’s how we approached this task.

First, we combed through Class Central’s Catalog and the internet to find a variety of free and paid courses.

Second, when choosing courses, we considered the following factors:

• Instructor experience: we looked for certified instructors with extensive experience in MS Access and databases.
• Course content: we looked for courses that covered a wide range of topics, from the basics to more advanced techniques.
• Student reviews: we read student reviews (when available) to get a sense of the quality of each course.

To evaluate each course, we watched some of the course videos and read the course syllabus. We also looked at the course’s rating and reviews on Class Central.

Ultimately, we used a combination of data and our own judgment to make these picks. We’re confident these recommendations will provide you with the knowledge to manage your databases with Microsoft Access confidently.

Fabio has revised the research and the latest version of this article.