Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Import Excel into Access
Introduction
Introduction (2:34)
Section 1 - Get the Data Into Access
Import Problems 1 - Deciding on the Best Way to Import (16:49)
Import Problems 2 - Data in Separate Files (7:47)
Import Problems 3 - Assignment of Data Types (11:58)
Import Problems 4 - Common Import Errors (9:43)
A Clean Import - But Is It? (15:22)
Section 2 - Best Practices in Designing Table Structures
Creating Table Structures with 3 Best Practices (11:57)
Create Last Two Tables and Setup Relationships (11:39)
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
Review and Conclusion (7:49)
Teach online with
Import Problems 1 - Deciding on the Best Way to Import
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock