IT Courses
Microsof 365 Access: Core
In this course, you’ll learn the core database management, manipulation and query skills needed to succeed in Microsoft 365 Access. 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 course, you’ll learn the core database management, manipulation and query skills needed to succeed in Microsoft 365 Access. We’ll look at how to create and manage a database, how to build tables, and how to create queries, forms, and reports.
What You will Learn?
At the end of this workshop, participants should be able to:
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries
- Create a form
- Configure form controls
- Format a form
- Create a report
- Configure report controls
- Format a report
Topics for this course
-
Module 1: Create and Manage a 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.
-
Module 2: 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.
-
Module 3: 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.
-
Module 4: 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.
-
Module 5: 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.