ES WSQ – 2 Days – Perform Using Databases Functions (Ms Access 2013 – 17 hrs) (ICDL Certification Module: Using Databases)

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 WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

Course Pathway

ICDL - Perform Advanced Database Functions (Advanced Access 2013)



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


Fees Structure

Subsidy and Nett Payable Amount

Subsidy Categories

Fees after subsidy

Fees payable with GST


SME Company



Non – SME Company



Foreigner (WP, S-Pass, E-Pass, Dependant Pass)




Singaporean - 40 yrs and above



Singaporean – 21 – 39 yrs



Singapore PR



WTS (35 yrs and above - salary less than $2000)



Foreigner and work pass holders – WP, S-Pass,

E-Pass, Dependant Pass)



SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy

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
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588