Workshop 5: Access VBA, Design and Advanced Methods (Udemy.com)
Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!
Created by: Bruce Myron
Last updated June 2024
What you will learn
- Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems
Course Description
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 database 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 money...you could become the goto person for Microsoft Access VBA!
See you in the course!
Sincerely,
Bruce Myron
Instructor Details
- 4.9 Rating
182 Reviews
Bruce Myron
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.
More courses by Bruce Myron
Excel to Access: Intro to Microsoft Access for Excel Users (2023)
4.7 (4,674 Reviews)
Provider: Udemy
Time: 10h
$109.99
Microsoft Access VBA for Non Programmers-YOU Can Do It! (2025)
4.5 (2,771 Reviews)
Provider: Udemy
Time: 12.6h
$84.99
Microsoft Excel 2016 Master Class: Beginner to Advanced (2020)
4.7 (1,735 Reviews)
Provider: Udemy
Time: 8.1h
$69.99
Microsoft Access 365-MS Access Mastery/Excel Import Secrets (2024)
4.6 (984 Reviews)
Provider: Udemy
Time: 16.8h
$79.99
Excel 2016: Customize Excel - Save Time & Be More Productive (2017)
4.7 (816 Reviews)
Provider: Udemy
Time: 2.2h
$79.99
More Office Productivity courses
SUPERHUMAN 10X Productivity with AI: 75 Time Management Tips (2026)
4.9 (4,994 Reviews)
Provider: Udemy
Time: 13.7h
$94.99
Microsoft Word 2019 (MO 100) Study Guide to 1000 points (2021)
4.9 (451 Reviews)
Provider: Udemy
Time: 2.1h
$79.99
Microsoft Word 2016 - Bootcamp - Zero to Hero training (2025)
4.9 (167 Reviews)
Provider: Udemy
Time: 3.3h
$49.99
Power BI TOTAL en 14 Días - Analista de Datos Avanzado (2026)
4.8 (14,560 Reviews)
Provider: Udemy
Time: 15.4h
$89.99
Microsoft Access 2016 Master Class: Beginner to Advanced (2024)
4.8 (14,398 Reviews)
Provider: Udemy
Time: 7.2h
$12.00
Reviews
By Anonymized User on 3/29/2020
Very good course. I was able to make changes to a live Access database that I use, based on sections 2, 3, 4 & 6 of this course. I thought Bruce explained the topics very well. I learned a lot of new ideas from the design challenge, especially using VBA code within modules to automate the running of queries and appending to/making tables. I am looking forward to getting started with advanced workshop no. 6.
By Kent Ellis on 10/30/2019
These workshop courses are great ways to learn very specific Access techniques in bite-sized chunks, while being very in-depth at the same time. There may be parts you don't really want for the moment, but it's good to know they're there and accessible for future reference.
By John R Turner on 6/25/2019
Using Bruce's courses are a great and simple way to go through the process of creating and coding simple projects within ACCESS. The courses are done in a manner that helps you go through the steps to learn and reuse the process in making my own programs to use, both personal and professional. Thanks for the time and experience to show those of use who are learning to use these tools more efficiently.
By Kirby Records on 12/13/2018
These workshops do what they say they will. There are good examples of how to get coding around a problem. As a beginner, some of the process eludes me until it wraps up in the end. But I come away with new ideas and code examples I can go back to later.
By Dale Anderson on 12/7/2018
Good job as usual Bruce. I always learn a lot from your courses and I look forward to the next one. In this Workshop I found the sections on Option Buttons and Labels to very helpful and something that I can put directly to use.
By Terry Taylor on 9/13/2018
Always great lessons. I really enjoy his teaching style. What appear to be the most basic lessons are packed with insights on how to develop your programs by thinking outside the box. He's helped me to develop some pretty impressive databases just by following his tutorials.
By Lance Brockwell on 9/7/2018
Detailed instruction provided for each section makes the concepts easy to grasp. The VBA workshops are great for taking your VBA skills to a new level and they are practical as well!
By Leo Cunning on 11/21/2017
This is yet again another excellent course - with many very useful shortcuts and explanations. I have enjoyed this course almost more than all the other Bruce's Access Courses which I have taken.
By Maxine Hammett on 10/3/2017
This workshop is invaluable. The teacher gives you real world examples and walks you through how to accomplish each. It has advanced my career two fold. Here he explains how to implement "ranges" to show data queried against a combo box! I could use this immediately on a database I was creating! The teacher explains what he's doing step by step. And most importantly he makes it a priority to answer your questions and help explain his explanation thoroughly. I would recommend ALL his courses to anyone who wants to learn VBA using practical example you can implement immediately.
By Steven Halder on 9/28/2017
I especially liked the Filters processing which was a little different than I've done in the past and gave me several tips and ideas to improve functionality of my code. All the subjects were excellent and gave valuable insights into getting the most functionality out of a minimal amount of VBA code.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 98 / 100












