This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 1
Section 1: Introduction and Overview
Introduction (3:37)
Section 2: How to Create a Hack Proof Read-Only Database
Demonstration of the Finished Database (3:14)
Download the Work Database and Create a New Database (6:02)
Create the Open Subroutine (6:22)
Add Security to Prevent Changes (5:10)
Section 3: Create a Search Combo Box and Add Records to the Source Table on the Fly
Open and Examine the AddToList Database (4:04)
Before We Start, Let's Fix a Data Problem (6:07)
Create the Quick Search Combo Box (9:47)
Add VBA Code to Fix the Problems with Our New Combo Box (8:11)
Fix the Combo to Work with the Filters (6:50)
Using a Query to Solve the Problem (8:09)
Now Make it Do Something with the Selection (11:54)
Build the Not In List Subroutine (6:47)
Start Fixing the NotInList Routine (10:12)
Popup the Customer Form (8:57)
Don't Allow Adding Customers if Filters are Active (6:16)
Section 4: Controlling Record Location in Subforms
Overview of What We Want to Accomplish (3:24)
Start Building the Main Form To Order Button (7:19)
Finish the Code for Our To Order Button (5:55)
Test for Clicking the TO ORDER Button from the Main Form (5:31)
Create Code to Go to the Subform (5:34)
Create the Subform Subroutine then Call It (7:33)
Section 5: Database Design Scenario - Loan Company
Inspect Tables and Modify Structure (5:52)
Create the Assign Processor Form (8:55)
Create a Query to Get the Next Processor ID (6:40)
Add an Assign Button and VBA Code to the Form (10:27)
A Couple Last Things to Fix (7:41)
Section 6: Conclusion
Review and Conclusion (3:07)
Popup the Customer Form
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock