What is LessonUp
Search
Channels
Log in
Register
‹
Return to search
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
.
Start lesson
Save
Share
Print lesson
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
More lessons like this
Unit 2 -June 22
October 2023
- Lesson with
22 slides
Ilearningdeal@gmail.com
Special Education
Mastering Validation and Redundancy in Spreadsheets
February 2024
- Lesson with
13 slides
Unit 2 - Paper 1 Activity 1
September 2024
- Lesson with
25 slides
Ilearningdeal@gmail.com
Primary Education
Functions
May 2020
- Lesson with
15 slides
Mathematics
Primary Education
Age 10
Unit 2 - Paper 1 Activity 1
September 2024
- Lesson with
29 slides
Computing ICT
Further Education (Key Stage 5)
Part A Exams Practice
September 2024
- Lesson with
16 slides
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
Creating Tables
September 2024
- Lesson with
12 slides
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
Creating Tables
January 2024
- Lesson with
12 slides
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