Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2016 for Beginners: Master the Essentials
Chapter 1: Introduction
Introduction to Access 2016 Course (6:19)
Acquiring Access 2016 (8:44)
Structure of the Course (2:17)
What's New in Access 2016 (2:32)
Course Exercise Files
Course Demo Files
Chapter 2: Using Touch
Using Access in a Touch Device (7:05)
Chapter 3: Getting Started
Using Database Templates (14:46)
Creating, Saving, and Opening Databases (8:45)
The Access Workspace and Backstage (13:44)
Chapter 4: Help
Online Help and Tell Me (9:17)
Chapter 5: The Ribbon and Toolbars
The Ribbon (9:53)
The Quick Access Toolbar (5:31)
Contextual Menus (3:51)
The Status Bar (4:05)
Chapter 6: Keyboard Shortcuts and Key Tips
Keyboard Shortcuts (3:34)
Key Tips (3:11)
Chapter 7: Access Options
General, Current Databases, and Language Options (12:03)
Chapter 8: Tables
Creating a Table and Fields (14:45)
Indexed Field (11:37)
Lookup Wizard (14:31)
Numeric Fields (10:43)
Exercise 01 (4:22)
Chapter 9: Importing Data
Importing Data from Excel (14:59)
Exercise 02 (5:19)
Chapter 10: Backup, Restore, and Repair
Backing up your Database (6:45)
Compact and Repair (7:19)
Chapter 11: Datasheet View
Design in the Datasheet View (11:22)
Sorting and Filtering in Datasheet View (10:37)
Entering and Modifying Data in Datasheet View (12:55)
Chapter 12: Relationships
Creating a Link Table (12:20)
Setting up Relationships (12:55)
Exercise 03 (10:20)
Chapter 13: Forms
Creating a Form (14:57)
Modifying a Form (6:28)
Exercise 04 (2:09)
Forms in Layout View (14:30)
Forms in Design View (14:00)
Form Design (14:33)
Exercise 05 (1:36)
Chapter 14: Subforms
Setting up Subforms - Part 1 (13:01)
Setting up Subforms - Part 2 (10:01)
Setting up Subform - Part 3 (13:55)
Exercise 06 (4:53)
Chapter 15: Queries
Creating a Query (14:26)
Joins (10:51)
Query Wizard (15:09)
Exercise 07 (10:10)
Chapter 16: Expressions
Setting up Validations (12:15)
Calculation using Expressions (9:24)
Chapter 17: Reports
Basic Report (11:56)
Report Design (13:01)
Complex Report (16:42)
Exercise 08 (2:52)
Chapter 18: Printing
Printing and Print Properties (9:27)
Chapter 19: More Data Types
Yes/No, OLE Object, and Hyperlink Data Types (12:22)
Chapter 20: More About Forms
Form Controls (11:24)
Form Themes (14:05)
Navigation Form (12:16)
Chapter 21: Modal, Dialogs, and Macros
Introduction to Model Dialog and Macros (14:19)
Model Dialog and Macros Continued (13:29)
Form Validation (14:59)
Adding a Command Button to a Form (9:36)
Exercise 09 (8:12)
Chapter 22: Web App Basics
Creating an Access Web App (11:27)
Importing an Access Database to a Web App (11:28)
Exercise 10 (5:57)
Chapter 23: Exporting
Exporting an Access Database (4:54)
Chapter 24: Application Parts
Adding Application Parts to a Database (5:06)
Chapter 25: More Access Options
Additional Access 2016 Options (7:12)
Chapter 26: Info Tab
View and Edit Database Properties, and Encrypt with Password (7:26)
Chapter 27: Security
Trust Center Settings (8:15)
Chapter 28: Conclusion
Closing (1:11)
Course Quiz and Certificate of Completion
Creating a Table and Fields
Complete and Continue