7+database+4

=Databases Lesson 4=

REMEMBER TO LOGON TO GOOGLE CLASSROOM!

Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6



Starter (10 mins)
Click the image to go to the word search

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 date

Task (10 mins)
In your database classwork document on Google Drive - write a list of the queries you will create

Task (20 mins)
Create and save your queries
 * 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)
Describe how criteria are used to perform a query