Skip to content
#1 in Microsoft AccessUdemyMicrosoft AccessPaid courseAll LevelsCertificate

Microsoft Access 2016 Master Class: Beginner to Advanced (Udemy.com)

Quickly learn how Microsoft Access 2016 can make your life easier and more productive!

Created by: Joe Parys

Last updated July 2024

Our take

Based on the ratings of 14,398 students, a sample of their written reviews and the syllabus, as the course stood in July 2024. No course pays to be reviewed.

This is a 7-hour Access course in 74 lectures and 17 short sections. It opens with the data problems Access solves, then covers tables, queries, reports and forms twice, once at basic level and again at advanced level. It finishes with buttons, macros and a multi-page invoice. No Access experience is assumed, only Office 2010 or later and basic Windows skills. More than 58,000 students have enrolled, and the 4.8 average rests on over 14,000 ratings.

Reviewers mostly credit the teaching. Bruce Myron, the co-instructor they keep naming, is praised for explaining when and why to use a feature, and for making common mistakes on purpose so he can show the fix. One reviewer says the course helped land a job that required Access. The complaints are small. About 8 percent of ratings are three stars, and the one low review in the sample says the course left gaps for a custom project and a more basic start was needed.

The last update was July 2024, so the course is a little over two years old and built on Access 2016. Screens in a newer install may differ slightly. At seven hours it is a quick start, not a deep reference. For anyone who wants a clear first database with forms and reports, it is an easy recommendation. If heavy automation or VBA is the goal, the Access VBA course listed beside it is the better next step.

Best forOffice workers and small-business owners who want to build a working database with forms and an invoice, starting from zero.
Skip it ifYou already build Access databases and want deep VBA or SQL; the syllabus is built around core objects and macros.

Pros

  • Instructor explains when and why to use each feature, not just which button to click
  • Deliberately makes common mistakes, then shows how to fix and avoid them
  • Ends with a multi-page invoice build that ties tables, queries and forms together
  • Short lectures, 13 quizzes and downloadable resources make it easy to follow in small sittings

Cons

  • Last updated July 2024, and it is built on Access 2016, so newer screens may differ
  • Only about seven hours, so it may leave gaps for a custom project
  • The syllabus covers macros and buttons but has no dedicated VBA section
Bruce is an excellent instructor! Everything was clearly delivered and he explained not just how to use the various functions of Access, but when and why one might use them.
Johnathan Straube, a student

Newcomers fit best: no Access knowledge is needed, just Windows basics and Office 2010 or later installed.

icon
What you will learn

  • Understand how Access is constructed and how to use the major objects within it.
  • Discover THREE Major Data Problems That Access Completely Resolves
  • Learn the parts of the Access screen
  • Learn table, report and query objects
  • Master PROPERTIES to make thousands of choices manageable
  • Learn the basics of form objects
  • Fully understand tables, queries, reports and forms
  • Use automation in your forms with buttons and Macros
  • Create a multi page invoice

Course content

17 sections · 74 lectures · 7.2 hours of video 13 quizzes, 2 articles

  1. 1Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course! 2 free previews2 lectures · 2 min
  2. 2THREE Major Data Problems That Access Completely Resolves 2 free previews5 lectures · 16 min
  3. 3Learning the Parts of the Access 2016 Screen 1 free preview3 lectures · 1 quiz · 13 min
  4. 4TABLE Objects - the Basics5 lectures · 1 quiz · 36 min
  5. 5REPORT Objects - the Basics3 lectures · 1 quiz · 19 min
  6. 6QUERY Objects - the Basics5 lectures · 1 quiz · 27 min
  7. 7PROPERTIES: Making Thousands of Choices Manageable4 lectures · 1 quiz · 26 min
  8. 8FORM Objects - the Basics4 lectures · 1 quiz · 27 min
  9. 9Advanced TABLES4 lectures · 1 quiz · 23 min
  10. 10Advanced QUERIES8 lectures · 1 quiz · 46 min

Who it is for

The instructor says it suits

  • Anyone who is dissatisfied with how they are handling data now and know there must be a better way
  • Anyone who has attempted to learn Access before without success
  • Entrepreneurs, office workers, teachers and students wanting to work with databases

What you need before you start

  • Have Microsoft Office 2010 or later installed
  • General knowledge of working with Windows
  • You DO NOT need prior knowledge of Microsoft Access

How it compares

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

  • Rating4.8 out of 5higher than 80% of them
  • Reviews14,398#1 of 48 by number of reviews
  • Length7.2 hourslonger than 63% of them
  • Last updatedJuly 2024more recently than 72% of them

icon
Course Description

Have you always wanted to learn Microsoft Access but you just don't know where to start?

Or maybe you have started but you just don't know how to use some of the more advanced features.

Then our complete Microsoft Access 2016 Master Class: Beginner to Advanced is for You!

_________________________________________________________________________

Welcome To the “Microsoft Access 2016 Master Class: Beginner to Advanced.”

⇉ Join 950,000+ Students Who Have Enrolled in our Udemy Courses!

⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results!

⇉ You Get Over 75 Lectures and 7+ hours of premium content

⇉ Watch the Promo Video to see how you can Get Started Today!

_________________________________________________________________________

What do you get with this course?

  • Hours of easy-to-watch video lessons

  • Downloadable Resources

  • Practical activities

  • Instructor support if you have any questions

  • Community of students ready to help

What will you learn in this “Microsoft Access 2016 Master Class: Beginner to Advanced.”

In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Access course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Access.

You'll start by an overview of the course and learn how to get started with Microsoft Access.

You'll then learn three major data problems that Access completely resolves.

Once you understand how to resolves these three major data problems, you will learn about the parts of the Access screen, table and report objects, query objects and properties, form objects and advanced tables, advanced queries and reports, advanced forms and automating things in your forms, more form automations like buttons and macros, and how to create a multi page invoice.

By the end of our course you will:

  • Understand how Access is constructed and how to use the major objects within it.

  • Discover THREE Major Data Problems That Access Completely Resolves

  • Learn the parts of the Access screen

  • Learn table, report and query objects

  • Master PROPERTIES to make thousands of choices manageable

  • Learn the basics of form objects

  • Fully understand tables, queries, reports and forms

  • Use automation in your forms with buttons and Macros

  • Create a multi page invoice

  • And more...

Ready to get started?

Once you enroll, we recommend students install Microsoft Access on their computers to follow along.

_____

See What Current Students Are Saying About Our Course:

“It did take me a while to get thru this course due to other commitments, but I did find the course to be very informative as I'm a newbie to using Access and wanted to get up and running with as much knowledge as I could. Some sections were "over my head", but that is all part of learning something new. Thanks for taking the time to put this course together.”
-Todd Atkinson

"Great course to learn a new skill. And it go from zero to Hero. Now i need to apply this knowledge to create my own database. Thank you very much and wish you a lot of satisfied students like I am. :)"
-Tibor Molnar

"What makes this an amazing course. Easy to follow instructions. The audio, visuals and the transcripts were extremely helpful. Great response when asking a question. The course allows you to review the course or parts of thereof. This was a new experience (for a retired person), never took an online course. Just signed up for your VBA course. Thank you for making this a valuable and interesting course."
-Donna

_____

Who are your instructors?

We are Joe Parys and Bruce Myron, creatives who have taught over 950,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Access. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world.

Our goal is to show you the real world and practical ways to start using Microsoft Access with confidence today!

_________________________________________________________________________

With the right mindset, understanding, and application, you will instantly begin learning how to build databases with Microsoft Access.

When I learn something new I add it to the course - at no additional cost to you!

This is a course that will continue to add more and more to every aspect of your life.

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But it can be done!

I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

_________________________________________________________________________

It's time to take action!

Our happiness guarantee

This course includes a money back guarantee, so there is no risk to try it out.

Sign up today, see if it's the right one for you.

Enroll now.

Sincerely,

Joe Parys and Bruce Myron.

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

Joe Parys

Why are 950,000+ students enrolled in my online courses?

1) I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you achieve real results and change your life today.

3) My dedication to teaching online. I have been named a top instructor on Udemy

► Try enrolling in a course with me and see for yourself ◄

__________________________________________________________________

About Joe Parys:

Joe Parys is a bestselling online instructor, entrepreneur, and international speaker whose eLearning courses have been featured on Udemy, Buzzfeed, CBS News, and many other professional platforms.

Business:

The Joe Parys Academy is a Leader in the E-Learning Industry with more than 97+ Co-Authored Courses.

The Founder of The Joe Parys Academy, Joe Parys, is a Bestselling Online Instructor with more than 900,000+ students from around the world.

My CV:

Joe has his bachelors degree from Coe College in Cedar Rapids, IA. He was a four year varsity letter winning college athlete in the sport of men's basketball. He is also a coach for USA basketball.

He is a Licensed Psychology, History and Government teacher for grades 5-12. He has been teaching High School for the past three years.

icon
More courses by Joe Parys

$69.99

$11.99

$14.99

$64.99

$84.99

$99.99

icon
More Microsoft Access courses

$64.99

$64.99

$64.99

$74.99

$74.99

$59.99

icon
Reviews

4.8

14,398 ratings on Udemy

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

By Melissa March on 2/9/2026

I had a database I was paying for monthly that hadn't changed in the 15 years I was using it. It seemed basic enough that I thought if I learned Access Database I could cancel that subscription. Bruce was wonderful to listen to and really took you through all the steps a beginner would need to know. I feel confident that I will be able to finalize my database based on the information I learned in here. My database will be for hard copy file management, so a lot of the calculations and invoicing lessons were not as necessary, but I loved learning about all the things Access can do! I look forward to learning more from Bruce in his other courses on Access.

By Gerald Alimon on 1/13/2026

Bruce Myron is probably the most knowledgeable person with such a specialist software such as MS Access. The course was setup really well and he has fine tuned this course using various student feedback to be the best that it can be. The only reason I took the course was because it was required for a job I wanted. And amazingly I managed to be confident enough to apply and was given the role!

By Lt on 8/4/2022

Bruce is a great teacher! He very specific to making sure he stays on task, great at break down information at layman’s terms, so anyone could learn how to use this program. I also appreciate that he’s open to student feedback on “better practices” within Access. I noticed that he has VBA classes available but they’re not grouped. Haven’t checked yet but it may be the amount of information covered. Great course to you both!

By Linda Dailey on 11/22/2020

Info on manipulating YOUR tables, creating reports and running the queries is okay, but I really expected that creating a table by importing an Excel spreadsheet would have been one of the first things taught. I have an Excel spreadsheet, but so far this course hasn't helped do what I need to because I don't even know how to get my data into Access to run the queries, etc., yet! And I'm not going to retype my whole spreadsheet into an Access table.

By Jamie Tang on 11/15/2020

Great! Thank you!

By Randell Krug on 11/8/2020

This course is more straight-forward than I expected it to be, which is a compliment.

By Robin Peterson on 11/8/2020

This is very easy to follow and understand, I like the practical application using Access alongside the lesson so I can physically become familiar with the steps. Love all the quick key codes to save time while formatting or viewing and editing the data.

By Kenneth Rosenquest on 11/8/2020

This course did a great job of breaking down the basics of Access and building on those basics to more advanced methods.

By Juan Roldn on 11/8/2020

It's a good course if youre a beginner like I am

By Rcrane on 11/8/2020

This was a good beginners course but when you got to the VBA & macro's it moved to quickly. I also think that more time should be invested in the design of the database as it all flows from there.

By Allanah Hund on 11/8/2020

I am a beginner to Access and hardly knew anything about how to use it. This course really helped me feel less overwhelmed and confident in my ability to use Access moving forward.

By David Alarco Casaas on 11/1/2020

Muy buen curso para comenzar a usar Access. Explica de forma muy clara y sin desviar la atencin los elementos fundamentales, para poder construir una base slida sobre la que poder avanzar ms adelante con conocimientos de ms detalle.

Showing 12 of 310 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 : 96 / 100