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 2
Section 1: Introduction and Overview
Introduction (3:29)
Section 2: Setting Subform Colors
Overview of Setting Subform Colors (7:37)
Setting Subform Colors with Access VBA (7:21)
Finish Placing Codes and Final Testing (5:19)
Section 3: Using Queries to Create Year Over Year Comparisons
Demonstration and Overview of the Objective (2:16)
Create the Query that Makes the SalesByQuarter Table (6:46)
Start Building the GetLastYear Query (9:20)
Add the Sales Difference to the GetLastYear Query (4:25)
Section 4: Create Running and Page Totals on Reports
Create Running and Page Totals (10:06)
Section 5: Set the Starting Autonumber in a Table
Set the Starting CustID and Append Customer Data (5:33)
Section 6: Back to Record on Open
Overview of the BackToRecord Database (2:28)
Open on Customer Form and Record Values on Exit (10:15)
Modify the Customer Open Subroutine to Use the Values in the Table (8:43)
Section 7: Design Challenge - The Security Company Call List
Overview of the Call List Design Challenge (11:47)
Add VBA Code to the Edit Button (11:14)
A Function to Test for No Records and Add VBA Code to the Add Button (11:15)
Create a Subroutine to Sort the Call List Records (5:01)
Add Code to the Delete Button (9:26)
Start Building Code for the Change To Combo Box (6:45)
Build the LostFocus Sub and Start the AfterUpdate Sub (5:45)
Figure Out How to Handle Change To Renumbering (3:39)
Create the Decrease Sequence Subroutine (6:45)
Create the Increase Sequence Subroutine (7:25)
Testing for Errors (8:45)
Final Testing and Debugging (8:08)
Section 8: Conclusion
Conclusion and Overview of What We Covered (2:07)
Start Building the GetLastYear Query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock