Car Sales
You are the owner of a successful car dealership and own many sales yards. You have heard about the many benefits of keeping a database and are wanting to keep a record of your car stock in Access. You need to have tables for:
- Cars
- Location (sales yards in different cities)
- Sales (cars sold)
There are relationships between Cars and Sales, and Cars and Location.
Task One: Make a database with these tables. You will need to think about what data might need to be stored on each of these tables for example: Car would probably have make, model and colour. Sales will probably have the name of the person sold to and the price sold for.
Task Two: Once you have set up the tables create 10 different cars, 5 different locations, and 15 sales (have cars sold at a variety of different prices $10k to $10 million). Wellington needs to be one of the locations.
Task Three: Create queries that do the following:
Task Four: Make reports for all of the above queries.
- Cars
- Location (sales yards in different cities)
- Sales (cars sold)
There are relationships between Cars and Sales, and Cars and Location.
Task One: Make a database with these tables. You will need to think about what data might need to be stored on each of these tables for example: Car would probably have make, model and colour. Sales will probably have the name of the person sold to and the price sold for.
Task Two: Once you have set up the tables create 10 different cars, 5 different locations, and 15 sales (have cars sold at a variety of different prices $10k to $10 million). Wellington needs to be one of the locations.
Task Three: Create queries that do the following:
- Show all sales for 1 million dollars or more (include the car make and model that was sold).
- Show all red cars
- Show all green cars
- Show all cars that are silver or black
- Show all red cars that are sold in Wellington
Task Four: Make reports for all of the above queries.
