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 8
Section 1: Introduction
Introduction (8:58)
WS8PROMO (3:04)
Section 2: Create an ADD or GO Combo Box
Create the Add or Go Box (10:35)
Create the ADD Part with VBA (7:29)
Create the GO Part by Adding to the VBA Subroutine (5:18)
Section 3: Creating and Using Cascading Combo Boxes
Get the Combo Boxes Working (9:14)
Make the Combos Filter the Data (10:58)
Section 4: Using Excel Date Functions Inside Access
Layout of the Form and Using the Excel NetworkDays Function (12:23)
Use the Rest of the Functions and Create a Module (7:40)
Section 5: Quick Tips
How to Create Custom Buttons for Your Forms (7:51)
Use Lightweight Forms for Fast Opening Menus (5:59)
Fix Tabbing Problems When Using Tab Control in your Forms (13:47)
Section 6: Design Challenge - Add the Capability to Offer Quantity Discounts
Demonstration of the Finished Database (8:33)
Review Qty Afterupdate and Build a New Subtable and Form (13:28)
Build a Query to Emulate Excel's VLookup Function (4:49)
Update the Qty Afterupdate Subroutine (9:22)
Make the Delete and Exit Buttons Work (5:45)
Section 7: Conclusion
Conclusion and Review (2:19)
Build a Query to Emulate Excel's VLookup Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock