Unit 2 - Validation

Answer 1

Less than

Question 2

<=

Answer 2

Less than or equals to

Question 3

>

Answer 3

Greater than

Question 4

> =

Answer 4

Greater than or equals to

Question 5

=

Answer 5

Equals to

Question 6

<>

Answer 6

Not equals to

Question 7

NOT

Answer 7

Tests for converse values

Question 8

*

Answer 8

Wildcard (allows any character to be inserted)

Question 9

IN

Answer 9

Tests for values equal to existing members in a list

Comparison value must be a comma-separated list enclosed in brackets

Question 10

BETWEEN

Answer 10

Tests for a range of valued; the two values separated by the AND operator

Question 11

Like

Answer 11

Tests a Text field to match a pattern string of characters

Question 12

#

Answer 12

Digit or space not required

Question 13

IS NOT NULL

Answer 13

An entry is required in this field

Question 14

IS NULL

Answer 14

Field can be left blank

Question 15

AND

Answer 15

Specifies that all parts of the validation rule must be true

Question 16

OR

Answer 16

Specifies that some but not all parts of the validation rule must be true

Question 17

<=

Answer 17

Less than or equal to

Question 18

>

Answer 18

Greater than

Question 19

> =

Answer 19

Greater than or equals to

Question 20

=

Answer 20

Equals to

Question 21

<>

Answer 21

Not equals to

Question 22

NOT

Answer 22

Tests for converse values

Question 23

*

Answer 23

Wildcard (allows any character to be inserted)

Question 24

IN

Answer 24

Tests for values equal to existing members in a list

Comparison value must be a comma-separated list enclosed in brackets

Question 25

BETWEEN

Answer 25

Tests for a range of valued; the two values separated by the AND operator

Question 26

Like

Answer 26

Tests a Text field to match a pattern string of characters

Question 27

#

Answer 27

Digit or space not required

Question 28

IS NOT NULL

Answer 28

An entry is required in this field

Question 29

IS NULL

Answer 29

Field can be left blank

Question 30

AND

Answer 30

Specifies that all parts of the validation rule must be true

Question 31

OR

Answer 31

Specifies that some but not all parts of the validation rule must be true

Question 32

Data Validation

Answer 32

The process of ensuring that a program operates on a clean, correct and useful data

Question 33

Ways to reduce errors?

Answer 33

Limit the type or amount of data that can be entered | Logical Check