Microsoft Access VBA for Non Programmers - YOU Can Do This!
4.5 (1,822 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,693 students enrolled

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

Microsoft Access VBA can be learned quickly even if you've never done programming! Make complex jobs easy with VBA!
4.5 (1,822 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,693 students enrolled
Created by Bruce Myron
Last updated 4/2020
English [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 13 articles
  • 23 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • 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.

Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic!

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
  • 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 2010 or later. The course was created using Office 2010.

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.
Course content
Expand all 110 lectures 08:23:03
+ Introduction
3 lectures 07:05

A review of the objectives in each of the sections

Preview 03:08
Setup Tasks
How to Contact Me
+ Start Learning VBA and Handling Errors
10 lectures 41:34
Link for Downloading the Section 2 Database
Use an IF Statement and DoCmd
Use ElseIf and a Select Statement
Runtime Errors, Error Traps and Program Stops
Break Into Programs and Infinite Loops
What Have You Learned in Section 2?
5 questions
Section 2 Conclusion and Review
Section 2 Notes
2 pages
+ Create Record Sorting Subroutines
7 lectures 23:54
Link for Downloading the Section 3 Database
On Open Event, Me Keyword and Orderby
NOTE on Label Events Not Appearing
Subroutines for Form Controls, VBA Editing Shortcuts
Modify Subroutines to Sort DESC, More Error Handling
What Have You Learned in Section 3?
4 questions
Section 3 Conclusion and Review
Section 3 Notes
2 pages
+ Use Instant Search to Learn More About the Keyboard, Recordsets and Variables
9 lectures 48:03
Link for Downloading the Section 4 Database
Expanding the Keydown Subroutine
Using Public Variables
Building the Search Criteria
Field Names and Reserved Words
Using a Recordset and Bookmarks
Enhancing Our Instant Search
What Have You Learned In Section 4?
6 questions
Section 4 Conclusion and Review
Section 4 Notes
4 pages
+ Interact With Other Forms and Pass Information
13 lectures 01:03:39
Link for Downloading the Section 5 Database
Open Another Form with a Button Click
Send Data to the Other Form
Modify a Form to Utilize Data Sent to it.
Intro to SQL and Using SQL in the Recordsource
Locate Same Record When Returning from the Form
Modify the Form to Remember the Sort
Create a Prompt to Save Changes
Activate the Add Customer Button
Testing for a Blank Record
Activate the Delete Button
What Have You Learned in Section 5?
11 questions
Section 5 Conclusion and Review
Section 5 Notes
5 pages
+ Add Multiple Interactive Pulldown Filters
10 lectures 52:06
Link for Downloading the Section 6 Database
Setup Rowsource for Dropdown Filters
Enable Editing In the Dropdown Filters
Set Dropdown Rowsources on the Fly
Create a Subroutine to Build All the Filters
Use the AfterUpdate Event to Rebuild the Filter
Setup the Clear Filter Buttons
Save the Filters when Closing the Form
What Have You Learned in Section 6?
6 questions
Section 6 Conclusion and Review
Section 6 Notes
5 pages
+ Build a Report Containing Complex Calculations
12 lectures 01:03:38
Link for Downloading the Section 7 Database
Inspect the Tables and Review the Goal
Creating a Summary Table with a Query
Building Our First Function and Saving Queries to VBA
Add a Delete Query and Create a Test Macro
Restructure Tables and Add a Second Query to our VBA Function
Figure Out How to Get the Days Between Orders
Doing the Steps With A Recordset
Calculate the Average Days Between Orders
Plug the Average Days into the Report Table
What Have You Learned In Section 7?
10 questions
Section 7 Conclusion and Review
Section 7 Notes
5 pages
+ Turn Off The Menu, Ribbon and Navigation Pane
9 lectures 30:42
Link for Downloading the Section 8 Database
View the Example of Removing the Nav Pane and Ribbon
Create the HideMenu subroutine
Call the HideMenu Subroutine from our Form
Make the Subroutine Toggle the Menus
Create a Startup Subroutine and an Autoexec Macro
Prevent Closing the Form and Activate the Exit Button
What Have You Learned in Section 8?
8 questions
Section 8 Conclusion and Review
Section 8 Notes
3 pages
+ How to Create and Modify Table Structures In VBA
8 lectures 24:39
Link for Downloading the Section 9 Database
Overview and Goal
Create Delete Subroutine and Make First Changes to SummRpt Function
Backup the SummRpt Function and Make the First Changes
Pull a Query from VBA Back to Design, Change It and Update VBA
Use TableDefs to Add a Field to a Table
Use TableDefs to Create a Table and Add FIelds to it.
Make Final Changes and Test the Modified Function
+ Section 11: USING VBA with SUBFORMS
15 lectures 01:08:46
Link for Downloading the Subforms Database
Overview of the Tables in the Subforms Database
Overview of the Forms in the Subforms Database
Add OrderList as a Subform to the Customer Form.
Using an On Exit Subroutine to Capture the Order Number You Were On
Pass the Order Number to the Go To Order Button
Open the Orders Form and Move to the Specified Order
Create Code to Return to the Customer Form
Setup the OrdProdList Subform
Create a Total in the Subform
Update the Subtotal and Order Total
Add a New Product to the Order
Create the Add Order Subroutine and Post a New Order
Get the New Order Number and Open the Order Form