Qu'est-ce que LessonUp
Rechercher
Canaux
Connectez-vous
S'inscrire
‹
Revenir à la recherche
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
suivant
Slide 1:
Diapositive
Cette leçon contient
21 diapositives
, avec
quiz interactifs
et
diapositives de texte
.
Commencer la leçon
Partager
Imprimer la leçon
Éléments de cette leçon
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 - Diapositive
Slide 2 - Diapositive
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 - Diapositive
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 - Question ouverte
What view must you be in to edit Validation rule?
Slide 10 - Question ouverte
Slide 11 - Diapositive
Slide 12 - Diapositive
Name the Four Validation rules that is set
Slide 13 - Question ouverte
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 - Diapositive
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 - Diapositive
Refer to the figure above and
state the Validation Rule
Slide 19 - Carte mentale
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 - Diapositive
Plus de leçons comme celle-ci
Unit 2 -June 22
Septembre 2024
- Leçon avec
22 diapositives
Ilearningdeal@gmail.com
Special Education
Mastering Validation and Redundancy in Spreadsheets
Février 2024
- Leçon avec
13 diapositives
Unit 2 - Paper 1 Activity 1
Septembre 2024
- Leçon avec
29 diapositives
Computing ICT
Further Education (Key Stage 5)
Functions
Mai 2020
- Leçon avec
15 diapositives
Mathematics
Primary Education
Age 10
Unit 2 - Paper 1 Activity 1
Avril 2023
- Leçon avec
25 diapositives
Ilearningdeal@gmail.com
Primary Education
Creating Tables
Septembre 2024
- Leçon avec
12 diapositives
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
Part A Exams Practice
Septembre 2024
- Leçon avec
16 diapositives
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
BTEC
Part A Exams Practice
Septembre 2024
- Leçon avec
16 diapositives
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
BTEC