Access Level 1: Fundamentals of Core Features

Level 1Full Day1 DayVersion 365Official CPE Provider

Course Outline

6 lessons · 19 topics

1Getting Started with Access

Identify the Elements of the Access Interface
Identify the Components of a Database
Examine the Relational Database Design Process

2Building the Structure of a Database

Create a New Database
Create a Table
Manage Tables
Establish Table Relationships

3Managing Data in a Table

Modify Table Data
Sort and Filter Records
Work with Subdatasheets

4Querying a Database

Create a Query
Add a Calculated Field to a Query

5Designing Forms

Create a Form
View and Edit Data Using an Access Form

6Generating Reports

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

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals