Access Level 1: Fundamentals of Core Features

Level 1Full Day1 DayVersion 365Official CPE Provider

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.

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

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