Yr+9+Database+4

=Databases - Lesson 4= REMEMBER TO LOGON TO GOOGLE CLASSROOM!

Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Less

Lesson Objectives

 * Understand how to search a database
 * Be able to create a search/query with multiple criteria
 * Create 3 queries

Success Criteria
(5-6) Be able to describe how criteria are used to perform a query (5-6) Define a query with multiple criteria (4-5) Define a query with single criteira ==

==

Starter (10 mins)
Click the image to go to the crossword

Homework
Last weeks homework has been marked on Google Classroom - this weeks homework is to use your keywords spreadsheet and learn at least 5 keywords for this unit. I have added an up to date copy on Google Classroom for anyone whose own is not up to day ==

== **Task (35 mins)** Continue creating the queries we started last lesson
 * 1) Create the first query
 * 2) Take screenshots of your query in design view
 * 3) Add to your **Database Classwork** document
 * 4) Crop your query appropriately
 * 5) RUN your query
 * 6) Take a screenshot of the results
 * 7) Add to your **Database Classwor**k document
 * 8) Crop the query appropriately
 * 9) Repeat for your other queries

Extension Task
Create some extra queries

Plenary (5 mins)
Define a keyword for this unit