5. Data Handling Software

What is it?

A database is an application which allows the effective storage of data and records in a logical way. 

Databases can be computerised or paper-based, but for the purposes of this course we will discuss computerised databases.

What is it used for?

• Data handling
• Sorting data
• Searching for data / running queries
• Producing reports
• Mail merge

How were things done before database software?

Data was stored in paper-based databases.  These could have been in the form of individual cards stored in a box, possibly alphabetically or in date order.  They might have been in the form of an ordered list in a book or catalogue, for example telephone numbers in a telephone directory.

Advantages of using databases for storing data and records

- Queries can be used to extract data from tables

- Reports can be generated to present data to users

- Referential integrity can be used to ensure that related data is valid

- Relationships can be set up to avoid data duplication

- Data is independent of the database structure

- Data can easily be added or amended without the need to redesign the database, queries or reports