Centriq Training Print Logo

Thursday

September 29 06:44 AM

MO-A1

Microsoft Office Access: Level 1 Training Class:

  • Ways to Train:
  • Live Classroom
    Class is delivered at a Centriq location with a live instructor actually in the classroom.
  • Live Virtual Class
    Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
  • HD Class
    Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
  • Ways to Buy:
  • Retail
    Class can be purchased directly via check, credit card, or PO.
  • CV Centriq Vouchers
    Class is available for students using Centriq Vouchers.
  • CP Centriq Choice Pass Eligible
    Class is available to students utilizing Centriq Choice Pass program.
Start Date End Date Duration Days Start Time End Time Time Zone Location Ways to Train Ways to Buy Price
Request a Date
This course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Access 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.


Audience

This course is intended for students who will be working with existing databases rather than building them from scratch. It is best suited to database end users rather than database designers/managers.  This course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports. The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before.


View the Microsoft Office Access: Level 1 Training Course Outline

Lesson 1: Getting Started with Access 2019

  • 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

Lesson 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

Lesson 3: Creating Queries

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

Lesson 4: Creating Forms

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

Lesson 5: Creating Reports

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout
Enroll Now!