BTEC Level 3 IT - Activity 2

Checking a field is blank..

• Presence Check

• Length Check

• Value lookup

• Range Check

Checking the amount of characters in a field..

• Presence Check

• Length Check

• Value lookup

• Range Check

Checking that the numbers or dates entered is between 2 values..

• Presence Check

• Length Check

• Value lookup

• Range Check

Adding in a drop down box that you have entered the values for..

• Presence Check

• Length Check

• Value lookup

• Range Check

Is ___ ___

• null not

• Not Null

Is ___ ___

Making sure the user types in Dates/Post Codes/Phone numbers correctly...

• Presence Check

• Length Check

• Value lookup

• Range Check

• Format Check

In design view where would we put the format check?

• Validation rule

• Validation text

• Input Mask

• Lookup

In design view where would we put the presence check?

• Validation rule

• Validation text

• Input Mask

• Lookup

In design view where would we put the presence check error text?

• Validation rule

• Validation text

• Input Mask

• Lookup