Year 9 - Database – Part Two

Objective

To be able to extract information from a database that is suitable for purpose.

Starter

Complete this activity as a class to find out how you can use query operators to refine your teenagers query.

Teenagers Query

Use query operators to refine your teenagers query.

Queries Two and Three

Adam still needs you to create lists of recommended mobile phones for the following user types:

Business Users
Senior Citizens

Use the skills you have learnt to create a query for each user type.

Reports

Reports offer an excellent way of presenting the information from queries.

Create a report for each of your queries.

You can use the tutorial to help you.

Test Yourself

Test your knowledge of query operators by completing this activity.