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.

Downloading the example code for this course: You can download the example code files for this course on GitHub at the following link: https://github.com/PacktPublishing/Microsoft-Access-Beginners-2016. If you require support please email: customercare@packt.com

Table of Contents

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

Product Information

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