Search Our Content Library

Learning Path Courses:

• Getting Started with Access 2016

  Getting Started with Access 2016
  (Approximate Duration: 36 minutes)

  Welcome to the Getting Started with Access 2016 part of the Microsoft Office, Access 2016 Beginner Learning Paths

  Course Objectives
  The material presented in this course will help you to understand:
  What is a Database and Database Terminology
  Navigation of the Access Interface
  What are a Flat and Relational Database
  Relating Tables
  The Access Ribbon

  Course Prerequisites
  None
   
  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 Data

  Working with Data
  (Approximate Duration: 15 minutes)

  Welcome to the Working with Data part of the Microsoft Office, Access 2016 Beginner Learning Path

  Course Objectives
  The material presented in this course will help you to:
  Work with Tables
  Navigate in Tables
  Edit Data
  Add New Records
  Using Subdatasheets

  Course Prerequisites
  None
   
  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.

• Creating Databases and Objects

  Creating Databases and Objects
  (Approximate Duration: 45 minutes)

  Welcome to the Creating Databases and Objects part of the Microsoft Office, Access 2016 Beginner Learning Path

  Course Objectives
  The material presented in this course will help you:
  Understand Database and Table Design
  Use Table Data Sheet View
  Work with Field Data Types
  Use Table Design View
  Calculate Fields, Numbers, Dates and Strings
  Use the Lookup Wizard
  Edit Lookups
  Use Indexes

  Course Prerequisites
  None
   
  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 Queries

  Working with Queries
  (Approximate Duration: 31 minutes)

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

  Course Objectives
  The material presented in this course will help you to:
  Create Simple and Multi-Table Queries
  Understand the Dynaset
  Enter Criteria (exact match and range operators)
  Understand AND and OR functions
  Use Wild Cards and Keywords
  Sort and Hide Fields
  Create multi-table queries
  Additonal tips

  Course Prerequisites
  None
   
  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 Reports

  Working with Reports
  (Approximate Duration: 26 minutes)

  Welcome to the Working with Reports part of the Microsoft Office, Access 2016 Beginner Learning Path

  Course Objectives
  The material presented in this course will help you to:
  Understand and Build Reports
  Use AutoReport and the Report Wizard
  Use the Report Design View
  Create Labels

  Course Prerequisites
  None
   
  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 Forms

  Working with Forms
  (Approximate Duration: 28 minutes)

  Welcome to the Working with Forms part of the Microsoft Office, Access 2016 Beginner Learning Path

  Course Objectives
  The material presented in this course will help you:
  Create, Navigate and Edit Data in Forms
  Use the Form Wizard and Form Design View
  Work with Controls
  Use Form Layout View

  Course Prerequisites
  None
   
  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.