SHS 9.3 Databases

A collection of information that is organised so that it can be easily accessed, managed and updated.

• Database

• Field

• Forms

• Report

A single item of data about a single record in a database.

• Fileld

• Database

• Verification

• Report

A collection of fields that represent a single identity, such as a person.

• Record

• Database table

• Mail merge

• Foreign key

In databases, a collection of records representing a type of item.

• Database table

• Queries

• Report

• Mail merge

Text e.g. S Jones, Number e.g. 4,6, Currency e.g. £3.00, Boolean e.g. True/False Yes/No, Date e.g. 12/12/2012

• Data types

• Verification

• Forms

• Queries

A database where all of your data is stored in one large table

• Flat file database

• Relational database

• Verification

• Forms

A database containing multiple related tables

• Relational database

• Key field

• Validation

• Report

Field which contains a different value for every record in that database

• Key field

• Record

• Field

• Database

Acts as a unique identifier

• Primary key

• Form

• Report

• Mail merge

An automatic computer check to ensure that the data entered is sensible and reasonable

• Validation

• Verification

• Report

• Forms