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 

Inspecting the relationship above
How many 1- many relationship can you see?

1. 0
2. 2
3. 1
4. 3

Describe the 1- many relationship

1. One beech to Many district
2. One Beech to one review
3. one beech to many Clean up (reviews)
4. None of the above

How many 1-1 relationships can you identify?

1. 1
2. 2
3. 5
4. 3

volunteer to one district.
Which key becomes the foreign key

1. district
2. Foreign Key ID
3. district name
4. None of the above

Which field does the above validation rule apply to?

1. Volunteer Mobile
2. Volunteer ID
3. Volunteer Surname
4. None of the above

What does the Validation rule do?

What view must you be in to edit Validation rule?

Name the Four Validation rules that is set

What does the input mask do?

1. Nothing
2. Ensures that only 10 numbers are entered
3. Ensures that only 11 numbers are entered
4. Ensures that only 12 numbers are entered

What does field size set to 11 do?

1. Ensures that only 11 numbers are entered
2. Ensures that only 9 numbers are entered
3. Ensures that only 10 numbers are entered
4. Ensures that only 12 numbers are entered

The above figure shows 6 validation rules to set for the exams 1-6
Which ones has been set do far

1. 1 & 3
2. 1&2
3. 2&3
4. 5&6

Refer to the figure above and
state the Validation Rule

Which Validation rule for the exams paper does the above rule apply to?

1. 1 & 2
2. 3 & 4
3. 5&6
4. None of the above

The End 

We hope that this help with with the revision on  Validation rule.

Write down at least 5 rules you can remember.