Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: Microsoft Access VBA for Non Programmers-YOU Can Do It!
Rating: 4.5 (2767 reviews)

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

Created byBruce Myron

Last updated 10/2025

English

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

Course content

21 sections • 105 lectures • 12h 21m total length

Course Overview3:55
A review of the objectives in each of the sections

Updating the Prodname and Unit Price from Prodcode14:13
Learn to automate data entry in Access with VBA, turning orders subform product code into a combo box that fills the product name and unit price and advances to quantity.
Update ProdCode and Unit Price from the Prodname Combo Box4:00
Add a second combo box for product name alongside product code, configure its row source and after update event to populate the code and unit price, enabling flexible product searches.
Update the Main Form Total19:51
Format currency and automatically recalculate the main form total when quantities change, using a subform subtotal, VBA with parent references, nz null handling, and refresh to ensure accuracy.
Create an Afterupdate for the UnitPrice and Create a Delete Button15:14
Testing Data Entry from Customer to Order10:49
Walk through entering a new customer and immediately adding an order, while adjusting the tab order, using a save records macro, and ensuring related records save correctly.
Recalc Domain Functions and Force Proper Case8:44
Afterupdate on City and Fill In State and Zip13:36
Create an Unbound Company Search Box11:04

Overview of VBA Editor and Modules12:57
Explore the VBA editor and modules in Access, compare form modules to standalone modules, and learn how option explicit and variable declaration shape event-driven code.
Custom Form Subroutines and Using Comments5:54
Create a custom subroutine in a form to apply proper case with a string conversion function. Use comment block tools in the VBA editor to manage code changes efficiently.
Modifying the Custom Form Subroutine and IMPORTANT Syntax7:41
Creating a Shared Module Subroutine8:07

What to do when you have an Compile error5:20
What to do when you have a Runtime Error3:14
Learn how runtime errors differ from compile errors in Access VBA, identify issues with type mismatches, and use debug and continue to fix code while the program is running.
Using Breakpoints and Tracing Programs7:45
Master breakpoints and tracing in Access VBA with alt F11, F8, and F9 to inspect values, debug form logic, and fix data source issues in combo boxes after update events.
Finding and Using the BREAK Key3:01

Step 1 – get the Order Number12:10
Capture the current order number from the orders subform with a temp var. Then pass it to the orders form and handle on exit with the two orders button.
Step 2 – Make the Order form Find the Order6:15
Set up the orders form to locate the correct order using temp vars, modify the on open routine, and use set focus to the subform, with enter event testing.
Step 3 – Make the Customer form go to the Subform record4:43
Step 4 – Figure out when to reset the TempVar10:49
Step 5 - Test and Fix the Last Errors10:33
test and fix the last errors by implementing a form-wide boolean variable, tracing open events, and exhaustively testing across customer and order forms to ensure correct subform behavior.

Intro to the SelCust Form11:03
Streamline order entry in Microsoft Access VBA by opening a select customer form as a dialog from the add order action, using an unbound company combo and open args.
Bang vs Dot3:32
Get the CustID from the SelCust Form8:51
Pass the cust ID from the SelCust form instead of the company name to ensure selecting the correct customer when adding orders, using temp vars and open args.
Use a Recordset to Add an Order6:41
Plug the Customer into the New Order7:33
Open the customer table as a recordset, locate the correct customer by ID with a search string, and update the order with their details.
Now Activate the Add Order Button on the Order Form10:06

VBA Editor Menus and Bookmarks5:34
Create the NotInList Event10:12
Add the Same Capability to the Orders Add Order Button5:49
Extend the add order workflow by copying the customer form logic to the orders form, using bookmarks and open/close forms, to add orders for new customers and handle existing ones.
How to Add a New Person to an Existing Company4:38
Add a person for this company by updating the customer form, adding an add person button with an onClick event, and using the company name from column zero.

Requirements

No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription.

Description

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).

Who this course is for:

This course is meant for those who have a basic familiarity with Microsoft Access, but have never used macros or done any VBA programming.

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

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Automating Forms with VBA8 lectures • 1hr 38min

Using the VBA Editor and Standalone Modules4 lectures • 35min

Dealing with Errors and Debugging4 lectures • 19min

Triggering Other Events2 lectures • 20min

Make the To Orders Button work from the Subform5 lectures • 45min

Activate ADD Customer2 lectures • 17min

Activate the Add Order Buttons6 lectures • 48min

Add NotInList Capability4 lectures • 26min

Delete Orders or Customers3 lectures • 30min

Requirements

Description

Who this course is for: