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