Oaks Training

Course Code: VTLOKAAX6
SkillsFuture ID: CRS-N-0042888
Duration: 3 Days (21 Hours)

$481.50
Inclusive of GST

Download Brochure
Download Registration Form

You can also register by
1. FAX: Click here to download registration form.
2. HRMS-2 / ACE SYSTEM: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training.
3. PHONE: Call +65 6423 1183.

Modes of Training Delivery
Virtual: Live Streaming, Face to Face
In-Class

COURSE BRIEF

Harness the Power of Advanced Features of Access 2016

A 3-day hands-on follow on course designed to equip user with the ability to construct different types of actions queries and its SQL. Adding controls and events on the form design to enable data retrieval and handling records from the tables. Design and customise report to produce result and layout of your preference.

Learn how to automate your tasks in Access with macros coding and connecting macros to your forms and tables. Jump into screens and panels quickly with Access’ navigation features to save time. Receive valuable insights and tips to data handling and get the most out from Access.

This course is designed with appropriate hands-on exercises to allow you to practice key lessons taught to help you understand and become familiar with the components and features in Access.

Who is this course for?

Learners who have attended our Microsoft Acess 2016 Basic to Intermediate course or for users with good working knowledge and experience in using earlier versions of Microsoft Access.

Public Sector - Div. 1, 2 & 3
Private Sector - Applicable to All

Course Outline for MS Access 2016 Advanced

Summarise Data
Action Queries

Make-Table
Append
Delete
Update
Crosstab

Form Design

Create a Standard Form
Layout and Design View
Form Control and Properties

Report Design

Add Fields and Controls
Report Header and Footer
Group Header and Footer
Page Break
Serial Number in Report

Macro

If…then…Else Macro Block
Adding Comments
Submacros
Group Macro
Built-in Functions
Standalone Macro
Embed Macro to Form Control
Create Named Macro in Table
Before and After Events Macro

Navigation System

Build Forms with Navigation
Create Navigation Forms
Designating a Startup Form

Questions to Ask Yourself

I’m very experienced in using an earlier version of Microsoft Access; can I sign up for this course without attending the Access 2016 Basic to Intermediate course?

Yes, you can but ONLY IF you are very familiar with the Access topics covered in our Access Basic to Intermediate module.

OUR TRAINER / TESTIMONIALS

Our Friendly Trainers

Qualified and Experienced to facilitate this course

More than 20 years of training experience
Native speaking Trainers
ACTA Certified
Microsoft Certified
ITE Certified

Testimonials

"Daphne has been very helpful and thoughtful. She helped us whenever we needed and gives us a lot of exercises to try on."

- Sazzuria Hashim (PSD)

QUESTIONS?

Request for a Course Date

If none of our published course date is suitable for you or your staff, contact us at 6423-1183 and let us know when you need this course to be conducted and if it is possible we will do our best to make it happen!

Request to Customise this Course

If you require this course to be customised to better suit the training needs of your staff or to have this course conducted on a date not stated in our training calendar, contact us (Call us at 6423-1183) for a no obligation discussion. We would be most happy to assist and hear from you.

Request for this Course to be Conducted at Your Premise

It is definitely possible as long as it is conduction in Singapore. Call us at 6423-1130 and speak to any of your representatives and we would be work out an arrangement for you.

Request for an Evening Class

Can't attend this course during office hours, contact us at 6423-1183 for possible evening or Saturday class arrangements.

Course Code: VTLOKAAX6
SkillsFuture ID: CRS-N-0042888
Duration: 3 Days (21 Hours)

$481.50
Inclusive of GST

Download Brochure
Download Registration Form

Modes of Training Delivery
Virtual: Live Streaming, Face to Face
In-Class

Harness the Power of Advanced Features of Access 2016

This course is designed with appropriate hands-on exercises to allow you to practice key lessons taught to help you understand and become familiar with the components and features in Access.

Who is this course for?

Learners who have attended our Microsoft Acess 2016 Basic to Intermediate course or for users with good working knowledge and experience in using earlier versions of Microsoft Access.

Public Sector - Div. 1, 2 & 3
Private Sector - Applicable to All

Course Outline for MS Access 2016 Advanced

Summarise Data
Action Queries

Make-Table
Append
Delete
Update
Crosstab

Form Design

Create a Standard Form
Layout and Design View
Form Control and Properties

Report Design

Add Fields and Controls
Report Header and Footer
Group Header and Footer
Page Break
Serial Number in Report

Macro

If…then…Else Macro Block
Adding Comments
Submacros
Group Macro
Built-in Functions
Standalone Macro
Embed Macro to Form Control
Create Named Macro in Table
Before and After Events Macro

Navigation System

Build Forms with Navigation
Create Navigation Forms
Designating a Startup Form

Questions to Ask Yourself

I’m very experienced in using an earlier version of Microsoft Access; can I sign up for this course without attending the Access 2016 Basic to Intermediate course?

Yes, you can but ONLY IF you are very familiar with the Access topics covered in our Access Basic to Intermediate module.

Our Friendly Trainers

Qualified and Experienced to facilitate this course

More than 20 years of training experience
Native speaking Trainers
ACTA Certified
Microsoft Certified
ITE Certified

Request for a Course Date

If none of our published course date is suitable for you or your staff, contact us at 6423-1130 and let us know when you need this course to be conducted and if it is possible we will do our best to make it happen!

Request to Customise this Course

Request for this Course to be Conducted at Your Premise

It is definitely possible as long as it is conduction in Singapore. Call us at 6423-1183 and speak to any of your representatives and we would be work out an arrangement for you.

Request for an Evening Class

Can't attend this course during office hours, contact us at 6423-1130 for possible evening or Saturday class arrangements.

Testimonials

"Daphne has been very helpful and thoughtful. She helped us whenever we needed and gives us a lot of exercises to try on."

- Sazzuria Hashim (PSD)