Task 3

Task 3b Use the which cars kills database to generate reports based on queries to answer the following questions;

  • What are the average death and injury numbers for the categories small and small/medium cars?
  • What are the death and injury numbers for the two cars you selected in task one?
  • What percetage above and below the average figures are your cars?
  • What are the average death and injury numbers for cars made between 1980 and 1995 and from 1995 onwards

    For this assignment (4marks) you will need the following;

  • Produce a report showing your use of an offline databases.
  • Provide evidence of making four queries in access and provide printed reports suitably formatted of the four queries.

    What you need for your final report

    You will need to compare your chosen cars crash statistics against the average for small and small/medium cars class cars

    You will need to compare your chosen cars to cars from the range 1980 to 1995 and 1995 on and give a percentage figure for how much safer or more dangerous they are.

    comment on whether your cars are more or less dangerous than the class average and whether you think you cars are safer than cars in the two ranges.