Microsoft Access Beginners 2016

Microsoft Access Beginners 2016

by Simon Sez IT
Released August 2019
Publisher(s): Packt Publishing
ISBN: 9781839215469

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

What You Will Learn

  • Makes all aspects of Access easy to master while covering new exciting features in 2016
  • Benefit from learning to use the full program, not just the basics
  • Get up-and-running quickly and immediately learn things you can use at work
  • Supercharge your personal projects
  • Practice what you learned with helpful exercise files

Audience

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

About The Author

Simon Sez IT: Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

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