Search Our Content Library

Learning Path Courses:

• Designing Tables for Better Data Entry

  Designing Tables for Better Data Entry
  (Approximate Duration: 21 minutes)

  Welcome to the Designing Tables for Better Data Entry part of the Microsoft Office, Access 2016 Intermeditate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Understand Table Design
  Set Field Size, Format, Captions, Default Values and Required Fields
  Restrict Data Entry with Validation Rules and Input Masks

  Course Prerequisites
  Access 2016 Beginner
   
  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.

• Sharing Data with Other Applications

  Sharing Data with Other Applications
  (Approximate Duration: 14 minutes)

  Welcome to the Sharing Data with Other Applications part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Export Tables and Queries
  Import/Export Data in TXT and Excel files
  Link External Data Sources
  Use Word Merge

  Course Prerequisites
  Access 2016 Beginner
   
  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 Action Queries

  Working with Action Queries
  (Approximate Duration: 14 minutes)

  Welcome to the Working with Action Queries part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Create Queries to Update, Append and Delete
  Create a Make Table Query
  Change AutoNumber Field Starting Number

  Course Prerequisites
  Access 2016 Beginner 

  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.

• Advanced Query Techniques

  Advanced Query Techniques
  (Approximate Duration: 25 minutes)

  Welcome to the Advanced Query Techniques part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Create Query Joins
  Find Unmatched or Duplicate Queries
  Use Parameter Queries
  Reviewed Calculated Query Fields
  Use Totals and WHERE Statements
  Create a Crosstab Query

  Course Prerequisites
  Access 2016 Beginner
   
  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 Macros

  Automating Processes with Macros
  (Approximate Duration: 24 minutes)

  Welcome to the Automating Processes with Macros part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Create Macros
  Validate and Automate Data Entry
  Use Advanced Data Entry with Macros and DLOOKUP Functions

  Course Prerequisites
  Access 2016 Beginner
   
  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.

• Advanced Form Techniques

  Advanced Form Techniques
  (Approximate Duration: 13 minutes)

  Welcome to the Advanced Form Techniques part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Use Conditional Form Formatting
  Setup Tab Controls
  Create Combo Box and Option Group Controls
  Use a Subform to Show Data from Related Table

  Course Prerequisites
  Access 2016 Beginner
   
  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.

• Advanced Report Techniques

  Advanced Report Techniques
  (Approximate Duration: 13 minutes)

  Welcome to the Advanced Report Techniques part of the Microsoft Office, Access 2016 Intermediate Learning Path

  Course Objectives
  The material presented in this course will help you:
  Insert a Chart on a Report
  Show Data in Columns
  Insert a Subreport
  Configure Reports
  Send Reports

  Course Prerequisites
  Access 2016 Beginner
   
  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.