Take this
course

Office Productivity / Microsoft

Microsoft Access 2016 for Beginners: Master the Essentials

Fast, easy way to learn this important database application inside and out

Description

Become a super star Access 2016 user everyone relies on with this big 10-hour course with over 70 video tutorials. • Starts from the very beginning • No Microsoft Access experience needed • 70 expertly produced videos • A full 10 hours of instruction • Makes all aspects of Access easy to master • Covers exciting features new for 2016 • Learn to use full program, not just basics • Get up and running quickly • Immediately learn things you can use at work • Supercharge your personal projects • Become the MS Access expert everyone appreciates • Work at your own pace in your spare time • Practice what you learned with included exercise files Microsoft Access 2016 for beginners is the ultimate video instruction course for those with no previous experience. Now you can get the full picture of how Microsoft Access works with clear, easy to understand instruction. This is the impressive 10 hours of instruction spread across 70 professionally produced videos. Microsoft Access is the leading database application that has become a standard in businesses and organizations around the world. These days being able to work with a database is the 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! This course also works great for people who are already familiar with MS Access. You can skip to more advanced processes and learn all about what is new in version 2016. This course will help you increase your value in the workplace. It can also offer big advantages for your personal and social projects. Now you can master one of the most important but little understood parts of MS Office. Contents and Overview Microsoft Access 2016 For Beginners starts at the very beginning show you where to get your copy of MS Access and how to install it on your computer. Before we go further, you get a quick tour of all the new features and improvements in 2016. You will learn how to easily get started with database templates that make the entire process faster. Then you see how to create, save, and open databases. After a tour of Access Workspace and Backstage, you see a complete explanation of the toolbars and ribbons. Next you get a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. Now it's time to create your own working database. Videos step you through the process helping you master details while understanding the big picture. Later the course goes into importing data from Excel, creating and working with forms, and lots of great information on sub-forms. As you become more advanced, you learn Queries, using Validations, how to create Reports, and Printing your projects. This course contains a big 10 Chapters with multiple videos in each chapter for a total of 70 videos. Get started with this course now to easily become expert at MS Access 2016.
Full details

Curriculum

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

Skills

  • Big Data
  • Data Management
  • Microsoft Access
  • Microsoft Office Specialist (MOS)
  • Microsoft Office Professional

Similar Courses

More Courses by this Instructor