Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2019 for Beginners: Start Your Database Journey
Chapter 1: Introduction
Introduction to Access 2019 (3:19)
Acquiring Access 2019 (4:24)
Structure of the Course (2:22)
Course Exercise Files
Course Demo Files
Chapter 2: Using Touch
Using Database Templates (10:56)
Creating, Saving and Opening Databases (6:41)
The Access Workspace and Backstage (13:41)
Online Help and Tell Me What You Want To Do (8:42)
Chapter 3: The Ribbon and Toolbars
Working with the Ribbon (9:28)
The Quick Access Toolbar (5:57)
Contextual Menus (2:39)
The Status Bar (4:07)
Chapter 4: Keyboard Shortcuts and Key Tip
Keyboard Shortcuts (3:36)
Key Tips (3:52)
Chapter 5: Access Options
Exploring Acces Options (9:15)
Chapter 6: Tables
Creating a Table and Fields (11:30)
Indexed Field (8:42)
Lookup Wizard (11:35)
Numeric Fields (7:46)
Practice Exercise 01 (3:07)
Chapter 7: Importing Data
Importing Data from Excel (10:57)
Practice Exercise 02 (5:38)
Chapter 8: Backup, Restore and Repair
Backing up your Database (3:56)
Compact and Repair (6:23)
Chapter 9: Datasheet View
Design in the Datasheet View (10:12)
Sorting and Filtering in Datasheet View (9:55)
Entering and Modifying Data in Datasheet View (10:56)
Chapter 10: Relationships
Creating a Link Table (10:35)
Setting up Relationships (9:55)
Practice Exercise 03 (10:21)
Chapter 11: Forms
Creating a Form (12:41)
Modifying a Form (5:15)
Practice Exercise 04 (2:08)
Forms in Layout View (11:11)
Forms in Design View (10:00)
Form Design (11:10)
Practice Exercise 05 (1:33)
Chapter 12: Subforms
Setting Up Subforms - Part 1 (13:02)
Setting Up Subforms - Part 2 (9:13)
Setting Up Subforms - Part 3 (13:23)
Practice Exercise 06 (4:13)
Chapter 13: Queries
Creating a Query (13:27)
Joins (8:30)
Query Wizard (12:39)
Practice Exercise 07 (9:45)
Chapter 14: Expressions
Setting Up Validations (10:40)
Calculation using Expressions (8:43)
Chapter 15: Reports
Basic Reports (7:46)
Report Design (10:43)
Complex Reports (13:29)
Practice Exercise 08 (2:23)
Chapter 16: Printing
Printing and Print Properties (7:54)
Chapter 17: More Data Types
Yes/No, OLE Objects and Hyperlink Data Types (11:21)
Chapter 18: More About Forms
Form Controls (11:15)
Form Themes (12:37)
Navigation Forms (9:52)
Chapter 19: Exporting
Exporting an Access Database (4:16)
Chapter 20: Application Parts
Adding Application Parts to a Database (4:48)
Chapter 21: More Access Options
Additional Access 2019 Options (5:42)
Chapter 22: Info Tab
Edit Database Properties and Encrype with Password (5:31)
Chapter 23: Course Close
Course Close (1:06)
Course Quiz and Certificate of Completion
Using Database Templates
Complete and Continue