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.
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.
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.