MS Access (Introduction to Intermediate)

Overview

This two-day course provides participants with the knowledge and practical skills to design and manage a basic database in Microsoft Access.

Delegates will learn to create tables, forms, queries, and reports, as well as establish relationships between tables and integrate data from Excel. By the end of the course, participants will be able to structure, organise, and present data effectively for internal use.

Course Details

Objectives

By the end of this course, participants will be able to:

Understand database concepts and terminology
Create and design tables with appropriate data types and formats
Set input masks, validation rules, default values, and field properties
Create, customise, and manage forms for user-friendly data entry
Build queries to filter, sort, and calculate data
Import and export data between Access and Excel or other formats
Establish relationships between tables using primary and foreign keys
Create and format reports to present and print data professionally

Delivery Methods

This course is facilitated by a competent and experienced subject matter trainer using practical, hands-on learning methods including questions, discussions, exercises and assessments

Who should attend?

This course is ideal for individuals responsible for creating and maintaining internal database systems, including:

Administrative Staffs
Data Capturers
Office Administrators
HR Administrators
Project Coordinators
Operations and Logistics Staff
Small Business Owners

Includes

Comprehensive Manual
Lunch and Refreshments (not applicable to on-site / online training)
Electronic Certificate (on successful completion of the course)
Electronic Delegate Feedback Questionnaire

Ready to Build a More Skilled Team?

Give your staff the practical training they need to work with more confidence, capability, and professionalism. Explore PST Training’s courses, workshops, and seminars today.