Microsoft Access 2013 or 2016 - Level 1 - Beginner

Office Applications/Productivity
Delivery Type (Must Select One)
  Online Live Instructor-Led
  A+ Test Voucher ($390) - Set of 2 - $195 Each
  A+ Practice Exam ($70.00)
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions


This hands-on beginners course is suitable for Access 2010/2013/2016 users.
Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.
You will learn the skills necessary to create a new database, construct data tables, design basic forms and reports, run queries and secure your data.

Opening and Closing Access
  • Opening Access
  • Using the Recent List and Opening Files
  • Understanding Security Warnings
  • Understanding the Ribbon and the Status Bar
  • About Your Account
  • Closing Files vs. Closing Access

An Introduction to Databases
  • About Common Database Terms
  • Using the Navigation Pane
  • Understanding Tables and Table Relationships
  • Understanding Queries
  • Understanding Forms
  • Understanding Reports
  • Closing Database Objects

An Introduction to Desktop Databases
  • Opening a Table in Data Sheet View
  • About Keys
  • About Data Types
  • Entering and Editing Data
  • Selecting Records
  • Deleting Records
  • About Fields

Understanding Basic Table Tasks
  • Entering a New Record
  • Saving Records
  • Using the Clipboard
  • Formatting Text
  • Adding a Field by Entering Data

Working With Fields
  • Adding a Specific Type of Field
  • Changing Field Name, Caption, or Description
  • Changing the Data Type
  • Changing Field Format
  • Deleting a Field

Navigating Records
  • Filtering Records
  • Sorting Records
  • Searching for Records Using the Search Box
  • Finding and Replacing Text
  • Navigating Records

An Introduction to Queries, Forms, and Reports
  • Types of Queries
  • Creating a Query with the Wizard
  • Executing a Query
  • About the Different Form Views
  • Viewing a Report
  • Using Print Preview

Protecting Your Data
  • Planning Backups
  • Backing Up a Database
  • Restoring a Database
  • Restoring Objects in a Database

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


Certificate of Course Completion


This hands-on beginners course is suitable for Access 2010/2013/2016 users.


Previous Windows experience recommended


You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.