ICDL Professional modules - Computational - Using Databases

A database is a collection of data stored in tables to be easily accessed, managed, and updated. A database offers more complex ways of using data than spreadsheets and data can be entered via forms.

This course will enable successful participants to:

  • Understand what a database is and how it is organized 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

Category

Understanding Databases

Skill Set

Task Item

Understand what a database is

Understand the difference between data and information

Understand how a database is organized in terms of tables, records and fields

Know some of the common uses of large-scale databases like: airline booking systems, government records, bank account records, hospital patient details

Skill Set

Operation

Category

Outputs

Task Item

Understand that a report is used to print selected information from a table or query

Create and name a report based on a table, query

Change arrangement of data fields and headings within a report layout

Present specific fields in a grouped report by sum, minimum, maximum, average, count, at appropriate break points

Add, modify text in headers, footers in a report

Export a table, query output in spreadsheet, text (.txt, .csv), XML format to a location on a drive