How to do a Query

Database

• Copy the Cars2 Database from ICT_STUD/GCSE Short Course/Mr C Cars Database

Example : Find all the Red Cars

1 Click on the Query TAB

Click Here

2 Double Click on ‘Create Query in Design View’

Double Click Here

3 Choose the Table

Double Click on

Cars

4 Close the ‘Show Table’ Dialogue Box

Click on the ‘Close’

Button

5 Rearrange the ‘Query’ Window to look like below

6 Select Fields

Double Click on each of the fields in turn (Car Reg, Make,Model, Colour,

Engine Size, Seats,Price so they appear in the ‘table’ below

7 Choose Selection

We want ‘Red’ cars, so type in Red here.

8 Save Query

Click on the ‘Save’ Icon

Then type in a suitable name into the dialogue box

9 Close Design View

Click Here

10 Test Query

Double Click on ‘Red Cars’ to Test

11 Happy Days

Hopefully we can only see Red cars

12 An ‘AND’ Query : Silver Cars Greater than 1300cc

13 An ‘OR’ Query : Ford or Vauxhall Cars

Questions 1

1. Nissan (NI) Cars

2. Cars with Leather Seats (L)

3. Cars more than 1300cc

4. Cars costing less than £4000

5. Cars with 3 Doors

6. Saloon (S) Cars

7. Cars with an ‘Automatic’ Gearbox

Questions 2 (AND)

8. Ford Cars (FO) with Leather Seats (L)

9. Red Cars with 3 doors

10.Renault (RE) cars costing more than £7500

11.Silver Cars with an ‘Automatic’ Gear Box

12.Cars with an Engine greater than 1600cc and Leather Seats

13.Silver Micras

Questions 3 (OR)

14.Cars with Leather (L) or Velour (V) Seats15.Silver or Blue Cars16.Ka or Micra cars17.Nissan (NI) or Renault (RE) cars18.4 or 5 door cars19.Cars registered in 2005 or 200620.Cars registered before 2005 or costing

less than £4000