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

• 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)