All Udemy courses come with the 30 Udemy Money Back Guarantee!
During March 2025 my courses can be purchased for $12.99 to 16.99 by using the coupon code 2025MAR
CLICK HERE to get this course!
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.
CLICK HERE to get this course!
Microsoft Access VBA for Non Programmers - YOU can do this!
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.
CLICK HERE to get this course!
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.
CLICK HERE to get this course!
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!
CLICK HERE to get this course!
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!
CLICK HERE to get this course!
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!
CLICK HERE to get this course!
Microsoft 365 Access: Link Data to Excel with Macros and VBA
This course shows you a lot of query tricks and ties them all together with a macro, then it uses 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 Thcopy the linked Excel file and remove the connections, so the file can be distributed to others.
CLICK HERE to get this course!
Microsoft 365 Access: More VBA and Automating Outlook Email
This course 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.
CLICK HERE to get this course!
Customize Excel - Save Time & Be More Productive
How much time do you waste setting up new files the same way over and over in Excel? Isn’t it about time you learned how to customize Excel so you can make it work the way you want from the start?
This course could save you MANY HOURS of time every month!
CLICK HERE to get this course!
Workshop 1: Access VBA, Design and Advanced Methods
In this course we create a hack-proof, “read 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!
CLICK HERE to get this course!
Workshop 2: Access VBA, Design and Advanced Methods
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.
CLICK HERE to get this course!
Workshop 3: Access VBA, Design and Advanced Methods
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!
CLICK HERE to get this course!
Workshop 4: Access VBA, Design and Advanced Methods
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.
CLICK HERE to get this course!
Workshop 5: Access VBA, Design and Advanced Methods
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.
CLICK HERE to get this course!
Workshop 6: Access VBA, Design and Advanced Methods
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
CLICK HERE to get this course!
Workshop 7: Access VBA, Design and Advanced Methods
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 Calendar on Date Fields, Test Query Parameter Values as they are entered, Quick Database Backup button
Highlight the Current Record in a Continuous Form
DESIGN CHALLENGE: Create a Multi Select Listbox to Filter a Continuous Form
CLICK HERE to get this course!
Workshop 8: Access VBA, Design and Advanced Methods
Create an ADD or GO Combo Box – search for customers and automatically add new ones if it is a new name.
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: Custom Buttons, Use Lightweight Forms for Fast Opening Menus, Fix Tabbing Problems
Design Challenge: Easily add the capability to offer quantity discounts without disrupting your database