Microsoft Access 2016 Advanced | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Microsoft Access 2016 Advanced


Format What’s this?
Starting From
RM 800.00
  1. 2 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available
  1. 2 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

Microsoft Access 2016 Advanced


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


Basic knowledge of Microsoft Access is essential with the following pre-requisites:

• Have attended Microsoft Access – Foundation and Intermediate Level; OR

• Able to switch between task applications

• Able to Mark Fields as Required in a Table

• Able to Use Input Masks to control table data entry

• Able to Add Tabs to a Navigation Form

• Able to Set a Tab Hierarchy

• Able to Create Parameter Queries

• Able to Create Action Queries

• Make Table, Append, Delete & Update Queries

• Able to Create a Report with the Wizard

• Able to Create a Report from ScratchAble to Understand Basic SQL Statements and Keywords

• Able to Create a Report with the Wizard

• Able to Create a Report from Scratch

• Able to Group and Sort Form Data

• Able to Insert Images, Logos, Headers and Footers


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


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

• Implementing Advanced form

• Advanced database management

• Distributing and securing database

• Managing Switchboards

Expand All


Module 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

• Types of Controls
• Command Buttons
• Calendar / Date picker Control
• Form Layouts
• Quick Styles
• Tab Order
• The Anchoring Tool

Topic B: Set Form Controls
• Move Form Controls
• Add Form Controls
• Remove Form Controls
• Modify Data Sources
• Set Form Control Properties
• Manage Labels

Topic C: Create Sub Forms
• Sub Forms

Topic D: Enhance Navigation with Forms
• Navigation Control and Navigation Forms
• Setting Navigation options
• Creating a Navigation Form
• Using a Navigation Form

Topic E: Format a Form
• Insert Headers and Footers
• Insert Images
• Auto-Order forms
• Sort Records
• Apply Themes
• Insert Backgrounds
• Change Margins

Topic F: Apply Conditional Formatting
• Conditional Formatting

Module 2: Using Advanced Database Management

Topic A: Link Tables to External Data Sources

• External Data Sources

• The Linked Table Manager

Topic B: Manage a Database

• Exclusive Mode

• Database Access Modes

• Database Backup

• The Compact and Repair Database Option

Module 3: Distributing and Sharing a Database

Topic A: Split a Database for Multiple User Access

• Splitting a Database

• Merging a Database

Topic B: Set Passwords

• Password Protection Guidelines

Topic C: Convert an Access Database

• The ACCDE file Format

• User Templates

• Saving Databases as Templates

Module 4: Managing Switchboards

Topic A: Create a Database Switchboard

• Switchboards

• Switchboard Manager

Topic B: Modify a Database Switchboard

• Switchboard Modification

Topic C: Set Startup Options

• Database Startup Options

Module 5: Sharing Data Across Applications

Topic A: Import Data into Access

• Data Importing

• The Get External Data wizard

• Delimiters

Topic B: Export Data To Text File Formats

• Data Exporting

Topic C: Export Access Data to Excel

• Exporting Access Data to Excel

Topic D: Create a Mail Merge

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Sylvia Sharon Anthony

Sylvia Sharon Anthony

She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Database and Graphic applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs.

Sylvia has acquired immense knowledge and skill in the training field. Since becoming a trainer, her work has involved design, delivery and developing training programmers. In her 16 years of experience in the training arena she has delivered and customized training programmers specifically to tailor for organization's unique training needs and to maximize the participant's learning outcomes.

As a trainer, Sylvia constantly strives to improve herself and learn new methods and skills. She is passionate about building new programs that meet the upcoming challenges of the IT industry. She is currently developing a customized Excel programme which will emphasize on the advanced features of Microsoft Excel i.e. Mastering Charts, Functions and Pivot Tables.

Read More

Kua Su-Ann

Kua Su-Ann

Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.

Read More

Course Reviews

No Remarks


0 Ratings