Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Access 2021 Beginner
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (1:29)
Database Basics (1:58)
Introduction to Database Objects and the Access Interface (3:12)
Accessing the Northwind Template (3:09)
Exploring the Login and Homes Forms (2:48)
Navigation Pane Default View and Datasheet and Design Views for Tables (3:18)
Exploring Datasheet View, Design View, and SQL View for Query Objects (3:20)
Exploring Form View, Layout View, and Design View for Form Objects (1:38)
Exploring Report View, Layout View, Design View, and Print Preview for Report Objects (2:32)
Running Macros and Exploring Design View (2:15)
Examining VBA Code (1:07)
Access Ribbon and Status Bar (3:44)
Exploring the Relationships Window and Closing the Database (4:15)
Introduction to Creating New Databases (6:18)
Creating Blank Databases (1:23)
Switching Default Table to Design View and Renaming the Primary Key Field (3:33)
Adding Remaining Fields to the Customers Table (3:10)
Field Descriptions, Format and Text Limit, and Input Mask (7:03)
Using the Caption Field Property (1:51)
Creating New Tables in Design View (4:41)
Introduction to Entering Data into Tables (0:31)
Manually Entering Table Data (2:43)
Importing from Excel - Appending to Existing Table - Employees (4:18)
Importing from Excel - Appending with Different Data Types Error - Customers (3:57)
Importing from Excel - Adding Data into A New Table - Categories (3:14)
Importing from Excel - Adding Data into New Tables (1:47)
Reviewing Data Types and Field Properties for Imported Tables - Products (5:03)
Reviewing Data Types and Field Properties for Imported Tables - Orders (2:57)
Order Details Table - Discussing Composite Key Fields (2:03)
Setting a Composite Key - Order Details (2:54)
Sorting Table Data (1:41)
Inclusive Filtering, Exclusive Filtering, and Filtering by Form (4:08)
Introduction to Relationships (2:36)
Adding Tables to the Relationships Window and Organizing Them (3:39)
Common Fields Between Tables (0:27)
Creating a One-To-Many Relationship Between Customers and Employees Tables (4:30)
Creating Relationship Errors (2:29)
Resolving Data Type Errors and Repopulating Table Fields (5:13)
Manually Repopulating Table Fields (1:00)
Creating Lookup Fields in a Table (2:35)
Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error (4:37)
Resolving a Data Type Error and Repopulating Table Fields (3:59)
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship (4:50)
Database Basics Recap (1:42)
Conclusion (0:06)
Setting a Composite Key - Order Details
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock