Database Validation

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