How to do a Query

1. How to do a Query

2. Database • Copy the Cars2 Database from ICT_STUD/GCSE Short Course/Mr C Cars Database Example : Find all the Red Cars

3. 1 Click on the Query TAB Click Here

4. 2 Double Click on ‘Create Query in Design View’ Double Click Here

5. 3 Choose the Table Double Click on Cars

6. 4 Close the ‘Show Table’ Dialogue Box Click on the ‘Close’ Button

7. 5 Rearrange the ‘Query’ Window to look like below

8. 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

9. 7 Choose Selection We want ‘Red’ cars, so type in Red here.

10. 8 Save Query Then type in a suitable name into the dialogue box Click on the ‘Save’ Icon

11. 9 Close Design View Click Here

12. 10 Test Query Double Click on ‘Red Cars’ to Test

13. 11 Happy Days Hopefully we can only see Red cars

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

15. 13 An ‘OR’ Query : Ford or Vauxhall Cars

16. Questions 1 • Nissan (NI) Cars • Cars with Leather Seats (L) • Cars more than 1300cc • Cars costing less than £4000 • Cars with 3 Doors • Saloon (S) Cars • Cars with an ‘Automatic’ Gearbox

17. Questions 2 (AND) • Ford Cars (FO) with Leather Seats (L) • Red Cars with 3 doors • Renault (RE) cars costing more than £7500 • Silver Cars with an ‘Automatic’ Gear Box • Cars with an Engine greater than 1600cc and Leather Seats • Silver Micras

18. Questions 3 (OR) • Cars with Leather (L) or Velour (V) Seats • Silver or Blue Cars • Ka or Micra cars • Nissan (NI) or Renault (RE) cars • 4 or 5 door cars • Cars registered in 2005 or 2006 • Cars registered before 2005 or costing less than £4000