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
Lessons
Getting StartedCreate 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.
Lessons
Create Database Relationships and Keys Navigate a Database Protect and Maintain a Database Print and Export DataBuild 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.
Lessons
Create Tables Manage Tables and Records Create and Modify FieldsCreate 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.
Lessons
Create Queries Calculated Fields Modify a QueryCreate 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.
Lessons
Create Forms Format a Form Configure Form ControlsCreate 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.