Introduction

This course is designed for users who have a basic understanding of Microsoft Access and wish to deepen their knowledge and skills in database management. This course delves into more advanced features and functionalities, including complex query creation, advanced form design , and sophisticated report generation. Participants will learn how to efficiently manage and analyse large datasets, implement relational database principles, and automate tasks with macros. Through hands-on exercises and real-world scenarios, participants will gain the expertise needed to build robust databases, streamline data processes, and enhance data-driven decision-making capabilities in their professional environments.

Learning Outcome

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

• Create and optimise complex queries using advanced techniques such as multiple criteria, joins, subqueries, and aggregate functions to extract and analyse data more effectively.
• Design and customise advanced forms and reports, incorporating features like subforms, conditional formatting, and calculated controls to enhance data entry and reporting capabilities.
• Implement and manage complex relational database structures, including defining and enforcing relationships between tables, and applying normalisation principles to ensure data integrity and reduce redundancy.
• Develop and utilise macros to automate repetitive tasks, streamline workflows, and create user-friendly interfaces that improve productivity and consistency in database operations.
• Employ advanced data management techniques, including importing and exporting data, managing database security settings, and performing backup and recovery operations to ensure data protection and reliability.

Duration

3 Days (19.5 Hours)

Target Participant

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

Language

English / Malay

Pre-Requisite

Basic knowledge of Microsoft Access