WSQ Funded

WSQ Advanced Access Course in Singapore

Now With WSQ, SFEC, SkillsFuture & UTAP Funding!

Advanced Access 2016 Course Overview

This training is a high-level certification program which will bring your Access 2016 skills to an Expert Level. Upon completion, you will master the more advanced functions of Access, and be able to produce more sophisticated reports, perform complex mathematical calculations, saving time & improving productivity.

Training Schedule

Need a Course Brochure?
We'll send you one!

Course Outline

Advanced Access 2016 Certification

Module 1: Database Concepts

  • Database Development and Use – Know that different types of database models exist like: hierarchical/relational/object-oriented, know the life cycle stages of a database: logical design/database creation/data entry/data maintenance/information retrieval, recognize common business applications of databases like: dynamic website, know the term SQL and understand its main use in querying database content

Module 2: Tables and Relationships

  • Fields/Columns – Create/modify/delete a lookup in a field/column, create/modify/delete an input mask in a field/column, set data entry for a field/column: required/not required
  • Relationships and Joins – Create/modify/delete a one to-one/one-to-many relationship between tables, create/modify a many-to-many relationship using a junction table, apply referential integrity between tables, apply automatic update of related fields, apply automatic deletion of related records, apply/modify an inner join/outer join, create/modify a subtract join, apply a self joinAdvanced Access Practical hands-on training at Intellisoft

Module 3: Queries

  • Query Types – Create/run a query to update data/append records/delete records in a table, create, run a query to save selected data as a new table, create/run a cross tab query, show duplicated records within a table, show unmatched records in related tables
  • Refining a Query – Create/modify/run a one/two variable parameter query, use wildcards, show highest/lowest range of values, create and name a calculated field that performs arithmetic operations, group information in a query using functions: sum, count, average, max, min

Module 4: Forms

  • Controls – Create/modify/delete bound controls, text/combo/list/check box and option groups, add/remove bound control properties, create/modify/delete unbound controls containing arithmetic/logical expressions, modify sequential tab order of controls, create/delete a linked sub form

Module 5: Reports

  • Controls – Format arithmetic calculation controls with percentage/currency, apply running sum for a group, concatenate fields
  • Presentation – Insert/delete a data field in group/page/headers/footers, sort/group records by fields, force page breaks for groups, create/delete a linked sub report

Module 6: Enhancing Productivity

  • Linking/Importing with Macro – Link external data to a spreadsheet/text/existing database, import spreadsheet/text/XML/existing database
  • Automation Using Macro – Create/run a simple macro, assign a macro to a command button/object/control
WSQ Funded courses at Intellisoft Singapore with UTAP Funding, SFEC Funding & 70% WSQ Grants

Now With WSQ, SFEC, SkillsFuture & UTAP Funding!

Target Audience

Course Duration:  3  Full Days (Weekdays or Weekend Classes)

Course Timings: 8.45 am – 5.45 pm

Target Audience: Database administrators or prospective database administrators who have experience working with Microsoft Access and need to learn advanced skills. Also, users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand their Knowledge in a short space of time.

Prerequisites: Need to possess basic knowledge in Microsoft Access.

CertificationSuccessful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 60 minutes online assessment at the end of the course

We also offer Microsoft Access at Basic Level. Check course outline for Basic Access 2016 training.

What Our Happy Participants Say

Grant Information

Training Course Fees

The full course fees for this training is S$695, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$486.50 Funding by SSG
Pay $208.50
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$347.50 Funding by SSG
Pay $347.50
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Do You Have Any Questions

on Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Course Dates

Advanced Access Training in Singapore
Training Schedule

Now With WSQ, SFEC, SkillsFuture & UTAP Fundings.

Learn With Intellisoft & Boost Your Career

Intellisoft Training at Central Singapore

How to Register for Advanced Access 2016 Training ?

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now

Get in Touch

Intellisoft Training Pte Ltd

190 Middle Road, #10-08 Fortune Centre,
Singapore 188979

(65) 6252-5033 (Call)

(65) 9066-9991 (Whatsapp now)

Start Saving Today

Get the 8 Tips to Start Saving on Your Website Design
PDF Guide emailed to you now.

Save Money on Website Design Guide