Other slides in this set

Slide 2

Preview of page 2

Here's a taster:

Validation definition
Making sure that data is:
· Sensible
· Reasonable
· Complete
· Within acceptable boundaries
Reduces the amount of errors made when data is
entered into a system…read more

Slide 3

Preview of page 3

Here's a taster:

Range check, presence check
Range check
· Data must be a value that falls between two predefined
values
· Used when data consists of numbers, currency or
date/time
· E.g. Shoe sizes in stock has to be between 4 and 9
Presence check
· Requires that a value must be entered
· Makes sure important data isn't missed out, if it is an
error message will appear
· E.g. A school always needs to know a child's emergency
phone number…read more

Slide 4

Preview of page 4

Here's a taster:

Format check, data type
Format check
· Data must conform to a specific layout such as
numbers or letters
· Used when data always consists of the same pattern
· E.g. Postcodes always have the same pattern of: LLNN
NLL
Data type
· The data must be a specific type such as text,
boolean etc.
· E.g. Data entered for number of stock must be a
number…read more

Slide 5

Preview of page 5

Here's a taster:

Fixed value, check digit
Fixed value
· Data must conform to one of the fields in a
predefined list
· E.g. In a gender field you can be either male or
female
Check digit
· Checks errors in long numbers such as ISBN numbers
· Works by producing a number from a mathematical
number based on the check digit and if the same
number isn't calculated as the check digit then an
error message will appear…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »