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

Microsoft Access 2019 Basic to Intermediate

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

Course Code
 
OKABX9
Duration
 
14 Hours (2 Days)
Course Fee
 
$406.60 inclusive of GST
Funding
 
SDF / SkillsFuture ID: CRS-N-0050131
UTAP for NTUC Members
This Course is For
 
Anyone with zero to little knowledge of using Microsoft Access 2019. Also suitable for those who what to refresh the MS Access skills from earlier versions.

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

None. This course is also suitable for leaners of Microsoft Office 2016.

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


Key Steps to Design a Database and Handle Data the Proper Way

If you have noticed how slow and ineffective it is to manage your bulky data in Excel, then it is time to build your database in Microsoft Access to improve your productivity and accuracy.

In this 2-days hand-on course, you will learn how to migrate your existing data and manage them in Microsoft Access 2019. This course is also designed for new and inexperienced users to appreciate the concept of database design through the process of normalisation. An essential approach which is a step that is often not taught to help you to build an effective and suitable database.

Some Key Pointers to Consider:

  • How to determine what fields are needed for the database/system?
  • How to determine how many tables are need?
  • How to determine which field goes into which table?

Failing to consider all these, your database would be inefficient and may not work properly. It would greatly hinder future enhancements to your database or even make it impossible for enhancements.

This course is designed with a workshop and many hands-on exercises to allow you to practice key lessons taught to help you create a proper working database.


Course Outline

  • Introduction to Database
  • Working Through Normalisation Concept
  • Working Through Table Design
  • Understanding Field Properties
  • Understanding Relationships
  • Working with Datasheet View
  • Importing/Exporting Data
  • Working with Prefix
  • Form Wizard
  • Report Wizard

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

Been taking courses yearly with Oaks training and I have attended a few courses trained by Ms Ow Yeong. She is very helpful and ensures that we are coping on fine and able to follow the steps. She makes sure we are on track before she continues so that we are not left hanging in the middle feeling lost.
- Saraswathy (SCDF)

The Trainer is indeed very patient whenever we make mistakes. Never showing any anger sort of reactions towards us. It shows that she understands her work, which is difficult to understand.
- Thirukkumara (MHA)

Her explanation was very clear and set a good sample for us to under stand easily.
- Chan Chee Meng (CPG Consultants Pte Ltd)


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