Introduction

A database is a set of related data that are 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.

Duration

4 days (26 hours)

Target Participant

• Division II (ES2)
• Division III (ES3)

Language

English / Malay