LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Fundamentals of MS Access is a practical training program designed to help participants build, manage, and use databases using Microsoft Access. The course covers the essential concepts of database design, table creation, data entry, relationships, queries, forms, reports, and selected advanced features. Participants will learn how to organize data properly, retrieve information through queries, create user-friendly forms, generate reports, and apply basic automation concepts for more interactive database systems.

Main Objectives
By the end of the training, participants should be able to:

1. Understand the basic concepts of databases and the role of MS Access in managing structured information.
2. Create tables using appropriate fields, data types, keys, and field properties.
3. Establish relationships between tables and apply data integrity principles.
4. Build queries to filter, calculate, summarize, and combine information.
5. Create and modify forms and reports for easier data entry and presentation.
6. Import, export, and link data from external sources.
7. Apply selected basic VBA concepts to improve database interactivity.

Who This Training Is For
This training is ideal for employees, staff, analysts, coordinators, administrators, and database users who need to organize, manage, and retrieve structured records using MS Access. It is suitable for beginners who are new to database systems, as well as existing Access users who want to strengthen their foundation and explore more advanced features such as forms, reports, linked tables, and basic VBA-assisted database functions.

Methodologies
1. Guided Demonstration and Hands-On Practice
The trainer demonstrates each Access feature step by step, followed by participant practice using sample database files. This allows learners to immediately apply concepts such as creating tables, setting field properties, building relationships, designing queries, and creating forms and reports.
2. Case-Based Database Building Activity
Participants work on a practical database scenario where they design tables, connect related records, build queries, and create output forms and reports. This helps learners understand how MS Access can be used in real workplace recordkeeping, monitoring, and reporting tasks.
​
​Outline

Understanding Databases

• Access Components Overview
• Creating Databases
• Using Keys
• Entering Data Properly
• Data Types

Creating Tables

• Design View and Data Types
• Field Properties
• Creating Relationships
• Understanding Data Integrity
• Creating Lookup Fields

Creating Access Objects: Queries, Forms, and Reports

• Basic Queries
• Filtering with Criteria
• Expressions, Totals, and Concatenating
• Creating Calculated Fields
• Creating Forms and Reports
• Converting Queries to Forms
• Modifying Forms and Reports
• Customizing Report Controls

More Database Features (ADVANCED)

• Importing and Exporting Data
• Linking Data to an Access Table
• Essential VBA Codes for Interactive Databases
•  Passing of Data from One Form to Another
•  Searching Databases​

Related Courses

Advanced MS Excel

MS PowerBI for Beginners

Macros and VBA Programming