Advanced Microsoft Access

Course Objectives
The skills and knowledge covered in this course are sufficient to automate operations using macros, secure and protect data, create intricate queries, and have a general understanding of the programming environment in Microsoft Access 2010/13
Course Duration
14 Hours (Part-time or Full-time available)
Who should attend
This course is primarily designed for people who need to know how to automate operations, protect and secure data, and perform complex queries in Microsoft Access 2010/13. It is ideal for people who working in offices, clubs, or for home use.
This course assumes that you can create a database file, store and manage data. it would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.
A hands-on approach is taken during this course. The exercises are designed to impart relevant skills and knowledge by having participants work through real-life examples and scenarios.
Course Modules
Unit 1 Splitting A Database
Unit 2 Action Queries
Unit 3 Aggregate Queries
Unit 4 Table & Query Relationships
Unit 5 Database Replication
Unit 6 Data Access Pages
Unit 7 Data Access Page Techniques
Unit 8 Database Protection
Unit 9 Database Security
Unit 10 Macro Basics
Unit 11 Macro Techniques
Unit 12 Macros On Forms
Unit 13 Option Groups And Macros
Unit 14 VBA Introduction

For further enquiries, please call us at +6 (06) 8500888.

Register NOW!

Registration can be made by filling and submitting the online form below or email us at

Payment shall be made payable to LCCM ASIA SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration

PART A: For ALL Types of Course Registration:

Your Choice of Program (required)

I / We would like to register for the above choice of program for:
Public CourseIn-house CourseOne-to-one Intensive Program

Your Name (required)

Your Company/Organization


Tel. No. (required)

Email (required)

PART B: For Corporate Registration ONLY:
Please fill in Approving Manager details for attendee(s) below.

Authorised By

No. of Delegates you want to register?

*Note: Payment can be made before or on the commencement date.

Terms & Conditions

Registration & Fees Policy:
Registration is confirmed once registration form is received via online form/email/mail. Letter of Approval (For Corporate Registration ONLY) must be made available and presented prior to the course.

Cancellation Policy:
Any cancellation must be received in writing within 5 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.

Share This
WhatsApp WhatsApp LCCM