Exercise on Queries

Exercise on Validation
You will understand the basic applications of  Validation rules 
1. Validation rule/text
2. Input mask
3. Field size 
4. solving exams questions 
1 / 21
next
Slide 1: Slide

This lesson contains 21 slides, with interactive quizzes and text slides.

Items in this lesson

Exercise on Validation
You will understand the basic applications of  Validation rules 
1. Validation rule/text
2. Input mask
3. Field size 
4. solving exams questions 

Slide 1 - Slide

Slide 2 - Slide

Inspecting the relationship above
How many 1- many relationship can you see?
A
0
B
2
C
1
D
3

Slide 3 - Quiz

Describe the 1- many relationship
A
One beech to Many district
B
One Beech to one review
C
one beech to many Clean up (reviews)
D
None of the above

Slide 4 - Quiz

How many 1-1 relationships can you identify?
A
1
B
2
C
5
D
3

Slide 5 - Quiz

volunteer to one district.
Which key becomes the foreign key
A
district
B
Foreign Key ID
C
district name
D
None of the above

Slide 6 - Quiz

Slide 7 - Slide

Which field does the above validation rule apply to?
A
Volunteer Mobile
B
Volunteer ID
C
Volunteer Surname
D
None of the above

Slide 8 - Quiz

What does the Validation rule do?

Slide 9 - Open question

What view must you be in to edit Validation rule?

Slide 10 - Open question

Slide 11 - Slide

Slide 12 - Slide

Name the Four Validation rules that is set

Slide 13 - Open question

What does the input mask do?
A
Nothing
B
Ensures that only 10 numbers are entered
C
Ensures that only 11 numbers are entered
D
Ensures that only 12 numbers are entered

Slide 14 - Quiz

What does field size set to 11 do?
A
Ensures that only 11 numbers are entered
B
Ensures that only 9 numbers are entered
C
Ensures that only 10 numbers are entered
D
Ensures that only 12 numbers are entered

Slide 15 - Quiz

Slide 16 - Slide

The above figure shows 6 validation rules to set for the exams 1-6
Which ones has been set do far
A
1 & 3
B
1&2
C
2&3
D
5&6

Slide 17 - Quiz

Slide 18 - Slide

Refer to the figure above and
state the Validation Rule

Slide 19 - Mind map

Which Validation rule for the exams paper does the above rule apply to?
A
1 & 2
B
3 & 4
C
5&6
D
None of the above

Slide 20 - Quiz

The End 
We hope that this help with with the revision on  Validation rule.
Write down at least 5 rules you can remember.

Slide 21 - Slide