Databases
A database stores and organises data and allows the user to access it in a number of different ways.

Data is stored in files (tables).

Each file (table) has a number of related records.

Each record consists of related fields.

Microsoft Access is an example of a Database package.
Databases allow the user to..
  • define the data structure (field names and types)
  • enter and edit data
  • import data from saved files or other applications
  • search for data by using queries (including AND, OR and NOT)
  • sort data into alphabetic or numeric order
  • validate data on entry
  • output reports which may include totals, averages etc...
  • set security levels