Access Level 1: Fundamentals of Core Features
Build your first real Microsoft Access database. Create tables and relationships, run queries that answer real questions, and design clean forms and print-ready reports - no prior database experience needed.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
Students will learn the fundamentals of Microsoft Access, including how to build database tables and relationships, enter and manage data, create queries, and design forms and reports.
Prerequisites
To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts.
Course outline
- Identify the Elements of the Access Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
- Create a New Database
- Create a Table
- Manage Tables
- Establish Table Relationships
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
- Create a Query
- Add a Calculated Field to a Query
- Create a Form
- View and Edit Data Using an Access Form
- Create a Report
- Add a Control to a Report
- Format the Controls in a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print