Microsoft Access VBA, Design and Advanced Methods Workshop 5
4.9 (97 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,287 students enrolled

Microsoft Access VBA, Design and Advanced Methods Workshop 5

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!
4.9 (97 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,287 students enrolled
Created by Bruce Myron
Last updated 4/2020
English
English [Auto]
Current price: $48.99 Original price: $69.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 6 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems
Requirements
  • Students should have had some exposure to Microsoft Access VBA.
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 

Who this course is for:
  • A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.
Course content
Expand all 24 lectures 02:10:04
+ How to Set RANGES on Filters Using Combo Boxes
4 lectures 26:38
Link for Downloading the COMBOFILTER Database and Open It
00:04
Clone the GotFocus Subroutine and Create the Lost Focus Subroutines
08:12
Update the BuildFiltStr Subroutine and Test Our Changes
07:52
+ Using Option Buttons to Save Text Values
4 lectures 20:35
Link for Downloading the OPTION BUTTONS Database
00:04
Overview of the Problem with Option Buttons
05:26
Use VBA to Get Text into the HowFound Field
10:01
One Last Problem - What If We Click an Option By Mistake?
05:04
+ Printing Labels and Multi Column Reports
5 lectures 25:59
Link for Downloading the PRINT LABELS Database
00:05
Setup a Common Label Report
04:34
Creating a Custom Label Format
06:35
Create a Multi Column Report from Scratch
09:37
Fix Last Problems with the Multi Column Report
05:08
+ Using the Database Documenter
2 lectures 06:38
Link for Downloading the DOCUMENTER Database
00:05
How I Use the Database Documenter
06:33
+ Design Challenge: Reports for Selected Dates Within a Date Range
6 lectures 42:08
Link for Downloading the SELECT DATES Database
00:05
Overview of Objective and Create VBA Subroutine
08:08
Add More Code to Our Subroutine
07:57
Create a Form for Selecting Dates
08:29
Update the Table to Remove Dates not Selected
11:28
Modify the Report to Show if Run With Selected Dates
06:01
+ Conclusion
2 lectures 03:42
Conclusion and Review
03:27
BONUS Lecture! Learn Even More!
00:15