Wednesday 15 January 2014

#7y6 Unit1 How Active Am I? - Database Lesson 2



  • LO - To understand what a query and a criteria is
  • LO - Learn how create a query using Microsoft Access
  • OUTCOME - You will have used queries to find the number one suspect



  • Log on 

  • Complete the DATABASE KEYWORD SCRAMBLE sheet


  • 5 out of 5 = GREEN EREF


  • 5 out of 5 + extension task = GOLD EREF



  • Human Database
    • What is a query?
    • What is a criteria?
    • Have you heard these words any where before?
    • Lets query the class!



  • Task 1 
    • Open your WILDERN CRIMINAL DATABASE in MICROSOFT ACCESS
    • Open your WILDERN CRIMINAL DATABASE WORKSHEET in MICROSOFT PUBLISHER


  • Task 2
    • Using the worksheet create a query to help the police find the number one suspect

  • Task 3
    • Make sure that all work pages of your worksheet are filled in and that your name is at the top then print out your work and put it in your folder

  • EXTENSION TASK
    • Explain how you carried out a query and how this search tool could help the police


  • THINK..PAIR..SHARE
    • THINK - what have your learnt in today's lesson?
    • PAIR - Discuss what you have learnt with your partner
    • SHARE - be prepared to share with the class



  • Task 4 in your blue home study booklet
  • Due in Thursday 23rd January