Microsoft Access VBA for Non Programmers-Learn VBA Now
4.6 (488 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,157 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access VBA for Non Programmers-Learn VBA Now to your Wishlist.

Add to Wishlist

Microsoft Access VBA for Non Programmers-Learn VBA Now

Master Access VBA fast even if you've never done programming! Make complex jobs easy with Access Visual Basic!
Best Seller
4.6 (488 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,157 students enrolled
Last updated 5/2017
English [Auto-generated]
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
  • 8 hours on-demand video
  • 4 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • 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 2013.

NEW SECTION 13 ADDED on ACCESS VBA Classic Double Loops!

Learn how to create what I call a Recordset Walk Thru with a Double Loop. These little programs can save you lots of time and grief!

From a Recent 5 Star Review:

This is Absolutely the Best Training in Access

This is the third Training Course in a series of four. I have now completed this course and I am amazed at the content that has been covered - IT IS A FANTASTIC COURSE!!! - John Ovens

Learn how to open a form anywhere in your Access Visual Basic (VBA) code and send and receive values from it!

Feedback on Access VBA for Non-Programmers From a Student:

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

NEW SECTION ADDED (Section 11 - 14 Lectures)! USING ACCESS SUBFORMS! Create a complete Order Entry System!

NEW SECTION ADDED (Section 9 - 7 Lectures)! Learn to create and modify table structures from inside Access VBA Programs!

Feedback on Access VBA for Non-Programmers From Another Student:

"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

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!

From Another Student:

"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 is the target audience?
  • This course is meant for those who have a basic familiarity with Microsoft Access, but have never used macros or done any VBA programming.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
102 Lectures
4 Lectures 07:05

A review of the objectives in each of the sections

Preview 03:08

Setup Tasks

Direct Download Links for Database Files
1 page

How to Contact Me
Start Learning VBA and Handling Errors
9 Lectures 41:30

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
5 Lectures 23:13
On Open Event, Me Keyword and Orderby

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
8 Lectures 47:59
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
12 Lectures 01:03:35
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
9 Lectures 52:02
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
11 Lectures 01:03:34
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
8 Lectures 30:38
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
7 Lectures 24:35
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
Summary and Conclusion
1 Lecture 05:38
Congratulations and Next Steps
4 More Sections
About the Instructor
Bruce Myron
4.6 Average rating
4,379 Reviews
45,387 Students
17 Courses
Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Billy Myron
4.7 Average rating
2,090 Reviews
15,726 Students
14 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.