02 days - (Microsoft Access 2013 - 17 hrs) Perform Database Functions (ICDL Certification) (CRS-Q-0025216-ES)

Commencement Dates

Please contact us for schedules.


Course Duration

17 Hours 

Target Audience

For beginner and professional who in need of database application.


Need to possess the knowledge of basic PC


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 45 min 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




This module enables candidates to understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.

On completion of this module each candidate will be able to:

  1. Understand what a database is and how it is organized and operated
  2. Create a simple database and view the database content in various modes
  3. Create a table, define and modify fields and their properties; enter and edit data in a Table
  4. Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
  5. Understand what a form is and create a form to enter, modify and delete records and data in records

Course Details



Section 1 : Concepts and Introducing Access

Database Principles
Designing & Planning a Database
Starting & Exiting Access
Screen Layout
Ribbon & QAT
Getting Help

Section 2 : Working with Databases

Opening & Closing a Database
Navigating in the Database

Section 3 : Tables

Using the Mouse & Keyboard to Move
Create a New Database & Table
Format & Edit Field Properties
Define a Primary Key
Create Index Fields
Create Validation Rules & Text

Section 4 : Table Design

Adding Fields
Field Properties
Editing Field Properties
Validation Rules / Text

Section 5 : Editing

Change Column Width
Find Text
Edit & Delete Data
Add Records
Delete & Edit
Use Wildcards to Search
Edit & Enter Data Using Shortcuts

Section 6 : Table Relationships

Understand & Apply Relationships
Create Various Types of Relationship
Defining a Primary Key
Relationship Concepts & Types
Applying Relationships
Referential Integrity
Updating / Deleting Records

Section 7 : Forms

Quick Forms & the Form Wizard
Form Design (Create / Delete)
Editing a Form Design
Using the Form (Sorting / Editing)
Filtering & Printing From a Form

Section 8 : Report

Using Quick Report
Creating & Deleting a Report
Modifying a Report
Creating Calculations in Reports
Printing From a Report

Section 9 : Queries

Finding Specific Text
Using Wildcards
Querying a Table
The Select Query
Editing / Deleting Queries
Using Value Ranges
Querying Related Tables
AND & OR Queries
Sorting Query Results
Saving & Printing Queries

Section 10 : Exporting Exporting Data


Entry Requirement

  • Primary education without PSLE/PSPE Certificate or their equivalent 

Fees Structure


02 days - (Microsoft Access 2013 - 17 hrs) Perform Database Functions (ICDL Certification) (CRS-Q-0025216-ES)


Singaporean 25 to 39 & PR

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

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

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