03 days - (Advanced Access 2013 - 24 hrs) – Perform Advanced Database Functions (ICDL Certification) (CRS-Q-0025215-ES)

Commencement Dates

Please contact us for schedules.


Course Duration

24 Hours

Target Audience

For beginner and professional who in need of Advanced Databases applications to better manage and organize structured information.


Need to possess basic knowledge of Access 2013


Successful 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 SSG and ICDL Singapore. Student must take a 60 minutes online assessment at the end of the course.

Course Pathway

For more information on the ICDL Progression Pathway please refer to the link below:

ICDL Courses Progression Pathways


Mode of Training



ICDL Advanced Database is a high level certification program which enables candidates gets more from the database application by giving them the skills to use the many advanced tools available in database applications to better manage and organize structured information.

Individuals with ICDL Advanced Database certified skills can:


  • Produce better reports with deeper data analysis
  • Produce higher quality management information
  • Use advanced features in table, query, form and report design
  • Use macros within the database application
  • Import, export and link data

Course Details



Section 1 - Fundamentals

Understand Database Concepts
Understand SQL
Create a Database
Design a Table

Section 2 – Field Properties

Create Lookup Fields
Set and Modify Default Values
Set Mandatory Fields
Create Validation Rules and Text
Create Input Masks

Section 3 - Queries

Create Sum and Count Queries
Use Group By in Queries
Show Average, Maximum and Minimum Values
Create Calculated Fields
Create Parameter Queries
Use Wildcards

Section 4 - Relationships

Apply Primary Keys
Apply and Modify Different Types of Relationship
Query Related Tables
Understand Joins
Apply Referential Integrity
Update and Delete Related Records
Work with Subdatasheets

Section 5 - Forms

Create Main Forms and Sub Forms
Link Forms
Create Forms from Multiple Tables

Section 6 - Form Controls

Create the following controls:
Calculated Fields on Forms
Command Buttons
Combo Boxes
List Boxes and Check Boxes
Option Groups
Add Data Fields to Headers and Footers

Section 7 - Reports

Create Grouped Reports
Create Sub reports
Insert Page Breaks
Create Calculated Fields in Reports
Calculate Percentages
Insert Data Fields in Headers and Footers
Print Reports

Section 8 - Import and Link Data

Import Data from Spreadsheets
Import Data from Text Files
Import Data from Tables
Link a Database to External Data

Section 9 - Action Queries

Create Append Queries
Create Delete Queries
Make a Table from a Query
Create an Update Query

Section 10 – Query Wizards

Create a Crosstab Query
Create a Find Duplicates Query
Create a Find Unmatched Query

Section 11 - Macros

Understand Macro Actions
Create a Macro
Attach a Macro to a Control or Object
Create Macros from Controls
Create Command Button Macros

Entry Requirement

  • Primary Education without PSLE/PSPE certificate or their equivalent 

Fees Structure

 03 days - (Advanced Access 2013 - 24 hrs) – Perform Advanced Database Functions (ICDL Certification) (CRS-Q-0025215-ES)


Singaporean 25 to 39 & PR

Mid-Career Enhanced & Subsidy >=40 years old born on /before 1978

WTS, > = 35 years old  born on/
before 1983

Course Fee




SkillsFuture Funding




Total Gross Fee




GST 7%




SkillsFuture Credit Deduction/Cash




Participant need to pass the test to get subsidy

Eligible for Claim Period: 01 Oct 2015 - 19 Jan 2020

SSG Advice:

All Singaporean aged 25 and above can use their $500 SkillsFuture Credit to pay for a wide range of approved skills-related courses.

Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to choose for the courses available on the SkillsFuture Credit course directory.

Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?


Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
Registration No: 198902296M
24 June 2015 to 23 June 2019
Main Office
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588
Bedok Branch
Blk 209 New Upper Changi Road
#04-643 Singapore 460209
Tel: +65 6913 4572
Jurong Branch
CPF Jurong Building 21
#03-09/10 Jurong Gateway Road
Singapore 150167
Tel: +65 6912 4316
Bukit Merah Branch
Blk 167 Jln Bt Merah Tower 4, Connection One
#06-11A Singapore 150167
Tel: +65 6928 0735