1. Introduction FREE CHAPTER

• Introduction to Access 2016 Course
• Acquiring Access 2016
• Structure of the Course
• What's New in Access 2016

2. Using Touch

• Using Access in a Touch Device

3. Getting Started

• Using Database Templates
• Creating, Saving, and Opening Databases
• The Access Workspace and Backstage

4. Help

• Online Help and Tell Me

5. The Ribbon and Toolbars

• The Ribbon
• The Quick Access Toolbar
• Contextual Menus
• The Status Bar

6. Keyboard Shortcuts and Key Tips

• Keyboard Shortcuts
• Key Tips

7. Access Options

• Options

8. Tables

• Creating a Table and Fields
• Indexed Field
• Lookup Wizard
• Numeric Fields
• Exercise 01

9. Importing Data

• Importing Data from Excel
• Exercise 02

10. Backup, Restore, and Repair

• Backing up your Database
• Compact and Repair

11. Datasheet View

• Design in the Datasheet View
• Sorting and Filtering in Datasheet View
• Entering and Modifying Data in Datasheet View

12. Relationships

• Creating a Link Table
• Setting up Relationships
• Exercise 03

13. Forms

• Creating a Form
• Modifying a Form
• Exercise 04
• Forms in Layout View
• Forms in Design View
• Form Design
• Exercise 05

14. Subforms

• Setting up Subforms - Part 1
• Setting up Subforms - Part 2
• Setting up Subform - Part 3
• Exercise 06

15. Queries

• Creating a Query
• Joins
• Query Wizard
• Exercise 07

16. Expressions

• Setting up Validations
• Calculation using Expressions

17. Reports

• Basic Report
• Report Design
• Complex Report
• Exercise 08

18. Printing

• Printing and Print Properties

19. More Data Types

• Yes/No, OLE Object, and Hyperlink Data Types

20. More About Forms

• Form Controls
• Form Themes
• Form Navigation

21. Modal, Dialogs, and Macros

• Introduction to Model Dialog and Macros
• Model Dialog and Macros Continued
• Form Validation
• Adding a Command Button to a Form
• Exercise 09

22. Web App Basics

• Creating an Access Web App
• Importing an Access Database to a Web App
• Exercise 10

23. Exporting

• Exporting an Access Database

24. Application Parts

• Adding Application Parts to a Database

25. More Access Options

• Additional Access 2016 Options

26. Info Tab

• View and Edit Database Properties, and Encrypt with Password

27. Security

• Trust Center Settings

28. Conclusion

• Conclusion