L6 Applied GCE ICT - Mr. Jones February 2006

Your homework over the next three weeks is to set up a database system for a used car salesroom. Your database should be able to store data about the cars available and the customers who buy them. Your system should be able to do various searches to answer all possible customer enquiries about what cars are available at particular prices.

1) Set up a database to hold the data from these two data files: cars.csv and customers.csv.
2) Import the data into two tables which have been set up with suitable validation. You may need to add some extra fields for the primary keys and if the car has been sold or not.
3) Create a third table to link the two tables together when a customer buys a car.
4) Create screen input forms for each table.
5) Create all the necessary queries to search the database.
6) Create reports for each query.
7) Link everything together with a 'user friendly' switchboard menu system.

The deadline for this work is Monday 6 March 2006.