Module 5 - Database

Database is the basis for the practice-based test on Databases. The module consists of two sections; the first section involves setting up a new database, and the second involves using an existing database to retrieve and display required information.

Who Should Attend

Anyone who is interested to get knowledge in Computers

Pre-requisites

ICDL - Module 4 - Spreadsheets

Objective

Database requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the candidate's ability to design and plan a simple database using a standard database package; the second section requires the candidate to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the database. The candidate shall also be able to create and modify reports.

Duration

10 Training Hours

Exam Number

ICDL - Module 5 Test

Class Outline

• Getting Started

• First Steps with Databases

• Adjust Basic Settings

• Create a Database

• Basic Operations

• Define Keys

• Table Design

• Updating a Database

• Use of Forms

• Create a Form

• Modify Form Layout

• Retrieve Information

• Basic Operations

• Refine a Query

• Select and Sort

• Reporting

• Create Reports