Microsoft Access 2019 Advanced Training Course

The next step to supercharge your Microsoft Access and data analysis skills

  Get Started Now

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it's far more user-friendly and ideal if you're not a developer.

In this Microsoft Access advanced course, we start where the beginner's course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms, and how to run simple queries.

In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive on using Macros and VBA in Access, splitting databases and advanced form creation. It's perfect if you have a working knowledge of Access but need to utilize it's more advanced features.

In this course you will learn:

  • All about Primary Keys and Indexes in Access
  • About customizing and filtering on the Datasheet View
  • How to link to other databases
  • All about using ODBC and SQL Server
  • How to split an Access database into front and back-end
  • All about Macros in Access including AutoExec
  • How to do basic VBA in Access including code and error handling
  • More advanced techniques around creating forms in Access
  • Advanced queries including "multiple where" criteria

Plus, when you sign up for this course, you'll also get these extras:

  1. Exercise files – to help you become proficient with the material.
  2. Instructor demo files – use the same database files used by your instructor.
  3. An optional online quiz (45 questions) - to test what you've learned.
  4. A certificate of completion - to tell everyone you've aced the course.

If you're ready to master Microsoft Access 2019 and sign up for the course, go ahead and hit that Enroll button, or try some of the free videos by using the Free Preview feature. We look forward to seeing you on the course!

Course Format

  • This is a video-led course. You can preview some videos below.
  • This course includes practice exercises so you can practice as you learn.
  • This course is suitable for Windows users.
  • Course suitable for Office 365 Users

Course Certificate Included

This course includes an optional online quiz that will generate a course certificate upon completion.

14-Day Guarantee

We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 400,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Office. We’ve now created Microsoft Access courses for the last 5 versions and continue to help people get to grips with this essential database tool.

What people are saying:

★★★★★ “Goes into detail on many non-web portions of Access. Most of this was new for me, but found value in the lectures and exercises.” –Paul Morrison

★★★★★ “Instructor is really knowledgeable. The course is indeed advanced access and covers a lot of topics. By definition none of them in depth, but it's all about giving us the bearing points to pursue our own learning with the 3 key p's: practice, practice and practice! Totally recommended.” –Moises Redondo

★★★★★ “Very descriptive/informative and easy to follow steps. Love the accent” –Brenda Bachtold


Your Instructor


Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Course Curriculum


  Chapter 1: Introduction
Available in days
days after you enroll
  Chapter 2: Primary Keys and Indexes
Available in days
days after you enroll
  Chapter 3: Using Datasheet View
Available in days
days after you enroll
  Chapter 4: Linking to Other Access Databases
Available in days
days after you enroll
  Chapter 5: Using ODBC and SQL Server
Available in days
days after you enroll
  Chapter 6: Splitting an Access Database
Available in days
days after you enroll
  Chapter 7: Macros
Available in days
days after you enroll
  Chapter 8: The Ribbon
Available in days
days after you enroll
  Chapter 9: Visual Basic for Applications
Available in days
days after you enroll
  Chapter 10: Access Events Model
Available in days
days after you enroll
  Chapter 11: Forms
Available in days
days after you enroll
  Chapter 12: Advanced Use of Queries
Available in days
days after you enroll
  Chapter 13: Packaging You Application
Available in days
days after you enroll
  Chapter 14: Conclusion
Available in days
days after you enroll

Frequently Asked Questions


What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a prompt and full refund.
How long do I have access to the course?
After purchasing a course, you have unlimited access to this course for as long as you like - across any and all devices you own. Active memberships have access to all courses while they membership is active.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Will your videos work with iPhone, iPads, and Android devices?
<p> All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course. </p>
Will your videos work with Mac computers?
<p> All of our courses are compatible with both Windows (PC) and Mac computers. </p>
What if I have questions or problems while I am watching my tutorial?
<p> Should you have any problems using the system, we offer free technical support to customers. Just send an email to support@StreamSkill.com and we will respond promptly. </p>
Do you offer Certificates of Completion?
<p> We offer Certificates of Completion for courses that offer an online quiz (currently over 80% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content. </p>
Do you offer a subscription option?
<p> Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership. </p>
Do you provide any group discounts?
<p> Yes, we offer group discounts or multiple users. Contact sales@SimonSezIT.com for more information. </p>
Do you offer discounts for non-profits or educational institutions?
<p> Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact sales@SimonSezIT.com for more information. </p>
Can I interact with others who are taking the same course?
<p> Yes, you can interact with others by using the discussion section offered for each course. </p>
How long have you been in business?
<p> We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 80 courses, with tens of thousands of satisfied customers in over 180 countries. </p>

Get started now!