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 3
Section 1: Introduction and Overview
Introduction (2:24)
Section 2: Using SendKeys and SelStart
What is SendKeys and How and When to Use It (8:33)
Using SelStart Instead of SendKeys (11:13)
Fix the Customer Prompt (3:00)
Using SelLength and SelStart with Text Boxes (4:26)
Section 3: Creating a Stopwatch Program
Create a New Module and the Stopwatch Function (7:40)
Finish the StopWatch and Test (3:57)
Section 4: Understanding and Using AutoKeys
What Is AutoKeys? (3:53)
Section 5: Generating Random Values
Setting Up a Random Values Example (6:30)
Finish and Run the Plug Customer Type Function (3:53)
Section 6: Create a Generic Three Button Form
Create the New Form and Add Controls (8:44)
Create the Open and Click Subroutines (8:33)
Create the Add Customer Button (9:07)
Modify the Three Button Form (4:44)
Finish the Add Customer Subroutine (8:20)
Section 7: Design Challenge - Cleaning Phone Number Data
Examine Records and Create FixPhone Function (6:09)
Start Building the FixPhone Function (8:02)
Finish the FixPhone Function (8:03)
Final Fixes on the NewPhone Data (9:24)
Modify FixPhone into a Generic Tool (6:48)
Section 8: Conclusion
Conclusion and Review (2:58)
Create a New Module and the Stopwatch Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock