Database Software

Question 1

Validation

Answer 1

Checking that data is acceptable and sensible.

Question 2

Verification

Answer 2

Checking that data entered has been inputted accurately.

Question 3

Presence check

Answer 3

Ensures that some data has been entered into an area on the form.

Question 4

Length check

Answer 4

Ensures that data entered is of the correct length e.g. At least 8 characters

Question 5

Type check

Answer 5

Ensures that data is the correct type e.g. Numeric, text, date

Question 6

Numeric

Answer 6

Data which is a number and can be used for calculations

Question 7

Text

Answer 7

Data made up of letters or letters and numbers

Question 8

Date

Answer 8

Data formatted as a date or time

Question 9

Boolean

Answer 9

Data which can only have two values e.g. Yes/No, True/False, 0/1

Question 10

Currency

Answer 10

Data representing values of money

Question 11

Format check

Answer 11

Ensures data follows a particular format e.g. Three letters followed by three numbers - AAA000

Question 12

Range check

Answer 12

Ensures data is within a given range e.g. Between 1 and 10, or between two dates

Question 13

Check digit

Answer 13

A number added to the end of a barcode that is used to check whether the barcode has been scanned or entered correctly.