Workshop 8: 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
- Create an "Add or Go" combo box that will Add a new record or Go to an existing Customer
- Learn how to use Excel Date functions not available inside Access by using VBA
- Learn a simple, yet flexible way to add the ability to have quantity discounts on inventory items
- Learn how to add default values to Parameter Queries, plus several additional handy tricks
- Learn how to tab through the fields in the pages of a tab control
- Learn how to create professional looking custom buttons to forms
How it compares
Against the other 47 rated Udemy courses in Microsoft Access on CourseDuck:
- Rating4.8 out of 5higher than 80% of them
- Reviews87#46 of 48 by number of reviews
- Length2.4 hoursshorter than 78% of them
- Last updatedJune 2024more recently than 53% of them
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 workshop 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.8 Rating
87 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
$15.99
Microsoft Access VBA for Non Programmers-YOU Can Do It! (2025)
4.5 (2,772 Reviews)
Provider: Udemy
Time: 12.6h
$10.99
Microsoft Excel 2016 Master Class: Beginner to Advanced
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
4.7 (816 Reviews)
Provider: Udemy
Time: 2.2h
$79.99
More Microsoft Access courses
Microsoft Access Networking 2: Maximum Security (2022)
4.9 (312 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
Workshop 5: Access VBA, Design and Advanced Methods (2024)
4.9 (182 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
Microsoft Access 2016 Master Class: Beginner to Advanced
4.8 (14,398 Reviews)
Provider: Udemy
Time: 7.2h
$11.99
Microsoft Access VBA: Automating Import of Excel Files (2021)
4.8 (543 Reviews)
Provider: Udemy
Time: 2.5h
$64.99
Workshop 3: Access VBA, Design and Advanced Methods (2024)
4.8 (212 Reviews)
Provider: Udemy
Time: 2.3h
$74.99
Workshop 4: Access VBA, Design and Advanced Methods (2024)
4.8 (208 Reviews)
Provider: Udemy
Time: 2.4h
$74.99
Reviews
By John A Knauer on 6/24/2024
Every one of Bruce's courses that I have taken (Access DB and Access VBA-related) has been educational and insightful. Highly recommend his courses!
By William Palmer on 5/27/2022
Bruce is the best! His material is always interesting and useful. I skimmed through the first time, and will repeat at least once or twice to let the tips & techniques sink in; I'm sure my rating won't change.
By Randy Stewart on 1/15/2022
I have traveled the U.S. training more than 2,000 organization officers on accounting and QuickBooks. But for me, I trust Bruce as my number one trainer. I have all his trainings and they are all five star.
By Muhammed Khan on 6/6/2021
YES IT IS INFORMATIVE AND HELPFUL.
By Leo Cunning on 5/7/2021
This is an excellent course which has given me many useful and time saving tips. I have taken and enjoyed this and many of Bruce's courses.
By William P. Mello on 2/9/2021
I always learn several new things from taking Bruce's courses and this one was no exception. I can't get enough of these workshops! Thank you Bruce
By Paul Dequidt on 1/15/2021
De les is in de Engelse taal. Mijn ACCESS versie is in het NEderlands. HEt is dus iets moeilijker om exact te doen wat Bruce voorstelt om te doen. Maar finaal lukt het wel, na een tweede of derde poging.
By Alex Hudson on 1/14/2021
I love Bruce's courses. I have learned so much, and he makes it simple to use where you can apply all the little tricks and tips to anything you are trying to create!
By Ray McConaghy on 1/7/2021
Bruce is THE master of VBA. I advanced from being a hobbyist to having a lucrative career based around his teaching and mentorship. Every lesson gives valuable insights necessary for practical, real world problems. I am looking forward to the next workshop. Stay safe, Bruce!
By Tony Sulpizio on 1/6/2021
The greatest part about Bruce and his videos is the practical examples that can be implemented into a new or existing MS Access Database. So many great features here that increase workflow efficiency. Thank you Bruce!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 96 / 100












