Microsoft Access VBA, Design and Advanced Methods Workshop 2
4.9 (31 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.
1,690 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access VBA, Design and Advanced Methods Workshop 2 to your Wishlist.

Add to Wishlist

Microsoft Access VBA, Design and Advanced Methods Workshop 2

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!
4.9 (31 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.
1,690 students enrolled
Last updated 2/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 6 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Perform several advanced Microsoft Access VBA techniques that will enable them to create more robust database systems
View Curriculum
  • Students should have had some exposure to Microsoft Access VBA.

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific design challenge from a student and then go over the details of how I would handle it.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!


In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!


What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!


This course will not remain this price forever! It's time to take action!

Click the "Take This Course" button at the top right now!

...every hour you delay is costing you could become the goto person for Microsoft Access VBA!

See you in the course!


Bruce Myron 

Who is the target audience?
  • A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
Introduction and Overview
1 Lecture 03:39
Setting Subform Colors
4 Lectures 20:22
Link for Downloading the SubformColors Database

Setting Subform Colors with Access VBA

Finish Placing Codes and Final Testing
Using Queries to Create Year Over Year Comparisons
5 Lectures 22:52
Link for Downloading the YearOverYear Database used in this Section

Create the Query that Makes the SalesByQuarter Table

Start Building the GetLastYear Query

Add the Sales Difference to the GetLastYear Query
Create Running and Page Totals on Reports
2 Lectures 10:11
Link for Downloading the ReportTotals Database used in this Section

Create Running and Page Totals
Set the Starting Autonumber in a Table
2 Lectures 05:39
Link for Downloading the SetAutonumber Database used in this Section

Set the Starting CustID and Append Customer Data
Back to Record on Open
4 Lectures 21:31
Link for Downloading the BackToRecord Database used in this section

Overview of the BackToRecord Database

Open on Customer Form and Record Values on Exit

Modify the Customer Open Subroutine to Use the values in the table
Design Challenge - The Security Company Call List
13 Lectures 01:36:00
Link for Downloading the CallList Database used in this section

Overview of the Call List Design Challenge

Add VBA Code to the Edit Button

A Function to Test for No Records and Add VBA Code to the Add Button

Create a Subroutine to Sort the Call List Records

Add Code to the Delete Button

Start Building Code for the Change To Combo Box

Build the LostFocus Sub and Start the AfterUpdate Sub

Figure Out How to Handle Change To Renumbering

Create the Decrease Sequence Subroutine

Create the Increase Sequence Subroutine

Testing for Errors

Final Testing and Debugging
1 Lecture 02:07
Conclusion and Overview of What We Covered
About the Instructor
Bruce Myron
4.6 Average rating
4,551 Reviews
46,328 Students
15 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,084 Reviews
16,007 Students
12 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.