Microsoft Access 2019 Advanced

---

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)