Completed
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Access 2021 Beginner Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Database Basics
- 4 Introduction to Database Objects and the Access Interface
- 5 Accessing the Northwind Template
- 6 Exploring the Login and Homes Forms
- 7 Navigation Pane Default View and Datasheet and Design Views for Tables
- 8 Exploring Datasheet View, Design View, and SQL View for Query Objects
- 9 Exploring Form View, Layout View, and Design View for Form Objects
- 10 Exploring Report View, Layout View, Design View, and Print Preview for Report Objects
- 11 Running Macros and Exploring Design View
- 12 Examining VBA Code
- 13 Access Ribbon and Status Bar
- 14 Exploring the Relationships Window and Closing the Database
- 15 Introduction to Creating New Databases
- 16 Creating Blank Databases
- 17 Switching Default Table to Design View and Renaming the Primary Key Field
- 18 Adding Remaining Fields to the Customers Table
- 19 Field Descriptions, Format and Text Limit, and Input Mask
- 20 Using the Caption Field Property
- 21 Creating New Tables in Design View
- 22 Introduction to Entering Data into Tables
- 23 Manually Entering Table Data
- 24 Importing from Excel - Appending to Existing Table - Employees
- 25 Importing from Excel - Appending with Different Data Types Error - Customers
- 26 Importing from Excel - Adding Data into A New Table - Categories
- 27 Importing from Excel - Adding Data into New Tables
- 28 Reviewing Data Types and Field Properties for Imported Tables - Products
- 29 Reviewing Data Types and Field Properties for Imported Tables - Orders
- 30 Order Details Table - Discussing Composite Key Fields
- 31 Setting a Composite Key - Order Details
- 32 Sorting Table Data
- 33 Inclusive Filtering, Exclusive Filtering, and Filtering by Form
- 34 Introduction to Relationships
- 35 Adding Tables to the Relationships Window and Organizing Them
- 36 Common Fields Between Tables
- 37 Creating a One-To-Many Relationship Between Customers and Employees Tables
- 38 Creating Relationship Errors
- 39 Resolving Data Type Errors and Repopulating Table Fields
- 40 Manually Repopulating Table Fields
- 41 Creating Lookup Fields in a Table
- 42 Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error
- 43 Resolving a Data Type Error and Repopulating Table Fields
- 44 Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship
- 45 Database Basics Recap
- 46 Conclusion