Data Validation 1

Data Validation 1

1st - 5th Grade

9 Qs

quiz-placeholder

Similar activities

roblox quiz

roblox quiz

1st - 10th Grade

10 Qs

Weekly Quiz 1

Weekly Quiz 1

4th Grade - Professional Development

10 Qs

Data Validation

Data Validation

KG - Professional Development

11 Qs

Minecraft coding basics

Minecraft coding basics

5th Grade - University

10 Qs

Blockchain

Blockchain

5th Grade - Professional Development

10 Qs

Grade 8 Ch 6 & 7

Grade 8 Ch 6 & 7

5th Grade

10 Qs

developer form (kfc restaurant roblox)

developer form (kfc restaurant roblox)

1st Grade

7 Qs

Databases - Validating Data

Databases - Validating Data

3rd - 12th Grade

10 Qs

Data Validation 1

Data Validation 1

Assessment

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