Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download files: http://ift.tt/2jxY9m1
Topics in this Video:
1. (00:01) Introduction
2. (01:22) Report Wizard to Create Inventory Value Report
3. (06:44) Report Wizard to Create Product Re-order Phone List Report
4. (12:26) Summary
Month: December 2017
Office 2016 Video #39: Access 2016: Create Database, Tables & Relationships, Import Excel Table too
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download files: http://ift.tt/2jxY9m1
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