fbpx ICDL - Perform Database Functions (Access 2016) EC | Eagle Infotech Skip to main content

ICDL - Perform Database Functions (Access 2016) EC


Download PDF Outline

Download PDF Outline 


This module enables learners 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 learner will be able to:

  • Understand what a database is and how it is organised and operated
  • Create a simple database and view the database content in various modes
  • Create a table, define and modify fields and their properties; enter and edit data in a table
  • Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
  • Understand what a form is and create a form to enter, modify and delete records and data in records
  • Create routine reports and prepare outputs ready for distribution


This course is intended for learners with little or no knowledge of running a database application and using a database.


The learner must be able to:

  • operate a Personal Computer, use keyboard and mouse
  • read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)


1. Database Concepts

Understand key database concepts

  • Definition of a database
  • Difference between data and information
  • Common uses of large scale databases
  • Roles and responsibilities of users

Database organisation

  • Understand how a database is organised
  • Understand what is a table, record, field
  • Design considerations

2. Managing a Database

Working with database

  • Open/exit the application
  • Create and save a new database
  • Explore the Microsoft Access window
  • Using Tell Me and Help

Common tasks with database

  • Open/close an existing database
  • The Navigation Pane
  • Open/save/close/delete database objects

Managing a Table

  • Create and save a new table
  • Add/delete fields to a table
  • Understand data types
  • Understand the consequences of changing data types
  • Define field properties
  • Set a Primary Key
  • Create Indexes

Managing Data

  • Add/edit/delete records to a table
  • Navigating between records
  • Search for data
  • Preview and print a table

Modify Table Layout

  • Change column width
  • Move a column
  • Hide/unhide a column(s)
  • Freeze/unfreeze column(s)
  • Format font of a datasheet
  • Change the appearance of a datasheet

Data Retrieval

  • Sort records using a single column
  • Sort using multiple columns
  • Filter by selection
  • Filter by form
  • Filter excluding selection

Table Relationships

  • Understand what is a relational database
  • Understand what is a Primary Key and a Foreign Key
  • Understand the types of relationships
  • Create a One-To-Many relationship
  • Understand the purpose of Referential Integrity
  • Enforce Referential Integrity
  • Editing relationships


  • Understand that a query is used to extract information from a table
  • Create and save a single table query
  • Create and save a two-table query
  • Add/remove fields to a query
  • Change the position of fields
  • Sort query results
  • Hide/unhide fields
  • Specify criteria using Comparison Operators
  • Specify criteria using Logical Operators
  • Specify criteria using Range of values and Wildcards
  • Run a query


  • Understand that a form is used to display and edit records
  • Create and save a form
  • Modify form layout
  • Using the form
  • Navigate between records
  • Create, edit, delete records
  • Sort and filter records
  • Print and delete a form


  • Understand that a report is used to print selected records from a table or query
  • Create and save a report
  • Create a grouped report
  • Modify report layout
  • Perform calculations in a report
  • Print and delete a report

Export Data

  • Understand the purpose of exporting data
  • Export data in different file formats
  • Export to a spreadsheet
  • Export to a text file
  • Export to an XML file


ICDL - Perform Database Functions (Access 2016) EC


Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeSME Full Fee$535 GST$37.45 Funding Amount($374.50) Nett Fee Payable$197.95
Funding TypeNon-SME Full Fee$535 GST$37.45 Funding Amount($267.50) Nett Fee Payable$304.95
Funding TypeNon-SME (MCES) Full Fee$535 GST$37.45 Funding Amount($374.50) Nett Fee Payable$197.95
  • SME: Singapore registered companies with (i) at least 30% local sharing AND (ii) Group annual sales less than $100 million OR Group employment size less than 200
  • Non-SME (MCES): Employee is Singaporean aged 40 years and above 
Course Fee Funding 
SME: 70% of course fee 
Non-SME: 50% of course fee 
Non-SME(MCES): 70% of course fee 
Eligible for Absentee Payroll Funding  
$4.50 per training hour capped at $100,000 per enterprise per calendar year


Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeMCES Full Fee$535 GST$37.45 Funding Amount($374.50) Nett Fee Payable (Incl. GST)$197.95
Funding TypeNormal Full Fee$535 GST$37.45 Funding Amount($267.50) Nett Fee Payable (Incl. GST)$304.95
  • MCES: Singaporean aged 40 years and above
  • Normal: Singaporean / PR aged 21 years and above
Course Fee Funding 
MCES: 70% of course fee 
Normal: 50% of course fee 

Eligible for SkillsFuture Credit 
Course Duration
Course Reference Number
Funding Validity Period
01 Jan 2019 To 31 Dec 2022
Mode of Training