More results...

Generic filters
Filter by Brands/Technologies

Access – Part 1 training course

Instructor‑Led: $560 | Duration: 2 Days

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.

Reserve your seat in an upcoming class date or select a Learning Method below:

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
4/2/2026 4/3/2026
11:00AM - 7:00PM
star GTR

Guaranteed-to-Run
$560.00
6/1/2026 6/2/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$560.00
START DATE : 4/2/2026
END DATE : 4/3/2026
CLASS TIMES (EST) : 11:00AM - 7:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $560.00
START DATE : 6/1/2026
END DATE : 6/2/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $560.00

Course Highlights

LEVEL: 
  • Beginner

Access – Part 1 Course Outline

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.

PREREQUISITES
  • 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

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Technical Communicator

Requirements Analyst

Narrative Writer

Medical Writer

Information Developer

Engineering Writer

Related products

  • Windows Server

    50255 Managing Windows Environments With Group Policy
    In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Web Apps

    55337 Introduction To Programming
    In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Windows Server

    55341 Installation, Storage, And Compute With Windows Server
    This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Windows 11

    55342 Supporting And Troubleshooting Windows 11
    This is a 4-day ILT course that is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises…Read more.
    4 days
    $595.00 - $2,375.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Windows Server

    55344 Identity With Windows Server
    This five-day instructor-led course teaches IT professionals how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • SQL Server
    Data & Analytics

    55353 Administering A SQL Database Infrastructure
    This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)