Do it now activity

1. Do it now activity • Activity: Answer these questions, referring to the spreadsheet on Slide 2. • How many people are called Neil? • How many people have medical needs? • Who is the oldest person? • How many people are vegetarians? • Who has medical needs and a special diet? • How many people were born in 1990? • If the people were sorted by their surname, who would be the first on the list? • How many people will be on the coach tour, not including the driver? • How many females are there? • Who was the first person to book the trip? • (Hint: this relates to their booking number.)

2. When you are ready, left-click to go to the next slide.

3. Homework Finding the killer Write a list of bullet points describing each step that you took to find the murderer. Make sure you use key terms correctly Due:

4. Learning AIM Apply filters to find specific information

5. Learning objectives I can use a filter to find a murderer

6. Learning objectives I can use a filter to find a murderer By the end of the lesson you will be able to

7. Learning objectives I can use a filter to find a murderer Solving the crime • Detective Turner would like to thank you for creating the database for him. He has now asked one of his police officers to enter all the suspects' details into the database. • By the end of this tutorial you will be able to: • Search the database using filters to find the murderer • Create parameter queries to find specific information FiltersData Queries DatabaseReports Interrogate

8. Learning objectives I can use a filter to find a murderer Find your suspect Download the suspect_database file You will need to watch the following tutorials to find the killer: Basic filter Advanced filter Parameter query IF you can download it, download the spreadsheet version and watch the video to import it into Access and then follow the steps yourself. FiltersData Queries DatabaseReports Interrogate

9. Learning objectives I can use a filter to find a murderer Filtering In order to find some of the information you need, you will have to filter using two different fields – in this case, to find people who were in the Maths and English departments. To do this you need to use the Advanced Filter function. You can see how to do this by watching advanced filter. FiltersData Queries DatabaseReports Interrogate

10. Learning objectives I can use a filter to find a murderer Advanced Filter Now it's your turn. Use the 'Advanced Filter' function to find out who were in the English and Maths departments. You now need to add the field that you want to search to the grid. The grid should already have the fields 'Shoe Size' and 'Hair Colour'. This is because you have already searched using these fields. Click in the field next to 'Hair Colour' and add the field 'Alibi' to your grid using the dropdown menu. FiltersData Queries DatabaseReports Interrogate

11. Learning objectives I can use a filter to find a murderer Advanced Filter FiltersData Queries DatabaseReports Interrogate

12. Learning objectives I can use a filter to find a murderer Advanced Filter Next, enter 'Maths Department' and 'English Department' in the 'Criteria' section (see below). Now apply the 'Advanced Filter' to your database. Don't forget to write down the names of the suspects on find the killer.doc under Search 3. FiltersData Queries DatabaseReports Interrogate

13. Learning objectives I can use a filter to find a murderer The murderer has now been arrested and Detective Turner needs to track down witnesses to appear in court. What information do you think he will need? Try to find a specific person by their surname (for example, Hirst). Did it work? What is the best way to get the information Detective Turner needs? Detective Turner would like you to create a method of searching for people by their surname so that he can find the correct witness details ready for court. You will need to create a parameter query for this. FiltersData Queries DatabaseReports Interrogate

14. Learning objectives I can use a filter to find a murderer Parameter queries .. allow you to enter different criteria each time for the same search. So, if you need to be able to find people by surname, then a parameter query is ideal. Watch parameter query .swf to find out how to do this. Now it's your turn. To create a parameter query that will find people using their surname you will need to include the following fields in your database: 'Surname', 'Forename', 'House number', 'Street', 'Town', 'Telephone number'. Now test that it works by running the query and entering the surname 'Johnson'. Save the query as Surname. This means you will be able to use the query again and again. FiltersData Queries DatabaseReports Interrogate

15. Learning objectives I can create a database which is fit for purpose Round it up!! As a class, discuss the difference between filtering for information and using a query. Which method do you think is better? Would you have been able to find the murderer using a series of queries? Filters are better at selecting multiple criteria while queries are better at finding objects or people based on one or two different criteria FiltersData Queries DatabaseReports Interrogate

16. Learning objectives I can use a filter to find a murderer I can …