Unit 2 - Validation Flashcards
Less than
<=
Less than or equals to
>
Greater than
> =
Greater than or equals to
=
Equals to
<>
Not equals to
NOT
Tests for converse values
*
Wildcard (allows any character to be inserted)
IN
Tests for values equal to existing members in a list
Comparison value must be a comma-separated list enclosed in brackets
BETWEEN
Tests for a range of valued; the two values separated by the AND operator
Like
Tests a Text field to match a pattern string of characters
#
Digit or space not required
IS NOT NULL
An entry is required in this field
IS NULL
Field can be left blank
AND
Specifies that all parts of the validation rule must be true
OR
Specifies that some but not all parts of the validation rule must be true
<=
Less than or equal to
>
Greater than
> =
Greater than or equals to
=
Equals to
<>
Not equals to
NOT
Tests for converse values
*
Wildcard (allows any character to be inserted)
IN
Tests for values equal to existing members in a list
Comparison value must be a comma-separated list enclosed in brackets
BETWEEN
Tests for a range of valued; the two values separated by the AND operator
Like
Tests a Text field to match a pattern string of characters
#
Digit or space not required
IS NOT NULL
An entry is required in this field
IS NULL
Field can be left blank
AND
Specifies that all parts of the validation rule must be true
OR
Specifies that some but not all parts of the validation rule must be true
Data Validation
The process of ensuring that a program operates on a clean, correct and useful data
Ways to reduce errors?
Limit the type or amount of data that can be entered
Logical Check
