Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Workshop 1: Access VBA, Design and Advanced Methods

Name: Workshop 1: Access VBA, Design and Advanced Methods
Rating: 4.7 (804 reviews)

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created byBruce Myron

Last updated 6/2024

English

What you'll learn

Perform several advanced Microsoft Access VBA techniques that will enable them to create more robust database systems

Course content

6 sections • 30 lectures • 3h 10m total length

Introduction3:37
Important NOTE on DOWNLOADABLE RESOURCES0:19

Demonstration of the Finished Database3:14
Demonstrate building a read-only network database that lets users view data through a form while preventing any edits via VBA password protection.
Download the Work Database and Create a New Database6:02
Create the Open Subroutine6:22
Add Security to Prevent Changes5:10
Lock the VBA project with a password to make the database read-only and prevent edits; compile to an executable and set the startup form to the customer list.
Print or Download a PDF with the Read Only Database Steps0:06

Open and Examine the AddToList Database4:04
Before We Start, Let's Fix a Data Problem6:07
Create the Quick Search Combo Box9:47
Add VBA Code to Fix the Problems with our New Combo Box8:11
Fix the Combo to Work with the Filters6:50
Using a Query to Solve the Problem8:09
Now Make it Do Something With the Selection11:54
Build the Not In List Subroutine6:47
Start Fixing the NotInList Routine10:12
Popup the Customer Form8:57
Open the customer form in dialog mode from the main form using cust ID as open args, then requery the recordset and set focus to last name in proper case.
Don't Allow Adding Customers if Filters are Active6:16

Overview of What We Want to Accomplish3:24
Start Building the Main Form To Order Button7:19
Finish the Code for Our To Order Button5:55
Complete the to order button by passing the order number and customer ID to the orders form, filtering by order number when defined, otherwise by the customer ID.
Test for Clicking the TO ORDER Button from the Main Form5:31
Create Code to Go To the Subform5:34
Create the Subform Subroutine then Call It7:33

Inspect Tables and Modify Structure5:52
Create the Assign Processor Form8:55
Create a Query to Get the Next Processor ID6:40
Add an Assign Button and VBA Code to the Form10:27
Add an assign button (assign btn) to the form and code its on-click to verify assign date and processor ID; if unassigned, fetch them with now, close recordset, and refresh.
A Couple Last Things to Fix7:41
Adjust the access form data source to sort unassigned loans by assign date and loan number. Add an inactive flag to processors and use sql to exclude inactive processors.

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.

Workshop 1: Access VBA, Design and Advanced Methods

What you'll learn

Explore related topics

Course content

Introduction and Overview2 lectures • 4min

How to Create a Hack Proof Read-Only Database5 lectures • 21min

Create a Search Combo Box and Add Records to the Source Table On the Fly11 lectures • 1hr 27min

Controlling Record Location in Subforms6 lectures • 35min

Database Design Scenario - Loan Company5 lectures • 40min

Conclusion1 lecture • 3min

Requirements

Description

Who this course is for: