Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2021/365 for Beginners
Section 1: Introduction
Introduction to Access 2021 (4:49)
DOWNLOAD ME: Instructor Files
DOWNLOAD ME: Course Exercise Files
Acquiring Access 2021 (3:56)
What's New in Access 2021? (3:32)
Exercise 01 (1:23)
Section 2: Get Started with Access 2021
Use Database Templates (8:21)
Create, Save, and Open Databases (8:51)
Explore the Access Interface and Backstage (11:19)
Customize the Quick Access Toolbar (6:04)
Access Menus (4:55)
Keyboard Shortcuts and Key Tips (5:54)
Online Help (5:38)
Access Options (7:59)
Exercise 02 (3:27)
Section 3: Work with Tables
Create a Table and Fields (7:47)
Index Fields, Primary Keys, and Add Records (6:42)
Use the Lookup Wizard to Create a Drop-down List (7:38)
Numeric Fields and Data Validation Rules (7:18)
Add More Table Fields (4:34)
Exercise 03 (6:06)
Section 4: Import Data
Importing Data from Excel (4:46)
Import Data from a Text File (4:02)
Exercise 04 (1:35)
Section 5: Datasheet View
Design in the Datasheet View (5:45)
Sort and Filter in Datasheet View (6:03)
Enter and Modify Data in Datasheet View (5:13)
Exercise 05 (3:35)
Section 6: Create Relationships
Relationships Explained (3:34)
Set up Relationships (4:26)
Create a Link Table: Part 1 (5:57)
Create a Link Table: Part 2 (6:33)
Edit the Link Table (11:50)
Exercise 06 (3:55)
Section 7: Forms
Create a Form: Form Wizard (6:20)
Form Properties (8:00)
Modify a Form: Single Form vs Continuous View (5:25)
Forms in Layout View (10:04)
Forms in Design View (13:14)
Exercise 07 (4:00)
Section 8: Subforms
Setting up Subforms: Part 1 (8:20)
Setting up Subforms: Part 2 (11:04)
Exercise 08 (8:45)
Section 9: Queries
Create a Query (11:43)
INNER, RIGHT, and LEFT Joins (4:55)
Run Queries and Aggregate Numeric Data using Query Wizard (6:39)
Exercise 09 (2:53)
Section 10: Validations and Expressions
Set up More Validations and Expressions (7:02)
Basic Calculations using Expressions (8:58)
Exercise 10 (3:35)
Section 11: Reports
Run a Basic Report (5:56)
Custom Report Design (13:13)
Complex Reports (4:50)
Exercise 11 (5:33)
Section 12: More Data Types
Other Data Types: Yes/No (6:02)
Other Data Types: Attachments (5:44)
Exercise 12 (3:44)
Section 13: More About Forms
Form Controls: Option Buttons (9:57)
Form Themes and Design (9:31)
Navigation Forms (8:05)
Exercise 13 (5:56)
Section 14: Share an Access Database
Export Parts of an Access Database (7:23)
Database Properties and Encryption (6:50)
Exercise 14 (3:22)
Section 15: Additional Access Features
Compact and Repair (3:34)
Printing and Database Documenter (7:01)
Exercise 15 (3:18)
Section 16: Course Close
Course Close (5:14)
Course Quiz and Certificate of Completion
Acquiring Access 2021
Complete and Continue