Introduction
Section 1 - Get the Data Into Access
Section 2 - Best Practices in Designing Table Structures
Section 3 - Using Queries to Fill the New Tables
-
Fill the Product Table (18:14)
-
Demo of what can be done with VBA (11:22)
-
Start Working on the Customer Table (11:18)
-
Find the Potential Problem Customer Records (11:06)
-
One Last Check for Unique Values (14:12)
-
Populate the Customer Table and Create CustID's (6:56)
-
Fill the Orders Table (9:57)
-
Final Cleanup (2:55)
Conclusion
