Please log in to access your purchased courses.

In this course, you’ll learn the core database management, manipulation, and query skills needed to succeed in Access 2016. We’ll look at how to create and manage a database, how to build tables, and how to create queries, forms, and reports.

Introduction to Access

Create and Manage Database

In this module, you’ll learn how to create a desktop database and import data from Excel spreadsheets. We’ll also cover how to establish and edit relationships within a database, navigate through a database, and how to protect your database from data loss. Finally, we’ll cover how to print and export data from Access.


Create Database Relationships and Keys Navigate a Database Protect and Maintain a Database Print and Export Data

Build Tables

Tables are the most important object in Access. Every piece of data entered into the database is stored in a table. We’ll look at how to create and manage tables, as well as how to manage records in tables and create and modify fields.


Create Tables Manage Tables and Records Create and Modify Fields

Create Queries

Queries are a way to find data within a table. In this module, we’ll cover how to create and modify queries. We’ll also explain how to create calculated fields and grouping within queries.


Create Queries Calculated Fields Modify a Query

Create Forms

Forms allow users to quickly find, enter and edit data. In this module, we’ll cover how to create forms and configure form controls. We’ll also introduce formatting for forms.


Create Forms Format a Form Configure Form Controls

Create Reports

Reports are the fourth type of object in Microsoft Access. They allow you to easily showcase and print your data. In this module, you’ll learn to create a report, configure report controls and format a report.


Create Reports Format a Report Configure Report Controls