Font size:

This course covers the basic skills and concepts students need to use Microsoft Access 2013 or 2016 productively and efficiently. After an introduction to the Access environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access 2016. For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access.

Access 2013 / 2016 - Introduction

  • Getting started
    • Database Concepts
    • Exploring the Access environment
  • Databases and tables
    • Planning and designing databases
    • Exploring tables
    • Creating tables
  • Fields and records
    • Changing the design of a table
    • Finding and editing records
    • Organizing records
  • Data Entry rules
    • Setting field properties
    • Working with input masks
    • Setting validation rules
  • Basic queries
    • Creating and using queries
    • Modifying query results and queries
    • Performing operations in queries
  • Using forms
    • Creating forms
    • Using Design view
    • Sorting and filtering records
  • Working with reports
    • Creating reports
    • Modifying and printing reports
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live3/14/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632538
Virtual Live4/9/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632541
Virtual Live5/9/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632544
Virtual Live6/11/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632548
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items