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

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

ExcelIsFun via YouTube Direct link

) Save and Default Table (we’ll edit later) and talk about data that goes into table.

3 of 13

3 of 13

) Save and Default Table (we’ll edit later) and talk about data that goes into table.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

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

Automatically move to the next video in the Classroom when playback concludes

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.