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.

Syllabus

) 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.