Udemy

Microsoft Access VBA for Non Programmers-YOU Can Do It!

Enroll Now
  • 20,665 Students
  • Updated 10/2025
4.5
(2,753 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 33 Minute(s)
Language
English
Taught by
Bruce Myron
Rating
4.5
(2,753 Ratings)

Course Overview

Microsoft Access VBA for Non Programmers-YOU Can Do It!

MAJOR course update! Almost NINE HOURS of NEW VIDEO has been added to the course!

GET READY!  This course has been updated with Almost NINE HOURS of NEW VIDEO!

Learn all the Access VBA programming concepts, tools and functions that you will need to build a fully functional system!  By learning as you build a specific database, you will immediately know WHY these techniques are important and see how you could use them on your own databases!

Some Student Reviews:

Microsoft Access VBA for Non Programmers-Learn VBA. Thanks to the course my knowledge of VBA has increased to a workplace skill level. I am further confident in reading and writing code. Without a programmers background, I have been successfully able to follow the lectures and replicate the database structures as outlined. An excellent resource in code writing and application for database development. - Fleur Pepper


"This is the best class I've taken on Udemy. There isn't a wasted minute in these videos. Thanks, Bruce!" - William Vicars

"I used to think I was an expert at Access until I took this course. Bruce has a way of presenting material that makes you learn it on the first view. He goes into all nooks and crannies of the subject presented. I highly recommend this course for beginners and experts alike.." - Rafal Krolik

"Bruce has created a really extensive course about Access. This course is built in bite size bits and every section teaches you an additional function in Access. The best thing about this course is that it is very low key and is really designed to help out the non-programmer. VBA might be very intimidating but this course shows you everything. The pace is good and every part is being explained in an excellent manner. I highly recommend this course especially if you want to learn and while learning create a wonderful tool that truly is useful." - Nicky Wong

Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!

  • Create VBA Subroutines for Forms and Control the Keyboard

  • Extensive Training on Handling Errors

  • Control Record Sorting and Searching for Specific Records

  • Learn How to Move and Pass Data Between Forms

  • Control sorting on continuous forms with the mouse or keyboard

  • Create Interactive Pull Down Filters for Form Data

  • Build a Complex Report Entirely with VBA

  • Introduction to SQL and How to Use SQL in VBA

  • Turn the Ribbon and Nav Pane On and Off

  • Prevent Form Closure or Resizing

  • Learn How to Close Access with VBA

Powerful Skills That Increase Your Value in the Marketplace

Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses.  The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!

There is a HUGE need in the marketplace for people who can create systems like this in Access.  This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks!  This could be your shortest path to increasing your income!

Content and Overview

All you need to do the course is some basic experience with Access components: tables, queries, forms and reports. This course does not require any programming experience or knowledge of macros.

Even though there are 80+ lectures and over 7.5 hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows.  You will find that each chapter builds on the previous one as you build a complete system, step by step.

By the time you have finished the course you will have done so much with VBA and it will be so familiar that you will be ready to tackle your own project immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

The course is complete with working files and finished code samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income!  Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

Required Software

You should have Office 2016 or later.   The course was created using the latest version of Office 365 (March 2025).

Course Content

  • 10 section(s)
  • 106 lecture(s)
  • Section 1 Introduction
  • Section 2 Automating Forms with VBA
  • Section 3 Using the VBA Editor and Standalone Modules
  • Section 4 Dealing with Errors and Debugging
  • Section 5 Triggering Other Events
  • Section 6 Make the To Orders Button work from the Subform
  • Section 7 Activate ADD Customer
  • Section 8 Activate the Add Order Buttons
  • Section 9 Add NotInList Capability
  • Section 10 Delete Orders or Customers

What You’ll Learn

  • Be able to create and test vba subroutines and functions
  • Be comfortable with moving to and from the vba editor
  • Take control of the keyboard within forms
  • Control interaction between forms and pass data back and forth
  • Tie sorting to clicking on controls within forms
  • Create and debug pull down filters on forms
  • Create the capability to instantly search for records
  • Use recordsets within forms to locate specific records
  • Convert queries into SQL and place them inside vBA code
  • Create complex reports using embedded queries and recordsets
  • Secure forms by turning off resize and close capabilities
  • Hide the menu and navigation pane and bring them back


Reviews

  • L
    Louise Toucher
    5.0

    This is an excellent match for me... I have written a business applications in MS Access and years ago was an Oracle SQL programmer.... this is an excellent course to show someone how to use Access and VBA

  • N
    Nigel Cooney
    4.0

    For me, as a non-programmer, learning about the programming techniques in this course was good, but I think it would be better if Bruce spent more time explaining the commands and structure of the modules, subroutines, etc, and less time explaining the keyboard shortcuts. For instance, he doesn't have to keep repeating "press Alt F11 to go back" every single time.

  • J
    J L
    5.0

    I do have to keep going back over it though to fully comprehend some concepts and pick up on ones I missed (maybe I am just too slow!).

  • P
    Peter Kereszturi
    5.0

    It was a very well structured course, explaining all necessary details to understand the content.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed