NEW
Font size
WorksheetsDatabase Validation Rules Quiz
Total questions: 12
Worksheet time: 6mins
What is the purpose of validation rules in a database?
To prevent users from entering data
To ensure data is accurate and consistent
To store additional information
To delete duplicate records
Which of the following is an example of a presence check?
Ensuring an email field contains '@'
Preventing a student’s initial from being left blank
Making sure a number is between 1 and 100
Checking if a phone number is exactly 10 digits
A length check is used to:
Ensure a value falls within a certain range
Restrict the number of characters in a field
Check for blank fields
Verify a specific format for input
What validation rule would prevent a student’s grade from being below 1 or above 8?
Presence check
Range check
Length check
Format check
What happens when a format check is applied?
It ensures the data is not empty
It checks if a value follows a specific pattern
It verifies that a field only contains numbers
It compares values from two different fields
In MS Access, a validation rule is set in which field property?
Default Value
Input Mask
General Properties
Data Type
If a field requires a currency value, which validation type should be used?
Type check
Range check
Presence check
Length check
What would be an appropriate validation rule for a session date field?
SessionDate >= Date()
SessionDate = Date()
SessionDate = NULL
SessionDate 7 OR Stage = 7 AND Stage <= 11
What type of validation would best ensure a student's name contains only letters?
Type check
Range check
Format check
Presence check
If a user enters '12th' instead of '12' for a student’s grade, what validation check should be applied?
Format check
Presence check
Type check
Range check
What is the purpose of a lookup field in a database?
To allow users to search records
To restrict input to predefined options
To automatically correct input errors
To prevent duplicate records
What does the validation rule >= Date() ensure?
The field must be left blank
The entered date must be in the future or today
The entered date must be a past date
The field only accepts numbers
