Yr+9+Database+3

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

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

Lesson Objectives

 * Apply your knowledge of queries to a database you have created
 * Create 3 queries

Starter (10 mins)
Folder sort On the label write
 * YOUR name
 * Year 9 ICT
 * Mrs Evans
 * Tuesday 3 & Wednesday 2

As work is returned - see if you need to add comments (SITS marking!) before putting it into your folder

Activity (10 mins)
Download the database from Google Classroom


 * Using a Google Documentt make a LIST of all the ** fields ** in the ** table ** of your classmates
 * Name this document ** DATABASE CLASSWORK **
 * Add your name in the ** header **

Class Activity (10 mins)
We will design some queries for our database

Task (15 mins)
Take screenshots of your queries in design view Add these to your **Database Classwork** document Crop your queries appropriately

Plenary (5 mins)
Define a keyword for this unit