Data Validation (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is the main purpose of data validation in a database?
What is the main purpose of data validation in a database?
To check info is accurate & correct type
Which validation check ensures numerical data falls within specific limits?
Which validation check ensures numerical data falls within specific limits?
Range check
What does a lookup column provide during data entry?
What does a lookup column provide during data entry?
A dropdown list of predefined values
Which view must you use in Access to add validation rules to database fields?
Which view must you use in Access to add validation rules to database fields?
Design View
What tool opens when you select 'Field Validation Rule' in Access?
What tool opens when you select 'Field Validation Rule' in Access?
Expression Builder
What does the validation rule <>0 check for?
What does the validation rule <>0 check for?
Must enter a non-zero value
What does the validation rule <Date() ensure for a birth date field?
What does the validation rule <Date() ensure for a birth date field?
Date must be in the past
What does the input mask character 0 require users to enter?
What does the input mask character 0 require users to enter?
Must enter a digit (0-9)
What does the input mask character L require users to enter?
What does the input mask character L require users to enter?
Must enter a letter
What makes a validation error message effective?
What makes a validation error message effective?
Simple and specific guidance