Introduction
  • Introduction to Access 2016 Course
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Downloadable Course Transcripts
  • Acquiring Access 2016
  • Structure of the Course
  • What's New in Access 2016
  • Section 1 - Quiz
Using Touch
  • Using Access in a Touch Device
  • Section 2 - Quiz
Getting Started
  • Using Database Templates
  • Creating, Saving, and Opening Databases
  • The Access Workspace and Backstage
  • Section 3 - Quiz
Help
  • Online Help and Tell Me
  • Section 4 - Quiz
The Ribbon and Toolbars
  • The Ribbon
  • The Quick Access Toolbar
  • Contextual Menus
  • The Status Bar
  • Section 5 - Quiz
Keyboard Shortcuts and Key Tips
  • Keyboard Shortcuts
  • Key Tips
  • Section 6 - Quiz
Access Options
  • General, Current Databases, and Language Options
  • Section 7 - Quiz
Tables
  • Creating a Table and Fields
  • Indexed Field
  • Lookup Wizard
  • Numeric Fields
  • Exercise 01
  • Section 8 - Quiz
Importing Data
  • Importing Data from Excel
  • Exercise 02
  • Section 9 - Quiz
Backup, Restore, and Repair
  • Backing up your Database
  • Compact and Repair
  • Section 10 - Quiz
Datasheet View
  • Design in the Datasheet View
  • Sorting and Filtering in Datasheet View
  • Entering and Modifying Data in Datasheet View
  • Section 11 - Quiz
Relationships
  • Creating a Link Table
  • Setting up Relationships
  • Exercise 03
  • Section 12 - Quiz
Forms
  • Creating a Form
  • Modifying a Form
  • Exercise 04
  • Forms in Layout View
  • Forms in Design View
  • Form Design
  • Exercise 05
  • Section 13 - Quiz
Subforms
  • Setting up Subforms - Part 1
  • Setting up Subforms - Part 2
  • Setting up Subform - Part 3
  • Exercise 06
  • Section 14 - Quiz
Queries
  • Creating a Query
  • Joins
  • Query Wizard
  • Exercise 07
  • Section 15 - Quiz
Expressions
  • Setting up Validations
  • Calculation using Expressions
  • Section 16 - Quiz
Reports
  • Basic Report
  • Report Design
  • Complex Report
  • Exercise 08
  • Section 17 - Quiz
Printing
  • Printing and Print Properties
  • Section 18 - Quiz
More Data Types
  • Yes/No, OLE Object, and Hyperlink Data Types
  • Section 19 - Quiz
More About Forms
  • Form Controls
  • Form Themes
  • Navigation Form