10 questions
I want to ensure that users enter a name into the Surname field. Which type of validation should I use?
Length check
Check digit
Presence check
Format check
I want to ensure that users enters a telephone number which starts with +44 and is 13 characters long. Which validation/s should I use?
Length Check
List Check
Format Check
Presence Check
I want to ensure that users enter a national insurance number that follows the pattern letter letter number number number number number number letter?
Length check
Format check
Check Digit
Presence Check
What is the correct syntax to check if a date entered is in the future?
date()
>=date()
<date()
<>date()
What is the correct syntax for an input mask for a telephone number?
???????????
00000000000
zzzzzzzzzzz
aaaaaaaaaaa
Which validation method would you use for a user to choose a gender?
Boolean
Check digit
Value lookup check
Range check
Validation checks to see if something is?
Sensible
Reasonable
Correct
Accurate
to create a presence check in MS Access I need to enter the following in a validation rule?
Presence Check
Is Not Null
Null
Add data <>
Validation rules can be used to create which checks?
Presence check
Format check
Range check
Lookup check
Validation text is used to?
Create a validation rule
Specify an error message to be displayed
Create an option
List all available data