What is LessonUp
Search
Channels
Log in
Register
‹
Return to search
Revision on Queries
Revision on Queries
Before you do this lesson ensure you understand
1. Create your tables
2. Data validation
3. Relationships
1 / 20
next
Slide 1:
Slide
Ilearningdeal@gmail.com
Upper Secondary (Key Stage 4)
BTEC
This lesson contains
20 slides
, with
interactive quizzes
and
text slides
.
Lesson duration is:
1 min
Start lesson
Save
Share
Print lesson
Items in this lesson
Revision on Queries
Before you do this lesson ensure you understand
1. Create your tables
2. Data validation
3. Relationships
Slide 1 - Slide
Slide 2 - Slide
Slide 3 - Slide
Read Question A in activity 3 and List with reference to the Relationship tables given above the tables you would use to complete query
Slide 4 - Open question
Slide 5 - Slide
To satisfy the Query in question A. What are the fields used?
Slide 6 - Open question
What are the search criteria for the Beeches?
Slide 7 - Open question
Slide 8 - Slide
What is the search Criteria for Lifeguards
Slide 9 - Open question
Slide 10 - Slide
Slide 11 - Slide
Name the table/s you would select for query 1-b
Slide 12 - Open question
Slide 13 - Open question
View the figure above and
explain how this is helping
to resolve query 2-b
Slide 14 - Mind map
Slide 15 - Slide
Slide 16 - Slide
Explain the above expression and
how was it achieved?
Slide 17 - Mind map
Slide 18 - Slide
Give an explanation of the
figure above
Slide 19 - Mind map
The End
Now go through the lesson and write down all the formulas you come across
Good Luck in your exams
Slide 20 - Slide
More lessons like this
Reports
January 2024
- Lesson with
13 slides
Ilearningdeal@gmail.com
Primary Education
Reports
September 2024
- Lesson with
13 slides
Ilearningdeal@gmail.com
Primary Education
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
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
Reports
September 2024
- Lesson with
13 slides
Ilearningdeal@gmail.com
Primary Education
Part A Exams Practice
September 2024
- Lesson with
14 slides
Ilearningdeal@gmail.com
Primary Education
Further Education (Key Stage 5)
Upper Secondary (Key Stage 4)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
Lower Secondary (Key Stage 3)
Part A Exams Practice
May 2023
- Lesson with
14 slides
Ilearningdeal@gmail.com
Primary Education
Further Education (Key Stage 5)
Upper Secondary (Key Stage 4)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
Lower Secondary (Key Stage 3)
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