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