Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download files: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/05Access/Access.htm
Topics in this Video:
1. (00:01) Introduction
2. (01:56) Create New Database
3. (03:52) Save and Default Table (we’ll edit later) and talk about data that goes into table.
4. (05:36) Import SupplierData Table from an Excel
5. (08:08) Data Types & Field Properties for SupplierData Table
6. (18:48) Create a Product Table and add Data Types and Field Properties
7. (26:00) Data Type Lookup Wizard to Create a One-To-Many Relationship
8. (28:55) Data Type Lookup Wizard to Two Item Lookup
9. (30:43) Relationship Window to add "Referential Integrity"
10. (32:56) Create a Form for the Products Table
11. (34:54) Test Data Validation of Data Types and Field Properties
12. (34:54) Add Raw Data using Products Form
13. (39:41) Summary