How To Take This Class

Course Overview

In this Microsoft Access 2016 Advanced Training Course, students will learn advanced Microsoft Access skills such as how to secure and manage a database, how to design advanced forms, how to split an Access database for a multi-user environment and how to use macros and VBA in Microsoft Access.

Course Prerequisites

Students should be familiar with the topics covered in, or have attended, the Microsoft Access 2016 Introduction Training course prior to attending this course.

Course Audience

This course is designed for students who wish to automate, secure and distribute Microsoft Access database applications.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Customize a form layout to improve usability and efficiency of data entry
  • Share data across applications
  • Use macros to improve user interface design
  • Use VBA to enhance tasks
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the start-up options

Course Duration

1 Day

Certification Exam

This course can also help students prepare for the Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills certification exam.

Course Outline

  1. Implementing Advanced Form Design
    • Add Controls to Forms
    • Enhance Navigation and Organization of Forms
    • Apply Conditional Formatting
  2. Sharing Data Across Applications
    • Import Data into Access
    • Topic B: Export Access Data
    • Link Tables to External Data Sources
    • Create a Mail Merge
  3. Using Macros to Improve User Interface Design
    • Create a Macro
    • Restrict Records by Using a Condition
    • Validate Data by Using a Macro
    • Automate Data Entry by Using a Macro
  4. How to use VBA in Microsoft Access
    • Getting Started with VBA
    • Enhance Access by Using VBA
  5. Using Advanced Database Management
    • Manage a Database
    • Determine Object Dependency
    • Document a Database
  6. Distributing and Securing a Microsoft Access Database
    • Splitting a Microsoft Access Database for Multiple-User Access
    • Implement Security in an Access Database
    • Convert an Access Database to an ACCDE File
    • Package a Database with a Digital Signature
  7. Managing Switchboards
    • Create a Database Switchboard
    • Modify a Database Switchboard
    • Set Start-up Options

What Students Receive

Each student will receive:
  • A printed courseware manual with examples and hands-on exercises for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2016 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2016 Training course
  • Six months of post-class email support from a Microsoft Access Instructor