Microsoft Access VBA, Design and Advanced Methods Workshop 1
4.5 (431 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.
4,533 students enrolled

Microsoft Access VBA, Design and Advanced Methods Workshop 1

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!
4.5 (431 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.
4,533 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
  • 3 hours on-demand video
  • 7 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 VBA 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 design challenge from a student and go over the details of how I would create the database.

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 35 lectures 03:10:21
+ How to Create a Hack Proof Read-Only Database
6 lectures 20:59
Link for Downloading Work Database for this Section
00:04
Download the Work Database and Create a New Database
06:02
Create the Open Subroutine
06:22
Add Security to Prevent Changes
05:10
Print or Download a PDF with the Read Only Database Steps
00:06
+ Create a Search Combo Box and Add Records to the Source Table On the Fly
12 lectures 01:27:18
Link for Downloading Work Database for this Section
00:04
Before We Start, Let's Fix a Data Problem
06:07
Create the Quick Search Combo Box
09:47
Add VBA Code to Fix the Problems with our New Combo Box
08:11
Fix the Combo to Work with the Filters
06:50
Using a Query to Solve the Problem
08:09
Now Make it Do Something With the Selection
11:54
Build the Not In List Subroutine
06:47
Start Fixing the NotInList Routine
10:12
Popup the Customer Form
08:57
Don't Allow Adding Customers if Filters are Active
06:16
+ Controlling Record Location in Subforms
7 lectures 35:22
Link for Downloading Database and Note Sheet for This Section
00:06
Start Building the Main Form To Order Button
07:19
Finish the Code for Our To Order Button
05:55
Test for Clicking the TO ORDER Button from the Main Form
05:31
Create Code to Go To the Subform
05:34
Create the Subform Subroutine then Call It
07:33
+ Database Design Scenario - Loan Company
7 lectures 39:41
Download of Database File
00:03
Inspect Tables and Modify Structure
05:52
Create the Assign Processor Form
08:55
Create a Query to Get the Next Processor ID
06:40
Add an Assign Button and VBA Code to the Form
10:27
A Couple Last Things to Fix
07:41
Download of DONE Database File
00:03
+ Conclusion
2 lectures 03:22
Review and Conclusion
03:07
BONUS Lecture! Learn Even More!
00:15