WhatsApp UsSkype Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Access 2019 Advanced

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
 
OKAAX9
Duration
 
21 Hours (3 Days)
Course Fee
 
$481.50 inclusive of GST
Funding
 
SDF / SkillsFuture ID: CRS-N-0050139
UTAP for NTUC Members
This Course is For
 
Anyone who wants to learn how to use Access 2019 for creating custom action queries and customised reports in Access.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Prerequisites

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

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.


Do more with Advanced Features of Access 2019

This 3-day hands-on course is 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.


Course Outline

  • 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

Our Friendly Trainer

Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

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

Special Request

Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.

Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.

Group discounts are also available. Request a quote from us.


Reviews

Jiayous!! She is super friendly and helpful and gave some extra tips on frequently asked questions other students did!!!
- Lee (SPF)


No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

Empowering the Enduser is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
WhatsApp: Click here
Skype: Click here
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here