2 Days


Public Class

Public Class

Unleash the Power of Microsoft Access - Advance Course

Are you ready to master the world of data management? Look no further than our ‘Microsoft Access – Advance’ course. In this two-day journey, we dive deep into the realm of Microsoft Access, empowering you to harness its full potential.

Elevate Your Access Skills

Whether you’re a seasoned pro or just starting your Access adventure, our program caters to all skill levels. From customizing menus and toolbars to creating advanced macros, you’ll be amazed at how versatile Microsoft Access can be. Dive into the world of switchboards and data access pages, and explore the magic of crosstab queries, parameter queries, and advanced reporting features. By the end of the course, you’ll be a PivotTable and PivotChart pro, able to effortlessly transform your data into meaningful insights.

Take Control of Your Data

In an era where data is king, mastering Microsoft Access is your key to unlocking new possibilities. Our hands-on, interactive approach ensures that you not only learn the ropes but also become a confident navigator in the world of databases. So, whether you’re a clerk, supervisor, or manager, this course is your ticket to data mastery. Join us for two days, and emerge with the expertise to streamline your data, enhance your decision-making, and propel your career forward.

Course Details

Course: ACA-2; Duration: 2 Days; Instructor-led


This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know, understand, and want to further enhance their knowledge and practical uses of Microsoft Access


  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to compact a Database
  • Able to repair a Database
  • Able to link to an Excel Spreadsheet
  • Able to use Input Masks to control Table data entry
  • Able to create a Query
  • Able to create a Multiple Table Query


This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Maintain Referential Integrity
  • Create Table Relationships
  • Creating a Switchboard
  • Understanding Crosstab Queries
  • Using Parameter Queries
  • Creating a PivotTable


Lesson 1.1: Customizing Menus and Toolbars

  • Customizing Menus
  • Creating Menus
  • Showing and Hiding Toolbars
  • Customizing Toolbars
  • Creating Toolbars

Lesson 1.2: Setting Access Options, Part 1

  • Setting General and View Options
  • Setting Editing and Keyboard Options
  • Setting Datasheet, Form and Report Options
  • Setting Page and Tables / Queries Options
  • Setting Error Checking Options
  • Setting Advanced Options

Lesson 1.3: Setting Access Options, Part 2

  • Setting International Options
  • Setting Spelling Options
  • Setting Autocorrect Options
  • Setting Start-Up Options
  • Setting Macro Security Options

Lesson 1.4: Creating Macros

  • Using the Macro Design Toolbar
  • Creating a Macro
  • Running a Macro
  • About Macro Groups

Lesson 1.5: Advanced Macro Uses  

  • Editing a Macro with the Visual Basic Editor
  • Assigning a Macro to a Keystroke
  • Assigning a Macro to a Toolbar
  • Viewing and Printing Macro Definitions

Lesson 2.1: Switchboards    

  • Using A Switchboard
  • Using the Switchboard Manager
  • Creating a Switchboard
  • Editing a Switchboard
  • Deleting a Switchboard

Lesson 2.2: Creating Data Access Pages

  • Using the Data Access Page Wizard
  • Using Design View to create a Data Access Page
  • Using an existing Html Page

Lesson 2.3: Modifying Data Access Pages

  • Adding a Theme
  • Adding Text and Controls
  • Formatting Text and Controls
  • Aligning and Sizing Content
  • Adding Images

Lesson 2.4: Using Data Access Pages         

  • Basics of Using Data Access Pages
  • Viewing Data Entered via a Data Access Page
  • Protecting Data

Lesson 3.1: Table Relationships      

  • Normalizing your Data
  • Establishing Referential Integrity
  • Using Cascade Update and Cascade Delete
  • Setting Fields for Indexing
  • Using Indexing

 Lesson 3.2: Using Crosstab Queries

  • Understanding Crosstab Queries
  • Creating a Crosstab Query using the Wizard
  • Creating a Crosstab Query manually

Lesson 3.3: Using Parameter Queries

  • Setting up Parameter Queries
  • Using a Parameter Query

Lesson 3.4: Advanced Reporting Features 

  • Using Autoformat
  • Aligning and Formatting Controls
  • Adding Pictures and Lines

Lesson 4.1: Creating A Pivottable   

  • Creating a Pivottable using the Wizard
  • Continuing where The Wizard left off
  • More about Fields
  • Completing your Pivottab

Lesson 4.2: Using Autoform And Creating Pivotcharts

  • Creating a Pivottable using Autoform
  • Creating a Pivotchart using Autoform
  • About Pivotchart Fields
  • Completing a Pivotchart

Lesson 4.3: Using Pivottable And Pivotcharts

  • Using A Pivottable
  • Using A Pivotchart
  • Editing A Pivottable or Pivotchart
  • Common Pivotchart Editing Features

Turning a Pivottable into a Pivotchart and vice-versa



Interested In


Starting From
Intake Date
25-26 MAR 2024
26-27 JUNE 2024
25-26 SEPT 2024
18-19 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *