4.15 - 4.16 Validation & verifiction

Question 1

What are all the types of Data Validation checks (Theres 7)

Answer 1

Presence check, Format check, Length check, Type check, Range check, Check digit and List box/Lookup table

Question 2

What are the two types of data Verification types?

Answer 2

Double keying and Proofreading

Question 3

Why is a presence check used

Answer 3

To ensure data has been entered into the field and the field is not null

Question 4

Why is a check digit used

Answer 4

The last digits are used to check the rest of the digits are correct. The last digits are sometimes a sum of all the digits added together.

Question 5

Why is a list box used.

Answer 5

A list box is used to lookup data from a table of information.

Question 6

How does double keying work

Answer 6

Data is typed in twice to check it has been entered correctly e.g. A password field

Question 7

What is the use of proofreading

Answer 7

Checks the data entered is the same as the original. A visual check by the operator to check that the original data and the data typed in are the same.

Question 8

A validation check is made for a National Insurence number, State the type of check and rule

Answer 8

Type = Format Check
Rule = Have 2 letters at the start and a letter at the end with 6 numbers in between.

Question 9

A validation check is made for entering your surname, State the type of check and rule

Answer 9

Type = Presence check
Rule = Ensure Data has been entered into the field and is not null.