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

YouTube·Microsoft Office 365

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.