Microsoft Access For Database Management – Basic to Advanced

"Master Microsoft Access: Unleash Advanced Capabilities with Expert Training!"

Join Classroom Training Within 1 Day

From Your Home (Zoom Application)

DATE: 20 April 2025 (Sunday)

Duration

1 Day

Time

Seats Availability

in classroom

Individual Fee

RM 190

HRDCorp: RM400

PREREQUISITES

Basic proficiency in Microsoft Office (Excel knowledge is an added advantage).
No prior experience with Microsoft Access is required.
A desire to improve organizational data processes and reporting efficiency.

Language

50% English & 50% Bahasa Melayu

Certification

Certificate of Participation by Training Provider

Training Overview

In the era of data-driven decision-making, Microsoft Access stands as a powerful and user-friendly tool for managing complex databases with ease. This 1-day intensive training is designed to equip professionals with the complete skill set required to build, manage, and maintain robust databases from scratch. Covering all levels from Basic to Advanced, participants will gain hands-on experience creating tables, managing relationships, generating insightful reports, and securing databases — all within a single, dynamic day of learning.

Whether you’re handling small-scale projects or enterprise-level datasets, this course empowers you to structure your information effectively, automate tasks, and extract meaningful insights. By the end of the session, you will have the confidence and technical know-how to develop reliable databases that streamline operations and support smarter business decisions.

Course Objectives

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

Understand fundamental relational database concepts and best practices.
Build a complete Microsoft Access database from the ground up.
Design and customize tables with appropriate data types and field properties.
Establish relationships between tables and maintain referential integrity.
Create advanced queries to filter, analyze, and manipulate data effectively.

Develop user-friendly forms for simplified data entry and management.
Generate professional reports with grouping, sorting, and calculated totals.
Apply security features to protect sensitive data within the database.
Perform essential maintenance tasks to optimize database performance.
Implement database documentation and backup strategies for long-term usability.

Course Tentative

TIME	MODULES
8:30 AM – 9:00 AM	REGISTRATION
9:00 AM – 9:30 AM	Module 1: Introduction and Fundamental
9:30 AM – 10:00 AM	Module 2: Creating Tables
10:00 AM – 11:00 AM	Module 3: Setting Field Properties
11:00 AM – 12:00 PM	Module 4: Organizing Records
12:00 PM – 1:00 PM	Module 5: Using Queries
1:00 PM – 2:00 PM	LUNCH HOUR
2:00 PM – 3:00 PM	Module 6: Creating Forms
3:00 PM – 4:00 PM	Module 7: Creating Reports
4:00 PM – 5:00 PM	Module 8: Maintaining the Database

Note: The course duration is a guideline. Course topics and duration may be modified by the instructor based on the knowledge and skill level of the course participant.

Who Should Attend?

This course is ideal for

View Course Outline

1.1. Building Access Databases
1.2. Relational Database Concepts
1.3. Create the Database File
1.4. All about the Trust Center
1.5. Digging into Ribbon Tabs
1.6. The Database Navigation Pane
1.7. Customize the Quick Access Toolbar
1.8. Create a Database Backup

2.1. Table Structures and Relationships
2.2. Create a Table and Set Data Types
2.3. Enter Data
2.4. Primary and Foreign Keys
2.5. Working with Access Table Relationships
2.6. Importing Tables

3.1. Relationships and Referential Integrity
3.2. Editing Table Structure in Design View
3.3. Control Input with Masks
3.4. Set a Default Value
3.5. Data Validation Rules
3.6. Data Lookup Fields
3.7. Additional Field Properties

4.1. Sorting Table Data
4.2. Filtering Table Rows
4.3. Deleting Records

5.1. What are Queries
5.2. The Simple Query Wizard
5.3. Build Queries in Design View
5.4. Establishing Constraints with Criteria
5.5. Specifying Criteria with Wildcards
5.6. Incorporating AND and OR Statements
5.7. Filtering with Mathematical Comparisons
5.8. Create Flexible Queries with Parameters
5.9. Build Expressions
5.10. Obtain Summary Statistics

6.1. Understand the Role of Forms
6.2. Generate Forms from Tables
6.3. Adjusting Form Elements in Layout View
6.4. Using The Form Wizard
6.5. Form Design View
6.6. Find Records

7.1. Introducing Reports
7.2. The Report Wizard
7.3. Edit a Report in Design View
7.4. Edit a Report in Layout View
7.5. Group and Sort Reports
7.6. Creating Calculated Totals
7.7. Apply Conditional Formatting Rules
7.8. Adjust Print Settings

8.1. Customize Groups in the Navigation Pane
8.2. Compact and Repair the Database
8.3. Examine Database Object Relationships
8.4. Document Your Thought Process
8.5. Print The Blueprint of Your Database
8.6. Split A Database into Front and Back Ends
8.7. Protect The Database with a Password
8.8. Set Startup Options

Training Packages

Course Handbook

Exercise Files

Tutorial Videos

Lifetime Group Support

How to Register

Step 1

Step 2

Step 3

Step 4

Register Now

Click on the "Register Now" button on the course page.

Complete Registration Form

Fill out the registration form with your personal details, choose training date and preferred payment method.

Make Payment

Make the payment to secure your spot. Once your payment is confirmed, you'll receive a confirmation email.

Contact Us

Reach out to our registration team via WhatsApp to get link access to WhatsApp group.

*** Note: Course content and schedule are subject to minor adjustments based on the needs and skill levels of participants.