guaranteeAll of my courses are sold on my partner site Udemy and come with the Udemy 30 day money back guarantee!

If you are unhappy with the course for any reason within the first 30 days, you can get a full refund, no questions asked…

During MAY 2022 my courses can be purchased on Udemy for $12.99 to 16.99 by using the coupon code 2022MAY

Microsoft Access 365 Master Class: From Beginner to Advanced

Almost SEVEN MONTHS in the making, this is the largest course I’ve ever produced – over 13.5 Hours and growing!  This course includes MANY techniques never covered in any of my other courses.

“Microsoft Access 365 Master Class” is perfect for the absolute beginner or more experienced users that want a more thorough understanding of Access. Plus the course is done completely in 1080p Hi Def on the latest version of Windows 10 and Office 365.

From One of the Student Reviews:

Yes, fantastic course so far, very easy to understand and helpful with Excel comparisons and attached resources so I can follow along with my own computer. – Jonathan Halder

This course truly gives you all the tools you need to “Master” Access and quickly become the guru in your office or company!  Go through the entire course and you will be able to amaze your co-workers and impress your boss!

From another Student Review:

I have been studying Access for several years and have done many video courses on it, Including many of Bruce’s videos. This one is definitely the best I have seen. Bruce makes the learning the concepts much more enjoyable by using useful ,real life, examples and problems. I highly recommend this course to anyone interested in learning Access. Cheers! – James S Mulvey

Just CLICK HERE to get this course now for only $12.99!

Excel to Access: Import Excel into Access


This course will benefit anyone from the brand new Access user to the experienced VBA programmer.  Yes, even for those who already are programming, I have seen too many people who have gaps in their learning that cost them a great deal of time.  Many of the topics covered in this course are not in any of the other courses, like several detailed lectures on unique value, total and action queries.

From One of the More than 3,200 Student Reviews:

An excellent course given by someone who, I can tell, has years of experience. I highly recommend this course for anyone wanting to learn to have above average skills with MS Access. – Steve Cook

By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

From another Student Review:

Excellent course. Very methodical & structured and easy to follow with numerous actual working examples to download & practice on. This course is a great investment, it saves hours of trawling the internet for random articles on the various different aspects of Access. – Cliff Sangster

Just CLICK HERE to get this course now for only $12.99!

Microsoft Access VBA for Non Programmers-Learn VBA Now

VBA, the Visual Basic programming language built into Access, is so integrated with Access itself that it is often HARDER to do something without VBA than with it.  For people who have never considered programming, learning VBA could be a life changing revelation that will forever make Access easier to use.

From a Student Review:

“I’m just at Section 5 and I’m blown away! Can’t wait to get started in my project. I love the way you explain everything and it’s at a good pace. This is exactly what I needed.” – Darlene Exkert

In this course you will learn all the Access VBA programming concepts, tools and functions that you will need as you build a fully functional system! I take the time to give you a solid foundation in the basic concepts of VBA and how to resolve typical problems.

From another Student Review:

I absolutely love this course! I have been programming for about 15 years or so and I still learn something new with each lesson! – William Mello

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!

Just CLICK HERE to get this course now for only $12.99!

———————
Microsoft 365 Access: Link Data to Excel with Macros and VBA

This course was previously called “Access to Excel- Instant Excel Reports & Excel Pivot Tables” but now has been completely revised!
It shows you a lot of query tricks and ties them all together with a macro. Next it uses the latest Office 365 techniques to link Access queries to Excel, shows you how to update the data when you rerun the macro, and how to change the Access data source. To top things off, there is an easy to follow introduction to VBA programming where we build a program that automates the process of opening and updating the Excel file when we run the Access Macro. The section finishes by adding commands to copy the linked Excel file and remove the connections, so the file can be distributed to others.
If you have gone through either of my Access Introduction courses, this is a PERFECT followup course to show you the power of queries, macros and VBA!

From some Student Reviews:

“What a great update to the course and that section on organizing the objects in the Navpane was priceless.” – Michael Krailo

“Wonderfully helpful, detailed techniques broken down into simple steps.” – Nate Herndon

“Excellent course…tons of valuable tips and information…I highly recommend using Access in conjunction with Excel…looking forward to more lessons of such a high calibre. Thank you!” – George Wood

You don’t need to understand VBA to just follow along and create the subroutines and functions for the course. Plus databases with finished VBA programs are provided for download.

Just CLICK HERE to get this course now for only $16.99!
————————

Microsoft 365 Access: More VBA and Automating Outlook Email

This course was previously called “Access to Excel to Outlook: Email Excel & Access PDF Reports” but now has been completely revised!

This is an INTERMEDIATE VBA Course and you should take the “VBA for Non-Programmers” course, or the equivalent, before taking this one.  This course builds on the Macro and VBA code created in the course “Microsoft 365 Access: Link Data to Excel with Macros and VBA” so it is recommended that you also take that course before this one.  In the course I assume you already know how to create VBA functions and subroutines and I move more quickly when creating VBA Code.

This shows you several ways to use VBA to automate the distribution of Excel files by sending them as email attachments.  We learn how to send Access objects as attachments with a one line command, then we replace the multiple query update macro created in the previous course with VBA Code.  We then learn how to control Outlook and send emails to multiple recipients.  We conclude by examining the VBA techniques used in a simple, yet powerful, Emailing database.

From a Student Review:

“This course is amazing, I thought that was more difficult to create a program to send emails from Access, but not really! Bruce’s explanation makes the things easier to understand, he is an extremely good teacher, an expert in this topic. I have taken several of his courses and when I finished I have the feeling of wanting to learn more, I’ve definitely will continue my learning of Access with his courses, I recommend his courses a lot, very useful and interesting.” – Roberto Carlos Huerta Gomez

In short, to the point videos, you will learn MANY new VBA techniques that you will use for years to come!  This course is a great followup to the first VBA course in that it shows you the best way to use VBA to automate many common tasks, not just emailing.

Just CLICK HERE to get this course now for only $14.99!
————————

Microsoft Access: Networking Made Simple

If you have used Access but wonder what the best way is to setup Access on a network, this course is for you! Every step starting from a single database to a complete front end/back end network environment is shown in detail.

I have spent many years working with businesses with multi-user networks and these are the methods I have developed to help me get the most done in a minimum of time!

From some Student Reviews:

“Absolutely amazing, like all courses from Bruce. Thank you for all the effort to make this stuff! It’s invaluable for me!” – Grzegorz Kania

Tricks and tips that will make me look like an ace! in hours! – Jaimie Amaya

I LOVE this course. I recently ran across a database structured the same way and I am looking forward to implementing this concept in my new design. – Eugene Gilseth

Although knowledge of VBA is not required, this course shows you how to create several programs in VBA. You don’t need to understand VBA to just follow along and create the subroutines and functions for the course. Plus databases with finished VBA programs are provided for download.

From another Student Review:

I was very impressed by the way that Bruce explains the programming as plain English! Totally got it very easy and fast! – Kiril Yanev

Why suffer through network headaches? I will show you how to avoid them completely!

Just CLICK HERE to get this course now for only $15.99!
————————

Learn How to SECURE Your Access Database
———————–
Microsoft Access Networking 2: Maximum Security!
Learn how to totally control your network database users! This course gives you step by step instructions on how to lock down your database so that there is no menu, no ribbon, no navigation pane and no shortcut menus. Users have no choice but to run the system the way you have intended. BUT, when you need to make changes, you can quickly change into ADMIN mode, make any modifications you want, then Re-Secure the database instantly!

From Student Reviews:

This course is very well explained, the content is comprehensive and at the same time straight to the point so you can actually learn and develop your own projects. Fantastic course!!! – Andres

Have to say, that it was an excellent course, and the instructor did take time to explain his code in detail, this was something I needed to learn and this course was well worth the fee, would definitely recommend if your using Access for any type of work that needs a basic level of security! – Gregory Feeney

Although knowledge of VBA is not required, in this course we create many VBA functions and subroutines. Since you are shown every step in the creation of the VBA, you don’t have to already understand VBA (although I highly recommend my VBA for Non-Programmers Course!) to just follow along and create the subroutines and functions for the course. Plus DONE databases with all the completed VBA programs are provided for download.

Two more Student Reviews:

This is another great course from Bruce. Learning by building applications is great and I’m actually using this knowledge in my current job. Thanks! – Grzegorz Kania

Another quality course! A lot of great information for those looking to secure their Access databases. There are also a lot of nice tips and tricks that are shown throughout the course that save time. – Matt Woody

Just CLICK HERE to get this course now for only $15.99!

Learn How to Import Excel Files with ONE CLICK!
———————–
Microsoft Access VBA: Automating Import of Excel Files!
Many students have contacted me with requests on how to handle the periodic import of Excel files.  Typically an Excel file is received weekly or monthly and needs to be imported and used to update and/or add to a main data table.  This course will show you how to reduce this process to nothing more than selecting the import file.  The rest of the steps are handled automatically in seconds!

From Student Reviews:

This course is a hidden gem. Besides importing Excel data into Access, you learn how to manage bad data coming into Access, which is phenomenal if you need to prove your new workflow has strong controls. On top of that, you’ll learn how various functions work together to deliver a seamless import process. – William Crespo

Super Instructor with clear and engaging presentation style. Taught focused approach for using VBA with Access to solve very practical every-day problems. His materials are excellent! – Robert Gates

The program we will build together doesn’t only import the Excel file, it also analyzes the data for errors and creates a report showing the details of what needs to be corrected!  If you are willing to take the time to go through this course you could completely eliminate the headache of having to periodically import Excel files!

This course is “hands on” and we completely build the database step by step in the course lectures.  The course is built so that you can watch the steps then pause the lecture and do them yourself!

Just CLICK HERE to get this course now for only $15.99!

===============
VBA WORKSHOPS!!
Learn tricks and techniques not taught in any of my other courses – and maybe not anywhere else!
——————
Access Design and Advanced Methods Workshop 1
This workshop was inspired by the many discussion posts on my other courses and shares many tricks and secrets not covered in any of my other courses.

In this course we create a hack-proof, “ready only” database, we learn how to use the “not in list” event to optionally popup entry forms when you add a new value to a list.  We learn how to make a button read the current record on the order subform, go to that order, then return to the exact same position when the customer form is reopened!
Finally we learn how to create an assignment form for a loan company assigning loans to loan processors – its not as easy as you think!

Here are some excerpts from the 5 star reviews:

Once again Bruce is giving Excellent training on advanced techniques in very simple and understandable terms. He has a special knack of getting right to the meat of the issue without making it complicated. GREAT CLASS!! – Brad Cate

Excellent course. This shows the (up to now) undocumented features within Access that can be used in very practical ways to protect not only your developer work, but also the business assets of your clients. The value -added of these modifications is priceless! – Ray McConaghy

I found this workshop to be very informative and have learned a number of new techniques that I can apply to my own projects. As usual Bruce Myron’s presentation was excellent with a superb set of resources to help you understand the course material. – Melvyn Shepherd

This course clearly illustrates the flexibility and power of VBA to achieve user friendly forms while maintaining full control of the application. It includes many useful hints and tips to make coding quick and easy while also demonstrating simple, effective methods for resolving syntax errors. – Keith Beales

The material in this course all comes from student discussions, and 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.

Just CLICK HERE to get this course now for only $14.99!
—-
Access Design and Advanced Methods Workshop 2
This second workshop course covers many more secrets and time saving techniques I have discovered during my many years as a database consultant.  With one exception, the sections in this course deal with things not covered in any of my other courses!

We learn how to set subform colors and some tricks on setting colors with VBA. We learn how queries can actually calculate sums on PREVIOUS years and compare to current years!  We see how to make running and page totals on reports.  We set the starting Autonumber primary key in a table, in case you don’t want to start at 1. We modify the back to form program to go back to the current position when you reopen the database!  We finish by creating a Call List form that lets you reorder subform records by just selecting the new number.  Take a look at the intro video for an overview!

Some Student Reviews:

I can’t say enough positive things about Bruce and his clear and concise method of teaching! I look forward to each and every course he produces and I always come away with a better understanding of the power of Microsoft Access and the capabilities of VBA! – Computer Programmer William P. Mello

This course is full of techniques that I haven’t come across before, but I am sure I will be able to apply some of them to my current project. I found the last section on the Call List especially useful. I look forward to the next workshop. – Mr Melvyn Shepherd

I am completely amazed at what Bruce comes up with in his courses. This course has a wealth of useful tips and tricks. Bruce’s style of delivery makes it a joy to learn! – John Ovens

Just CLICK HERE to get this course now for only $16.99!
——————–
Access Design and Advanced Methods Workshop 3
My third course in the workshop series covers many secrets and time saving techniques I have discovered during my many years as a database consultant.  With one exception, the sections in this course deal with things not covered in any of my other courses!

We build a stopwatch program as an intro to manipulating time and learn about Sendkeys and SelLength. Learn how to build shortcut keys with Autokeys and generate random values.  Create a custom 3 button form and learn how to easily clean up a huge list of inconsistently entered phone numbers. Take a look at the intro video for an overview!

From two Student Reviews:

Bruce is my favorite Access instructor. He never fails on giving real life examples and most importantly explaining what is going on. I love the built in bugs that he turns into lessons. His teaching just can’t be beat! – Brad Cate

Not only does Bruce respond to questions in the forum, he also responds by creating courses around challenges his students face in the REAL WORLD. Most courses cover the same information and use the same examples – in THIS course Bruce disperses innovative nuggets throughout his courses that are simply not found elsewhere! – Tammy Bergen

Just CLICK HERE to get this course now for only $15.99!
————————–
Access Design and Advanced Methods Workshop 4
This course covers many topics that are not in any of my other courses!  Topics like manipulating the record position after searching in forms, fixing the “Apostrophe Problem”, Understanding Access Themes, Printing the Current Form Record and the Design Challenge: Managing Customer Surveys.

From Two Student Reviews:

Bruce is simply amazing. I have undertaken several of his courses, which have all been fantastic. I have learned a lot of new tricks and features of ACCESS and Bruce goes to great lengths to ensure that the concepts are understood. There are several short quizzes to test your understanding as you progress. While this course builds on an earlier course, it is not essential, for this course. I highly recommend this course to anyone wishing to advance their skills in Microsoft Access VBA programming. – John Ovens

Once again Bruce hits the ball out of the park! I love how Bruce takes real life, day to day issues or challenges and explains how to step through things on the way to solving a problem. He truly has the heart of a mentor – always guiding the student toward bettering themselves … all while keeping the material interesting and challenging. Wish I had more hands so I could give better than two thumbs up! – Scott Axton

These are all techniques that I have had to figure out and use in real client situations. Many of them are not in any book!

Just CLICK HERE to get this course now for only $12.99!
————————-
Access Design and Advanced Methods Workshop 5
This course is a response to student questions about specific Access capabilities.  Here is a list of the major topics:

How to Set filter ranges with combo boxes.
How to Use option buttons with text values.
How to Print labels and multi-column reports.
How I Use the database documenter.
Design challenge: Modify the date range report to allow selection of certain dates.

Of course there are also lots of little tricks thrown in along the way and these are all techniques that can save you lots of time!

From Two Student Reviews:

Well you’ve done it again Bruce! You’ve given me some great idea’s that I never thought possible and never considered using. You are truly a Godsend thanks a lot! – Brian Louttit

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. – Steven Halder

Isn’t it time you got more efficient with your time and learned techniques that will make you instantly more valuable to your employer?

Just CLICK HERE to get this course now for only $15.99!
————————-

Access Design and Advanced Methods Workshop 6

This course is a response to student questions about specific Access capabilities.  Here is a list of the major topics:

How to create CUSTOM SHORTCUT MENUS for specific form controls (including linking menus to VBA programs!)
How to use TRIPLE STATE to return check boxes to Null (this can be a life saver!)
How to build a SEARCHABLE LIST BOX control – I’ve never seen this technique on the internet or anywhere else!
Quick Tips: Using SNAPSHOTS, HIDING Nav Pane Objects, Creating CUSTOM GROUP in the Nav Pane
Design Challenge: Create RUNNING BALANCES in a subform and automatically update the main form

From two student reviews:

Bruce never ceases to amaze me with his knowledge of access vba. Very practical solutions to common situations. Love this stuff. – Michael Krailo

Good job Bruce. I really liked the sections on Triple State and List Box. Great learning experience and great for future reference. Thanks. – Dale Anderson

The techniques in this course could make you an ACCESS SUPERSTAR at work!

Just CLICK HERE to get this course now for only $14.99!
——————————
Access Design and Advanced Methods Workshop 7

This course is a response to student questions about specific Access capabilities.  Here is a list of the major topics:

Create a Substring Search Combo Box – search for letters anywhere in the row source list.
Creating Default Forms and Controls that will be used in all new forms
Quick Tips: Show a Calendar on blank Date Fields, Test Query Parameter Values as they are entered, Create a Quick Database Backup button
Highlight the Current Record in a Continuous Form
DESIGN CHALLENGE: Create a Multi Select Listbox to Filter a Continuous Form

From two student reviews:
Never ceases to amaze me how Bruce can explain and demonstrate the techniques used. Bruce makes learning access usable the moment he explains the technique. – Tony Sulpizio

These workshops are fantastic. They cover specific topics in depth, but in bite-size chunks so you can learn quickly and put what you learn into action right away. They are also great for reference later as you need help or refreshing on a concept. – Kent Ellis

These techniques are practical and usable right away!  Do you want to stand out from the crowd of Access “Experts”?  Learn how to do things that others can’t do!

Just CLICK HERE to get this course now for only $13.99!

——————————
Access Design and Advanced Methods Workshop 8

This course is a response to student questions about specific Access capabilities.  Here is a list of the major topics:

Create an ADD or GO Combo Box – search for customers and automatically add new ones if it is a new name.
Creating and Using Cascading Combo Boxes – selecting from the first combo automatically updates the list on the second, and so on.
Using Excel Date Functions Inside Access – handy Excel functions that do not exist in Access.
Quick Tips:
How to Create Custom Buttons for Your Forms
Use Lightweight Forms for Fast Opening Menus
Fix Tabbing Problems When Using Tab Control In Your Forms
Design Challenge: Easily add the capability to offer quantity discounts without disrupting your database

From two student reviews:
Bruce Myron always creates powerful coding that is elegantly simple but exceptionally powerful and this workshop is no exception. – Keith Beales

Wonderful! I started this course and can’t put it down. Having a great time. Bruce is great!. – John Davy

These techniques are practical and usable right away!  Do you want to stand out from the crowd of Access “Experts”?  Learn how to do things that others can’t do!

Just CLICK HERE to get this course now for only $12.99!

==================
Remember that one of the BEST investments you can make is in increasing your own SKILL and KNOWLEDGE!

Hope to see you in the courses!

Bruce