Main navigation

WSQ Funded

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 for Upcoming Workshop in Singapore

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

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.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6296-4663 for Details or WhatsApp Now at +65-9066-6661

UP TO 95%
(WTS)

$636
$59 You Pay
  • Singaporean, Above 35 Years, &
  • Salary Below S$2000 per month
  • Holding a valid WTS Letter
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $26.5 per hour

UP TO 90% Grant

$600
$95
You Pay
  • Singaporean, Above 40 Years &
  • Salary Above S$2000 per month
  • For SME Companies
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $25 per hour

UP TO 80% Grant

$408
$287
You Pay
  • Singaporean, Below 40 Years &
  • Salary Above S$2000 per month
  • PRs / MNC Companies
  • Singaporeans can use SkillsFuture to offset balance fee
  • Grant is capped at $17 per hour.

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 for Upcoming Workshop in Singapore

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 6296-4663 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now

Get in touch

Send us a message

Intellisoft Training Pte Ltd

5001 Beach Road, #06-05 Golden Mile Complex,
Singapore 199588

(65) 6296-4663 (Call)

(65) 9066-9991 (Whatsapp now)