Data Validation 1

Why is it important that we implement good validation rules?

• To help prevent data entry errors

• To make the database look nicer

• To ensure we give good warning messages to help users

• To ensure relationships are setup correctly

The expression builder is a tool we can use to create validation rules in Microsoft Access.

• True

• False

What is the expression entered into the expression builder to ensure that a field is not left blank?

• IF EMPTY

• IS NULL

• IS NOT EMPTY

• IS NOT NULL

Why is it better to use a validation rule rather than checking the “Required” box in the field properties panel?

• It is more professional and results in a cleaner looking product

• It allows us to customise our validation warning message

• It is good practice to learn to write our own validation rules

• It is good practice to learn to write our own validation rules

How do we normally implement format checks in Access?

• Format Property

• Input Mask

• Lookup Table

• Data Type

What is the name of the property in the field properties panel that defines the max length of the field?

• Field Size

• Field Length

• Text Size

• Text Length

A range check allows us to specify that a number field has a value between a maximum and minimum amount.

• True

• False

What rule would we use in the expression builder to set a range of 1 to 100 for a number field?

• 1 – 100

• 1 AND 100

• = 1 AND =100

• >= 1 AND <=100

The Input Mask Wizard lets you setup an input mask for email addresses.

• True

• False