Access – Part 1

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Course Details

Price:

$590.00

Days:

Location:

Virtual

Course Overview

Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports.

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills Basic IP address knowledge

1 – GETTING STARTED WITH ACCESS

Topic A: Launch Access and Open a Database
Topic B: Use Tables to Store Data
Topic C: Use Queries to Combine, Find, Filter, and Sort Data
Topic D: Use Forms to View, Add, and Update Data
Topic E: Use Reports to Present Data
Topic F: Get Help and Configure Options in Microsoft Access

2 – CREATING TABLES

Topic A: Plan an Access Database
Topic B: Start a New Access Database
Topic C: Create a New Table
Topic D: Establish Table Relationships

3 – CREATING QUERIES

Topic A: Create Basic Queries
Topic B: Perform Calculations in a Query
Topic C: Sort and Filter Data in a Query

4 – CREATING FORMS

Topic A: Start a New Form
Topic B: Enhance a Form

5 – CREATING REPORTS

Topic A: Start a New Report
Topic B: Enhance Report Layout

6 – PROMOTING QUALITY DATA INPUT

Topic A: Restrict Data Input Through Field Validation
Topic B: Restrict Data Input Through Forms and Record Validation

7 – IMPROVING EFFICIENCY AND DATA INTEGRITY

Topic A: Data Normalization
Topic B: Associate Unrelated Tables
Topic C: Enforce Referential Integrity

Class Dates & Times


07/21/2025 - 07/22/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
09/04/2025 - 09/05/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
10/20/2025 - 10/21/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
12/04/2025 - 12/05/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →