Access 2016 - Create Database, Tables & Relationships, Import Excel Table Too

Learn how to create and manage databases in Access 2016 with this comprehensive 41-minute tutorial. Begin by creating a new database and understanding the default table structure. Import data from Excel into Access, and explore data types and field properties for the SupplierData table. Create a Product table with custom data types and field properties. Utilize the Data Type Lookup Wizard to establish one-to-many relationships and create two-item lookups. Navigate the Relationship Window to implement referential integrity. Design a form for the Products table, test data validation, and add raw data using the newly created form. Download accompanying files to follow along and practice these essential Access 2016 skills.

) Introduction.
) Create New Database.
) Save and Default Table (we’ll edit later) and talk about data that goes into table..
) Import SupplierData Table from an Excel.
) Data Types & Field Properties for SupplierData Table.
) Create a Product Table and add Data Types and Field Properties.
) Data Type Lookup Wizard to Create a One-To-Many Relationship.
) Data Type Lookup Wizard to Two Item Lookup.
) Relationship Window to add "Referential Integrity".
) Create a Form for the Products Table.
) Test Data Validation of Data Types and Field Properties.
) Add Raw Data using Products Form.
) Summary.