Skip to content
#5 in Microsoft AccessUdemyMicrosoft AccessPaid courseAll LevelsCertificate

Microsoft Access: Complete MS Access Mastery for Beginners (Udemy.com)

Beginning Microsoft Access mastery. Design Access databases from scratch. For Access 2010, Access 2013, and Access 2016.

Created by: Steve McDonald

Last updated October 2021

Our take

Based on the ratings of 2,325 students, a sample of their written reviews and the syllabus, as the course stood in October 2021. No course pays to be reviewed.

Steve McDonald's course is a 7.2 hour walkthrough for people who have never opened Access, or who know a little Excel and want to see how a database works. It runs 54 lectures across 14 sections: tables, database design, field properties, forms, queries and reports. Then comes a short VBA intro, an advanced form built start to finish, and a glossary of hands-on definitions. It is taught on Access 2016, and the headline also names 2010 and 2013. About 21,500 students have enrolled.

Reviewers mostly praise the teaching. They call it clear, direct and easy to follow, with a pleasant voice, and say working alongside the videos helps. One learner built a multi-query database that sped up their job. One experienced user says the tips still taught them something. The complaints cluster around a few spots. The VBA section confuses people: one reviewer replayed it repeatedly and still hit errors. Another says a lesson on query criteria using Like can't be reproduced as shown. One harsh review calls the course too theoretical and light on the hard parts.

Value is decent for a first pass. Roughly nine in ten of the 2,325 ratings are four or five stars. The last update was October 2021, so newer Access builds may look different, and one reviewer did not get the pop-ups shown in the lessons and suspects a settings difference. There are no quizzes or assignments, so practice is up to you. Treat it as a gentle start on tables, queries, forms and reports, and look elsewhere if VBA is your real goal.

Best forOffice workers brand new to Access who want a calm, short walkthrough from tables to reports.
Skip it ifYou want real VBA depth or practice exercises, or you use a much newer Access than 2016.

Pros

  • Reviewers call the teaching clear, direct and easy to follow, with a pleasant voice
  • Builds one database from tables through queries, forms and reports
  • At 7.2 hours and 54 lectures, it is a manageable first pass at Access
  • One experienced user still finds the tips useful, and another sped up real work tasks

Cons

  • The 29-minute VBA intro leaves several reviewers lost and stuck on errors
  • No quizzes or assignments, and the last update was in 2021, so newer Access may differ
  • Reviewers report one query lesson using Like that cannot be reproduced as shown
Steve is a great instructor, and I learned a lot from this course. With the knowledge from this course, I was able to create a database with multiple queries that helps me perform my job duties significantly more quickly.
Nick Olmanson, a student

Brand-new users with basic computer skills. The course says no Access or Excel experience is required.

icon
What you will learn

  • At the end of this course, you will be able to create a simple DATABASE in Access from scratch.
  • You will know how to create and modify TABLES in Access.
  • You will know how to create FORMS for enter data into your tables.
  • You will know how to create QUERIES to ask questions of your Access database.
  • You will know how to create REPORTS for sharing and presenting your data in a clear, professional way.

Course content

14 sections · 54 lectures · 7.2 hours of video 4 articles

  1. 1Introduction to Access 3 free previews3 lectures · 32 min
  2. 2Tables in Access 2 free previews4 lectures · 40 min
  3. 3Database Design in Access 1 free preview3 lectures · 26 min
  4. 4Field Properties in Access Tables 1 free preview3 lectures · 36 min
  5. 5Forms in Access 1 free preview4 lectures · 54 min
  6. 6Queries in Access3 lectures · 35 min
  7. 7Reports in Access2 lectures · 19 min
  8. 8Options Menu in Access2 lectures · 20 min
  9. 9Exporting Data1 lecture · 5 min
  10. 10Intro to VBA in Access 1 free preview5 lectures · 29 min

Who it is for

The instructor says it suits

  • Anyone who needs to learn Microsoft Access, but might be intimidated or feel overwhelmed by it.r
  • This course is for students brand new to Access.
  • This course is also for students who have some experience with Access or Excel and need to learn more about Access.

What you need before you start

  • You just need to have a PC, basic computer skills and an installed copy of Microsoft Access on your computer.
  • You don't need any previous experience with MS Access or Excel.
  • This course starts at the very beginning.

How it compares

Against the other 47 rated Udemy courses in Microsoft Access on CourseDuck:

  • Rating4.5 out of 5higher than 29% of them
  • Reviews2,325#5 of 48 by number of reviews
  • Length7.2 hourslonger than 63% of them
  • Last updatedOctober 2021earlier than 63% of them

icon
Course Description

Welcome to the Access 2016 course. 

Thank you so much for joining me. 

  • Do you need to learn Microsoft Access, but feel intimidated or
    overwhelmed by the thought of it?

  • Are you ready to learn a ton of practical, hands on Access skills?

If so, you found the right course!

This course is designed to get you feeling comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.

Is it the Right Fit?

Will this course be a good fit for you? Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine tune and expand your skills in an easy, stress-free way.

Skills to Impress Your Boss

While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.

Start at the Very Beginning

We'll start out with a complete tour of Access and it's tools. Then, I'll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.  

Create a Database from Scratch

  • I'll walk you through creating a complete Access database from scratch. 

  • I'll show you how to create tables and connect those tables to each other using relationships. 

  • I'll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss. 

  • I'll also share insights and productivity tips along the way.   

Let's Get Started!

Are you ready to take your productivity and hopefully even your job prospects to the next level? Let's get started with Access 2016.

Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Steve McDonald

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. 

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.  I believe in you, and I'm here to support you in your learning process.

icon
More courses by Steve McDonald

$24.99

$12.99

$79.99

Free

Free

$64.99

icon
More Microsoft Access courses

$64.99

$64.99

$11.99

$64.99

$74.99

$74.99

icon
Reviews

4.5

2,325 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Sandra Friedemann on 2/25/2026

It's been more than 15 years since I last created an Access database with dependencies and I selected this course as a refresher. The presenter is confident and thorough. In the first segment my first goal was realized - I experienced a great "Ah HA!" moment. I'm looking forward to the rest of this series.

By Nick Olmanson on 1/18/2024

Steve is a great instructor, and I learned a lot from this course. With the knowledge from this course, I was able to create a database with multiple queries that helps me perform my job duties significantly more quickly. I found the VBA section slightly confusing, but Steve mentioned that it's just a quick review of VBA and will probably be confusing. Overall, I highly recommend this course for anyone interested in unlocking the power of Access.

By tri wulunggani on 8/27/2021

This course is great at providing fundamentals of database for anyone who never learned database. I used this course as knowledge refreshment / brush up about DB. The author, Steve, is very patient in explaining each section. Not too fast and not too slow. I like how he delivered it. I really recommend this course for anyone who has no background or prior knowledge / experience in DB. Thanks Steve.

By Nick Vanaken on 5/16/2021

Not happy with this course at all. its only theoretic bullshit and not practical at all. He complicates the most simplest of steps and for the difficult part of the course, he kinda says you have to figure out that yourself. worst course on Udemy so far.

By Christina Uduefe on 11/15/2020

Very Dated Course. Professor does not answer emails.

By Kishore Gopinath R on 11/8/2020

great

By Louie on 10/27/2020

Excellent course! I got so confident in working with MS Access after taking this course. There's a lot more to work on but I must say that coming from zero knowledge, this one is a great starter!

By Senthil Kandasamy on 10/23/2020

Good, Great

By Andre Chaison on 10/10/2020

Easy to follow. Heading to next section.

By Stephanie Thompson on 10/9/2020

It was a good overview for the current Access program. I need to figure how to use it for the older version at work. Since its not the same.

By John Paul S on 9/22/2020

ok

By Ajit Menon on 9/15/2020

The lesson is helpful

Showing 12 of 202 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100