
Data Validation 1

Quiz
•
Computers
•
1st - 5th Grade
•
Hard
Used 24+ times
FREE Resource
9 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The expression builder is a tool we can use to create validation rules in Microsoft Access.
True
False
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do we normally implement format checks in Access?
Format Property
Input Mask
Lookup Table
Data Type
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A range check allows us to specify that a number field has a value between a maximum and minimum amount.
True
False
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
9.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The Input Mask Wizard lets you setup an input mask for email addresses.
True
False
Similar Resources on Wayground
14 questions
INTRODUCTION TO MEDIA AND INFORMATION LITERACY HUMSS

Quiz
•
KG - 11th Grade
9 questions
Smart Retail

Quiz
•
1st Grade
12 questions
GC Web Dev L3S12

Quiz
•
4th - 6th Grade
10 questions
LEVEL ONE MINI TRAINING B003 EXAMS RERUN

Quiz
•
4th Grade
10 questions
MINECRAFT: EDUCATION EDITION

Quiz
•
KG - 12th Grade
10 questions
20-21 S3 電腦英文詞彙

Quiz
•
1st Grade
7 questions
Tras la pista del ladrón de la navidad

Quiz
•
3rd - 6th Grade
10 questions
Database Level 1

Quiz
•
5th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade