Module 2.1
Task 5 - Queries


A.M.D.G.

A query is a request for specific information from a database. You use queries to view, change, and analyze data in different ways. For example, if you want to find all S2 students in Xavier house you would produce a query to find this information.
  • Open the Task 4 file
  • Click on the Query tool,

  • Choose to create a query by using the wizard

  • Select all fields to be included in the query

  • Choose a detail query, i.e. show every field of every record
  • Choose to Modify The Query Design and press Finish
  • Under Duration In Weeks enter the Criteria >6

  • Save this query, close this query design then open it to view all records matching the criteria.

Answer the following questions in your jotter.

1. How many records matched the criteria Duration In Weeks > 6?

2. If the criteria were changed to be Module Number<2, how many records would be displayed in the query?

3. For the Task 2 database, write criterion to find all Xavier students.

4. For the Task 2 database, write criterion to find all pupils with 2 or more brothers.