More results...

Generic filters
Filter by Brands/Technologies

Access – Part 1

Instructor‑Led: $590 | Duration: 2 Days

Upgrade your tech skills with this , training course from TechSherpas 365!

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
$590
6/1/2026 6/2/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$590
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 : $590
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 : $590

Course Highlights

LEVEL: 
  • Beginner
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

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. 

No results found.

Explore Related Training Courses

Related products

  • End User Application

    Visio – Part 2
    Microsoft Apps
    Intermediate
    Microsoft? Visio? stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures?anything that can be represented by shapes…
    1 Day(s)
    $395
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 1
    Microsoft Apps
    Beginner
    In this course, you’ll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements and layout options;…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 2
    Microsoft Apps
    Intermediate
    Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 3
    Microsoft Apps
    Advanced
    Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)

What Our Students Are Saying

IT Certification Training Course Reviews