Introduction

A database is a set of related data that is stored for easy and quick retrieval. Data stored in a database transforms into structured and meaningful information to fit users’ needs. A database is also portable, which means that the data can be easily transferred from one computer to another. Using a database makes it easier to share information and provide access to data according to specific requirements and needs at any time. Microsoft (MS) Access is a well-known database management system that enables users to manage data and analyse massive amounts of information efficiently. MS Access provides a combination of database functionality and programming capabilities for creating easy-to-navigate forms.

In addition, MS Access is simple to install and easy to understand with the help of its graphical user interface (GUI). It lets users create tables, forms, queries, and reports and connect with the aid of Macros.

Learning Outcome

At the end of the program, participants will be able to:

• understand the concept of database.
• apply basic knowledge of using functions in Microsoft Access.
• structure data and information using tables.
• make a simple query and create a form.
• generate a simple report.

Key Topics

Key topics include:

• Introduction to Microsoft Access
• Creating and Managing Databases
• Building and Designing Tables
• Entering and Editing Data
• Introduction to Queries
• Designing and Using Forms
• Generating and Customising Reports
• Basic Data Analysis and Calculations
• Importing and Exporting Data
• Basic Database Maintenance and Backup

Duration

2 Days | 26 hours

Target Participant

• Executive Services 2 (ES 2) – Bahagian II: B3 | B2
• Executive Services 3 (ES 3) – Bahagian III: C3 | C2 | C1

Pre-Requisite

N/A

Language

Bahasa Melayu / English

Methodology

The course will be delivered using:

• Instructor-Led Training
• Hands-On Laboratory
• Demonstration
• Case-Study

Assessment Methods

Pre-Test & Post-Test

Program Evaluation