ICDL - Perform Database Functions (Access 2016) EC

ICDL – Perform Database Functions (Access 2016) EC (24 hrs)

Course Code: TGS-2017501106 | SSG Funded

*Classroom-based learning*

This course enables participants 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.

Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by SkillsFuture Singapore (SSG).

  • 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

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

Queries

  • 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

Forms

  • 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

Reports

  • 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

Participants go through a structured curriculum supplemented with hands-on exercises on computers.

 

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

Prerequisites

Participants are assumed to:

  • Be able to operate a personal computer, use keyboard and mouse
  • Be able to read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)

Duration : 3 days (24 hrs)
Time : 8:30am to 6:00pm

Course Fee : $535.00
Nett Fee Incl. 7% GST : $572.45
Nett Fee after Training Grant* : $197.95 (SMEs) | $304.95 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $197.95

Funding validity period: 24 Oct 2017 – 03 Jun 2023

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with Eagle Infotech)

Key Benefits
  • 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
Course Contents

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

Queries

  • 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

Forms

  • 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

Reports

  • 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
Learning Methodology

Participants go through a structured curriculum supplemented with hands-on exercises on computers.

 

Who Should Attend

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

Prerequisites

Participants are assumed to:

  • Be able to operate a personal computer, use keyboard and mouse
  • Be able to read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)
Course Details

Duration : 3 days (24 hrs)
Time : 8:30am to 6:00pm

Course Fee : $535.00
Nett Fee Incl. 7% GST : $572.45
Nett Fee after Training Grant* : $197.95 (SMEs) | $304.95 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $197.95

Funding validity period: 24 Oct 2017 – 03 Jun 2023

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with Eagle Infotech)

Course Application

Details Registration
June 3, 2022 - June 7, 2022 (8:30 am - 6:00 pm)
[Dates : Jun 3, 6 & 7]
Closed
June 11, 2022 - June 25, 2022 (8:30 am - 6:00 pm)
[Dates : Jun 11, 18 & 25]
Closed
July 16, 2022 - July 30, 2022 (8:30 am - 6:00 pm)
[Dates : Jul 16, 23 & 30]
Closed
July 25, 2022 - July 27, 2022 (8:30 am - 6:00 pm)
[Dates : Jul 25, 26 & 27]
Closed
August 13, 2022 - August 27, 2022 (8:30 am - 6:00 pm)
[Dates: Aug 13, 20 & 27]
Closed
August 17, 2022 - August 19, 2022 (8:30 am - 6:00 pm)
[Dates: Aug 17, 18 & 19]
Closed
September 3, 2022 - September 17, 2022 (8:30 am - 6:00 pm)
[Dates: Sep 3, 10 & 17]
Register Now
September 9, 2022 - September 13, 2022 (8:30 am - 6:00 pm)
[Dates: Sep 9, 12 & 13]
Register Now
October 15, 2022 - October 29, 2022 (8:30 am - 6:00 pm)
[Dates: Oct 15, 22 & 29]
Register Now
October 26, 2022 - October 28, 2022 (8:30 am - 6:00 pm)
[Dates: Oct 26, 27 & 28]
Register Now
November 2, 2022 - November 4, 2022 (8:30 am - 6:00 pm)
[Dates: Nov 2, 3 & 4]
Register Now
November 19, 2022 - December 3, 2022 (8:30 am - 6:00 pm)
[Dates: Nov 19, 26 & Dec 3]
Register Now
December 2, 2022 - December 6, 2022 (8:30 am - 6:00 pm)
[Dates: Dec 2, 5 & 6]
Register Now
December 20, 2022 - December 22, 2022 (8:30 am - 6:00 pm)
[Dates: 20, 21 & 22]
Register Now