ELEV-TG 004: Microsoft Office Specialist (MOS) – Access Essentials

About Course

ELEV-TG 004: Microsoft Office Specialist (MOS) – Access Essentials

Course Number: ELEV-TG 004

Duration: One day

Course Description:

Microsoft Access is a powerful database application, and understanding its environment and fundamental principles is essential for effective data management. The Microsoft Office Specialist (MOS) – Access Essentials course provides learners with a strong foundation in database concepts and the core functionality of Microsoft Access.

Participants will learn how to create and manage databases, build and modify tables, establish relationships, design queries, and produce professional forms and reports. This course is ideal for individuals who want to confidently manage data, improve accuracy, and support informed decision-making using Microsoft Access.

Course Modules:

Module One: Create and Manage a Database

Create and modify databases
Establish and manage relationships, keys, and referential integrity
Navigate efficiently within a database
Protect, maintain, and back up databases
Print and export data in multiple formats

Module Two: Build Tables

Create tables and import data
Manage table structures, including fields, descriptions, and table names
Add, edit, delete, filter, and manage records
Configure fields with validation rules, default values, and input masks

Module Three: Create Queries

Create crosstab, parameter, action, and multi-table queries
Modify queries by adding or removing fields and sorting data
Create calculated fields and group data within queries

Module Four: Create Forms

Create forms and configure form controls
Format forms, including tab order, print settings, themes, and backgrounds
Insert headers, footers, and additional form elements

Module Five: Create Reports

Create reports based on tables or queries
Configure report controls, group and sort fields, and modify data sources
Format reports, including columns, calculated fields, layout, orientation, and headers and footers

Build a strong foundation in database management with the Microsoft Office Specialist (MOS) – Access Essentials course. Join now and gain the skills needed to confidently create, manage, and analyze data using Microsoft Access.