Unit 2 - Validation Flashcards
1
Q
A
Less than
2
Q
<=
A
Less than or equals to
3
Q
>
A
Greater than
4
Q
> =
A
Greater than or equals to
5
Q
=
A
Equals to
6
Q
<>
A
Not equals to
7
Q
NOT
A
Tests for converse values
8
Q
*
A
Wildcard (allows any character to be inserted)
9
Q
IN
A
Tests for values equal to existing members in a list
Comparison value must be a comma-separated list enclosed in brackets
10
Q
BETWEEN
A
Tests for a range of valued; the two values separated by the AND operator
11
Q
Like
A
Tests a Text field to match a pattern string of characters
12
Q
#
A
Digit or space not required
13
Q
IS NOT NULL
A
An entry is required in this field
14
Q
IS NULL
A
Field can be left blank
15
Q
AND
A
Specifies that all parts of the validation rule must be true
