Please enable JavaScript
17 hours – ICDL Perform Database Functions (Access 2016) – Eagle Infotech Consultants
Eagle Infotech Consultants
150 Orchard Road #06-14
Orchard Plaza Singapore 238841

17 hours – ICDL Perform Database Functions (Access 2016)

COURSE DURATION
17 hours

Course Reference Number
CRS-Q-0031272-ES
Funding Validity Period
Till  23 Oct 2019
Mode of Training
Classroom
Course Synopsis

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

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

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

o Navigate between records
o Create, edit, delete records
o 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
o Export to a spreadsheet
o Export to a text file
o Export to an XML file

Course Fees (Self-Sponsored)

Full Fee GST Nett Fee after Funding (Incl. GST)
MCES Normal WTS
$535 $37.45 $90.95 $164.45 $64.20

MCES: Singaporean age 40 and above
Normal: Singaporean/PR age 21 and above
WTS: Singaporean age 35 and above and earning  $2,000 or below per month

 

View Course Dates