Completed
Manually Entering Table Data
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