Lesson 4 - Searching your database

Keywords - data, query, criteria, results, information

Starter

Q&A on favourite meals / food diary from students and how you would find out the details from the database.

Main Activity

Demonstration of a query in the access database.  In pairs, students determine search criteria for five different queries as examples.  Pupils create these queries in their databases and then move on to search for their favourite meal / food diary meals. [Note: these queries can be based on Science nutritional criteria or Geography food miles criteria too.]

Students screen print their queries as evidence.

Plenary

Students to be asked to give examples of their searches – what they looked for and what results they found.  Why is it useful to have the query facility in a database? 

Homework

Students to research menus from local restaurants – the healthy and the not so healthy!