S1 ADMINISTRATION AND IT

CAR LIST

​The card index system is getting quite difficult to search and sort so you need to make a computerised list of your models.
You should use Microsoft Excel (easier) or Access (harder) to make this computerised list.

Use the following field headings :

• Car make
• Car model
• Colour
• Top speed (choose your own top speed - between 220 and 270 mph)

Then start to enter the data from the car information cards you made earlier.

​click here to see a list of supercar speeds 

1) One of the car manufacturers want to display more cars - you need to add these to the list :

• Ferrari F40 -Red - Top speed 192 mph
• Ford Mustang - Blue - Top speed 142 mph

2) The car show organisers want the list of cars sorted by

• Make in alphabetical order A - Z
• Top speed, fastest to slowest

​
3) The designers want to know the following :

• Which cars are red
• Which cars are made by Ferrari
• Which cars are red and made by Ferrari
• Which cars have a top speed greater than 160 mph

4) One of the car manufacturers (you choose) can't come - delete this entry.