Learning VBA Programming (in Microsoft Access)

Build the Ultimate Foundation to your VBA Knowledge

   Watch Promo   Enroll in Course

Are you struggling with getting your VBA code to work again and again?

Have you been assigned a VBA project at work and your VBA skills are not up to the task?

Are you in despair because your VBA code stopped to work after a "minor" change and you have no clue why?

If you answered any of these questions with yes, this course is for you!

In this course Philipp Stiefel teaches a deep, fundamental understanding of programming in the VBA programming language from the ground up.

After taking this course, you will be able to …

  • Understand programming in VBA from the ground up.
  • Reduce the time you need to implement a solution.
  • Avoid common pitfalls.
  • Quickly find, analyze, and fix problems in existing VBA code.
  • Write code that can be easily maintained and enhanced in the future.

The core teaching medium of this course is high resolution video of practical coding in the VBA development environment, supported by presentations about the base theory of each topic. The course also includes supplemental course materials, such as homework assignments, homework reviews, downloadable cheat sheets, and quizzes.

The course is suitable for beginners in programming and VBA. Students with intermediate knowledge of VBA will also highly benefit from this course. – A basic knowledge of Microsoft Access and SQL is helpful but not strictly required.

This course is taught in Microsoft Access, but it is not a Microsoft Access course. The focus is firmly on VBA and the core content of every lecture in this course is all the same valid in other VBA enabled application such as Microsoft Excel or Microsoft Word. Access related topics are only covered to the extend they are relevant for the example application built in the course.

This is an opinionated course. Philipp draws from his long experience as a VBA application developer to cut through the noise and focus on the important aspects of VBA you will need in day-to-day programming. He also includes his philosophy of writing maintainable code right from the start.


Course Curriculum


  Getting Started with the Course
Available in days
days after you enroll
  Tools of the Trade - The Programming Environment
Available in days
days after you enroll
  Anatomy of a Procedure - Part 1
Available in days
days after you enroll
  Variables and Constants
Available in days
days after you enroll
  Anantomy of a Procedure - Part 2
Available in days
days after you enroll
  Object Based Programming
Available in days
days after you enroll
  Control Flow
Available in days
days after you enroll
  Errors and Error Handling
Available in days
days after you enroll
  Putting it Together
Available in days
days after you enroll
  Debugging VBA Code
Available in days
days after you enroll
  The Soft Rules - Writing Better Code
Available in days
days after you enroll
  Wrapping Up
Available in days
days after you enroll

Course content in numbers

  • ~16 hours of video (includes ~2.5 hours optional/bonus material)
  • 3 PDF “cheat sheets” summarizing important info on 1-2 pages.
  • 7 Homework assignments, with a pre-recorded homework review, and sample solutions.
  • 7 Quizzes
  • 7 downloadable PDF files with all presentation slides

Not Included in the Course

To prevent misunderstandings, I like to clarify: The following major topics are *NOT* covered in this course.

  • The design of databases tables and relationships
  • The design of queries or the syntax of SQL
  • The design of Access forms and reports
  • Object Oriented Programming with custom class modules

Your Instructor


Philipp Stiefel
Philipp Stiefel

Philipp is working professionally with Microsoft Access and Visual Basic for Applications since 1998 for corporate clients. He has established himself as an authority in the field by publishing articles on his website at codekabinett.com and videos on his codekabinett YouTube channel . He is a public speaker on topics related to Access and VBA and was invited to speak at the AEK, Access DevCon, and NADD conferences and at many international online Access user groups. He was also awarded the Microsoft MVP title for his community engagement from 2000 to 2006.


Frequently Asked Questions


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.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

30 Day Money-Back Guarantee!

Buying the course is risk-free for you. If you are not happy with the course within 30 days after purchase, we will refund the full price.


Early Bird Bonus – Consultation Webinars

Here is a bonus for early bird students. Between 15 March and 15 April 2022, I will offer 4 one-hour live group consultations open to all registered students. In these consultations I will be available to answer questions related to the course content.

There will be one session per week on different weekdays and at different times to allow students from different time-zones and backgrounds a variety of options to participate. These group consultations will be Microsoft Teams webinars. The times of these consultations and the registration links are inside the course curriculum.


Further Questions?

If you have any further questions, you may ask them via email to [email protected].

"Philipp Stiefel is on a very short list of people who I would pay to teach my employees how to write VBA."

- Mike Wolfe, https://nolongerset.com/

Get started now!