Office 2016 39

Access 2016: Create Database, Tables & Relationships, Import Excel Table too

DESCRIPTION

Topics in this Video:
(00:01) Introduction
(01:56) Create New Database
(03:52) Save and Default Table (we’ll edit later) and talk about data that goes into table.
(05:36) Import SupplierData Table from an Excel
(08:08) Data Types & Field Properties for SupplierData Table
(18:48) Create a Product Table and add Data Types and Field Properties
(26:00) Data Type Lookup Wizard to Create a One-To-Many Relationship
(28:55) Data Type Lookup Wizard to Two Item Lookup
(30:43) Relationship Window to add “Referential Integrity”
(32:56) Create a Form for the Products Table
(34:54) Test Data Validation of Data Types and Field Properties
(34:54) Add Raw Data using Products Form
(39:41) Summary

NOTES

WORKBOOKS

Download “Office 2016 39” Office-2016-39.zip – Downloaded 5 times – 64 KB







Be the first to comment

Leave a Reply