Microsoft Access Beginners 2016

Video description

Learn how Microsoft Access 2016 works with clear, easy-to-understand instructions

About This Video

  • Learn and master the exciting features of MS Access 2016
  • A practical course designed to teach you MS Access 2016 with helpful exercise files

In Detail

Microsoft Access is the leading database application and has become a standard in businesses and organizations around the World. These days, having the ability to work with a database is key to running an efficient and capable operation. Bosses everywhere appreciate any employee who is well trained in MS Access. Now that person can be you!

Microsoft Access 2016 for Beginners starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all the new features and improvements in 2016.

You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save, and open databases.

After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll master keyboard shortcuts that will greatly increase your speed and efficiency.

You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture.

Later, the course explores importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports, and print your projects.

Who this book is for

This course is designed for beginners keen to master Microsoft Access 2016.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction
    1. Introduction to Access 2016 Course
    2. Acquiring Access 2016
    3. Structure of the Course
    4. What's New in Access 2016
  2. Chapter 2 : Using Touch
    1. Using Access in a Touch Device
  3. Chapter 3 : Getting Started
    1. Using Database Templates
    2. Creating, Saving, and Opening Databases
    3. The Access Workspace and Backstage
  4. Chapter 4 : Help
    1. Online Help and Tell Me
  5. Chapter 5 : The Ribbon and Toolbars
    1. The Ribbon
    2. The Quick Access Toolbar
    3. Contextual Menus
    4. The Status Bar
  6. Chapter 6 : Keyboard Shortcuts and Key Tips
    1. Keyboard Shortcuts
    2. Key Tips
  7. Chapter 7 : Access Options
    1. Options
  8. Chapter 8 : Tables
    1. Creating a Table and Fields
    2. Indexed Field
    3. Lookup Wizard
    4. Numeric Fields
    5. Exercise 01
  9. Chapter 9 : Importing Data
    1. Importing Data from Excel
    2. Exercise 02
  10. Chapter 10 : Backup, Restore, and Repair
    1. Backing up your Database
    2. Compact and Repair
  11. Chapter 11 : Datasheet View
    1. Design in the Datasheet View
    2. Sorting and Filtering in Datasheet View
    3. Entering and Modifying Data in Datasheet View
  12. Chapter 12 : Relationships
    1. Creating a Link Table
    2. Setting up Relationships
    3. Exercise 03
  13. Chapter 13 : Forms
    1. Creating a Form
    2. Modifying a Form
    3. Exercise 04
    4. Forms in Layout View
    5. Forms in Design View
    6. Form Design
    7. Exercise 05
  14. Chapter 14 : Subforms
    1. Setting up Subforms - Part 1
    2. Setting up Subforms - Part 2
    3. Setting up Subform - Part 3
    4. Exercise 06
  15. Chapter 15 : Queries
    1. Creating a Query
    2. Joins
    3. Query Wizard
    4. Exercise 07
  16. Chapter 16 : Expressions
    1. Setting up Validations
    2. Calculation using Expressions
  17. Chapter 17 : Reports
    1. Basic Report
    2. Report Design
    3. Complex Report
    4. Exercise 08
  18. Chapter 18 : Printing
    1. Printing and Print Properties
  19. Chapter 19 : More Data Types
    1. Yes/No, OLE Object, and Hyperlink Data Types
  20. Chapter 20 : More About Forms
    1. Form Controls
    2. Form Themes
    3. Form Navigation
  21. Chapter 21 : Modal, Dialogs, and Macros
    1. Introduction to Model Dialog and Macros
    2. Model Dialog and Macros Continued
    3. Form Validation
    4. Adding a Command Button to a Form
    5. Exercise 09
  22. Chapter 22 : Web App Basics
    1. Creating an Access Web App
    2. Importing an Access Database to a Web App
    3. Exercise 10
  23. Chapter 23 : Exporting
    1. Exporting an Access Database
  24. Chapter 24 : Application Parts
    1. Adding Application Parts to a Database
  25. Chapter 25 : More Access Options
    1. Additional Access 2016 Options
  26. Chapter 26 : Info Tab
    1. View and Edit Database Properties, and Encrypt with Password
  27. Chapter 27 : Security
    1. Trust Center Settings
  28. Chapter 28 : Conclusion
    1. Conclusion

Product information

  • Title: Microsoft Access Beginners 2016
  • Author(s): Simon Sez IT
  • Release date: August 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839215469