Search Our Content Library

Learning Path Courses:

• Improving the Structure of a Database

  Improving the Structure of a Database
  (Approximate Duration: 20 minutes)

  Welcome to the Improving the Structure of a Database part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Use the Table Analyzer Wizard
  Append Querying to Normalize a Table
  Create a Junction Table

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Maintaining a Database

  Maintaining a Database
  (Approximate Duration: 11 minutes)

  Welcome to the Maintaining a Database part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Backup a Database
  Use Compact and Repair Tool
  Use Object Dependencies Tool
  Use Database Documenter Tool
  Use Performance Analyzer Tool

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Working with Access Switchboards

  Working with Access Switchboards
  (Approximate Duration: 22 minutes)

  Welcome to the Working with Access Switchboards part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Setup, Use and Modify the Access Switchboard
  Set the Startup Options

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Configuring Access for Multiple Users

  Configuring Access for Multiple Users
  (Approximate Duration: 11 minutes)

  Welcome to the Configuring Access for Multiple Users part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Use the Database Splitter
  Configure Trusted Locations
  Setup Password Protection
  Convert a Database to an ACCDE File

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Automating Processes with VBA

  Automating Processes with VBA
  (Approximate Duration: 24 minutes)

  Welcome to the Automating Processes with VBA part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Understand VBA Basics
  Use Variables and Control Flow Statements
  Export with VBA
  Convert a Macro to VBA

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Using Table Events

  Using Table Events
  (Approximate Duration: 11 minutes)

  Welcome to the Using Table Events part of the Microsoft Office, Access 2016 Advanced Learning Path

  Course Objectives
  The material presented in this course will help you:
  Understand Table Events
  Use the Before and After Change Event commands

  Course Prerequisites
  Access 2016 Beginner
  Access 2016 Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.