Microsoft Access 2019 Basic to Intermediate

---

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)