Microsoft Office IconMicrosoft Access 2007 Advanced Course

Data Empowerment and Security (3-Days)

Home / Courses / Microsoft Office

Microsoft Access Course Banner
Access 2007 Advanced Course Brief

A 3-day hands-on follow on course designed to equip user with the ability to construct advanced queries for more complex data retrieval and record handling. Add controls to reports for more targeted results and layouts to suit your needs.

You will learn how to import and export into Microsoft Excel or to be used in Microsoft Word. Include macros (predefined list of actions) in Microsoft Access to simplify tasks. Learn how to jump into screens and panels quickly with Access’ switchboard 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.

I am a very experienced user of an earlier version of Microsoft Access; can I attend this course without attending Basic to Intermediate course?

If you have not used Microsoft Access 2007, NO, we do not recommend that you skip this course. You are likely to find yourself lagging behind as you would be struggling to find or locate features in the 2007 version which is totally different from the earlier versions.

Overview of Microsoft Access Advanced 2007
  • Creating Summarized Queries
  • Creating Crosstab Queries
  • Creating Action Queries
  • Designing Forms
  • Designing Advanced Reports
  • Managing a Database
  • Working with a Switchboard
  • Managing Database Security
  • Working with Macros
Access 2007 Advanced Course Details
Skill Level For those who have attended our Microsoft Access 2007 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Access 2007.
Audience Public Sector - Division 1, 2 & 3
Private Sector - Applicable to All
Course Fee S$420.00 (Before GST)
SDF Subsidy available
Course Location Oaks Training Centre
Time 9.00am - 5.00pm
Course Duration 21 Hours
Other Details • Refreshments are provided for morning and afternoon tea breaks.
• A Certificate of Attendance will be given subject to 90% attendance.
Course Code VTLOKMAA7
Can't Find a Suitable Course Date or Syllabus?
Need to Customise a Course?


If you would like us to notify you whenever a new course date becomes available, simply fill up our Notify form and we will let you know the moment any new course dates are released.

If you are looking for a customised course or an in-house course, call us and speak to any of your representatives and we would be happy to assist you.

Call us at 6423-1183.

Past classes

Fellow participants, visit our Facebook to get a copy of your class photo [ click here ].

Microsoft Access 2007 Advanced Class