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

ICDL - Perform Database Functions (Access 2016) EC

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
     

Target Audience

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

Assumed Skills

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)
     

Course Content

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 ave 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 widthMove 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 databaseUnderstand what is a Primary Key and a Foreign KeyUnderstand the types of relationships
  • Create a One-To-Many relationshipUnderstand the purpose of Referential Integrity
  • Enforce Referential Integrity
  • Editing relationships

Queries

  • Understand that a query is used to extract information from a tableCreate 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 resultsHide/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 formModify form layout
  • Using the form
  • Navigate between recordso
  • 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 formatso Export to a spreadsheeto Export to a text fileo Export to an XML file

 

Full Fee GST Nett Fee after Funding (Incl. GST)
SME/MCES Non-SME/Normal
$350
$24.50
$59.50
$94.50

MCES: Singaporean age 40 and above

Normal: Singaporean/PR age 21 and above

 

SME: Singapore registered companies with

(i) at least 30% local sharing AND

(ii) group annual sales less than or equal to $100 million OR group employment size less than or equal to 200 people

Course Duration
17
Course Reference Number
CRS-Q-0031272-ES
Funding Validity Period
01 Jan 2019 To 03 Jun 2021
Mode of Training
Classroom