Database

A persistent collection of data which is held together in an organised or logical way

A single item of data about a person or thing e.g. name date of birth length

A set of fields defined to contain information about one thing. e.g. an employee.

All of the records regarding a set of people or things

An attribute in one table that is a primary key in another table.

Indicates the type of data that can be stored in the field

User process of checking that the data entered is accurate

Validation technique. Ensures the exact right amount of characters is entered into a field

Validation technique. Ensures a field is between a certain range of values

Validation technique. A field may required letters and numbers in a certain order

Validation technique. Requires a field to be completed

Validation technique. Only data contained within the lookup table (list) is permitted

Verification technique. Two users enter the same data it is then compared for accuracy. Errors are re-entered

Verification technique. Someone checking the data entered against the original document

A database object which enables you to locate multiple records matching specified criteria