phone call us Inspizone+65 8586 4485
Email us Inspizone[email protected]
Send Enquiry
Chat with us InspizoneChat With Us
Access Course Singapore

Learn Microsoft Access Course in Singapore

microsoft access training singapore
microsoft access course singapore
microsoft access courses singapore

Access Course Singapore: Learn and master the concepts of Databases, creating, modifying and managing Tables, Queries, Forms and Reports using microsoft access.





Get Training Details








Course Start Date


  • 07/10/2020 | 09:30-17:30
    Week Days
  • Schedule


    Days: 3 Days
    Duration: 21 Hours
    Timings: 9:00 AM - 5:00 PM

    10 Anson Road, 26-08A International Plaza, Singapore 079903

    Register Now

    Why Choose Us


    • Expert Local Trainers
    • Hands-on Training by experts
    • Certificate of Achievement
    • Free Refresh Class within 6 Month

    Who Should Attend This Microsoft Access Training Course Singapore


    Access training Singapore is ideal for beginners, assuming little or no knowledge of the software.

    Microsoft Access Course in Singapore


    About Course: This Microsoft Access training course will give you a clear picture of Microsoft Access with hands-on experience to create and modify new databases and their various objects. You will learn about how to do data with consistency and integrity.

    What will you learn- 

    • Learn how to improve queries, create forms, export reports 
    • Learn how to create a database
    • Learn how to manipulate data to provide viable information
    • Learn how to  store databases as well as the integration of Microsoft Access with other applications. 

    This Microsoft Access Training Course is designed for beginners, assuming little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

    Target Student: All working professionals who want to create and manage database and learn to manage their own data

    Target Student: All working professionals who want to create and manage database and learn to manage their own data.

    microsoft access training course singapore

    MS Access Training Outline


    Introduction To Access

    • Getting familiarize with Access
    • Planning, Designing, Handling Database
    • Play with Database
    • Creating Database and Updating using templates

    Using Pivot Table In Access (And Via Excel)

    • Creating Pivot Tables Within Access
    • Using Access Pivot Tables

    Using The Navigation Pane

    • Tables and Related Views
    • Navigation Pane Objects
    • Custom Groups

    Introducing Access Macros And VBA

    • Just what is a Macro?
    • Macro Review
    • Creating and Editing Macros
    • Enhancing Macros with TempVars
    • Adding Conditions to Macros
    • Introducing Access VBA
    • Adding Conditions to Macros
    • Introducing Access VBA

    Validating And Standardising Table Data

    • Setting Default Values
    • Defining Field Validation
    • Requiring a Field to be Completed
    • Adding Date Picker to Date Fields
    • Using Rich Text Formatting (Memo Fields)
    • Table Validation Rules

    Advanced Form Design

    • GUI Design
    • Designing a Standardised User Interface Model
    • Working with Form Filters
    • Validating Form Data
    • Cascading Combo Boxes

    Setting Table Relationships

    • Locating Orphan Records
    • Cascading Updates and Deletes
    • Join Types

    Designing With Layout View

    • A Quick Look at Layout View
    • Creating a Form Using the Quick Form Tool

    Introducing Access SQL

    • Commonly used SQL Keywords

    Advanced Reports

    • No Data Event
    • Show/Hide Report Sections based on User Selections
    • Add Running Sums to Report Sections
    • Add a Watermark to a Report

    Advanced Select Queries

    • Using Left
    • Using Mid
    • Using the LEN Function
    • Using IIF Functions
    • Using LCASE Functions
    • Using TRIM Functions

    Reporting Systems

    • Reviewing Methods to Run Reports
    • A Fully Featured Reporting Module

    Aggregate Queries

    • Grouping Data
    • Adding Criteria to Aggregate Queries

    Preparing The Database For User Access

    • Restricting User Access to Design Elements
    • Converting to ACCDE Format

    Cross Tab Queries

    • Creating CrossTab Queries
    • Modifying a CrossTab

    google logo Reviews of our students


    hua zeng
    hua zeng
    a year ago

    I am taking excel and LCCI course , so far i think the fee is resonable and worth the money, I like the teachers , they are professional and patient.
    Sarah Lah
    Sarah Lah
    4 months ago

    Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.
    ruo liong
    ruo liong
    2 years ago

    I attended the Accounting lesson . The trainer was very experienced and was bi lingual so it was easy for me to ask question.
    Arun Dixit
    Arun Dixit
    11 months ago

    I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.
    Jenna Loh
    Jacqueline Lee
    7 months ago

    Went for a accounting course, Steven was friendly and helpful
    Joanna
    Joanna
    10 months ago

    Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.
    Guido Sudero
    Guido Sudero
    11 months ago

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Avira Dixit
    Avira Dixit
    a year ago

    I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!
    Leanie Lee
    Leanie Lee
    a year ago

    I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.
    Wenyan Yeo (W)
    Wenyan Yeo (W)
    7 months ago

    Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.
    Lucia
    Lucia
    a year ago

    I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.
    Katherine Ang
    Katherine Ang
    a year ago

    I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!
    Patricia Tong
    Patricia Tong
    5 years ago

    Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.
    alex koh ming
    alex koh ming
    3 years ago

    BEST EXCEL TRAINING
    Jacqueline Lee
    Jacqueline Lee
    2021-09-22

    Went for a accounting course, Steven was friendly and helpful
    Wenyan Yeo
    Guido Sudero
    2021-09-01

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Chiqui Ehong
    Grace CH Ong
    2021-06-11

    A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂
    Lim Valintina
    L T.
    a year ago

    Environment: neat and organized Pace of the class: perfect Learning tools: clear and straightforward Trainer (Bee Hoon): efficient, proactive, knowledgeable and humorous Overall: Excellent. Class ended earlier than stipulated time (despite time spent waiting for latecomers to get seated).
    Annie Ong
    Annie Ong
    5 months ago

    Dr Suresh is a excellent lecturer, he teaches the students incorporate with his own experience in accounting. This make us "students" who has no background of accounting understand and grasp the lesson with ease. The staff at Inspizone is so attentive and reply to our query without much delay. They are professional in handling us different students with different needs during our course. Recommended Training Institute to take lesson and learn what you need!
    Lucia
    Lucia
    a year ago

    I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.
    J Quek
    J Quek
    2 years ago

    I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.
    Celest Tan
    Celest Tan
    a year ago

    I took the Videography and Editing class under trainer Adrian. He is a practitioner with many years of experience. Certainly an eye opener as i had many videos and photos but did not know how to put them together into a footage with a story. After attending this, i am able to do it. Highly recommended.
    ruo liong
    ruo liong
    2 years ago

    I attended the Accounting lesson . The trainer was very experienced and was bi lingual so it was easy for me to ask question.
    ruo liong
    Ringo Lee
    a year ago

    Helpful staff and experienced trainer!
    ruo liong
    Jie Zhang
    2 months ago

    comprehensive content. useful for daily work. patient trainer. it will be better if touch more advanced functions.

    Frequently Asked Questions (FAQs)


    What is MYOB/ABSS?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    What is my salary potential as an Accountant specialist after completion of this MYOB certification course?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Why do organizations hire Accountant professionals?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Is this MYOB training course up to date?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Which course will be available for live instructor-led online classes?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    How do I enroll in this MYOB Certification course?

    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

    Trending Courses


    Get Training Details