Author: afsheen

Filtering Data

Task 1

Now that all the information is in the database the producer would like to interview some of the contestants to see which one is the best one to take the final place.
Search 1
First of all, the producer would like to interview all those contestants that are over the age of 18.
Use Filter by Selection to do this, and write their names in the table below.

DO NOT REMOVE THE FILTER
Search 2
It is important to play as a team player as some of the tasks and activities require you to work as one. Could the producer have the list of those contestants that like to play as a team player.
Using Filter by Selection again, find all of the people who like to play as a team player. Write their surname and forenames below, or copy and paste from the database table.

DO NOT REMOVE THE FILTER

Search 3
After looking at the requirements that are needed for a contestant to succeed, the producer would like to see all those contestants that like to take part in activities AND don’t mind sharing with others. You will need to use the Advanced Filter for this task.
Names below, please – now you are getting closer…
DO NOT REMOVE THE FILTER

Search 4
By living and sharing with complete strangers, its important the contestants are able to look after themselves by cooking and cleaning. The producer would like to see all those that can do this.

DO NOT REMOVE THE FILTER

Search 5
Oh no….the producer has noti:ed that he does not have equal numbers of males and females. In fact he has more males than females. Please could the producer have the list of the female contestants

Name:

Congratulations!!!
You have the winner . The producer would like to thank you for your hard work!

Contestants Queries

Now that the winner has been selected, it is important that there are some reserve contestants. The producer would like you to send out relevant letters to some of these potential contestants. To do this you are going to create two queries (either simple or parameter).
Query 1: Find all those contestants that are male
Once the query has been created, print screen the answer in the space below, explain what it is showing and how you created it.
Query 2: Contestants that are male and over the age of 18
Once the queryhas been created, print screen the answer in the space below, explain what it is showing and how you created it.

Reports

The producer would like you to create reports from the queries you created so he can present them at the board meeting on Friday.
Report 1: Contestants that are male
Once the report has been created, print screen the answer in the space below, explain what it is showing and how you created it.
Report 2: Contestants that are male and over the age of 18
Once the report has been created, print screen the answer in the space below, explain what it is showing and how you created it.