We will have 8 bookings in a day and will only accept advanced bookings. They can phone up or drop in and book here. When they book we will take their name, address, and car make and model

I believe that this system will greatly increase the efficiency of our organization and will make sure double bookings never happen.

End user requirements

My customer would like to do many things these are

• To print off a list of the cars that needs servicing in that day.
• To be able to enter customer names and addresses easily within a 4 minute time period
• To be able to easily keep track of the cars under their care
•  To be able

To make a system easy to use and not to have to train people to use it

My user is fairly computer literate but does not know how to use database software so I am going to create a switchboard to make things easier for him as on a switchboard you only have to click on a button to get to a form instead of going through the database menus.

Objectives

1. To be able to set up a number of filters that will filter all of the data and either an onscreen display of the filtered data.

2. To allow easy entry of data maybe using a switchboard for the customer information and information on the cars themselves.

3. To make a system that is easy to use for the average mechanic.

Resources

For this database to work my customer will need a few things if they do not already have them.  These include the following:

1. A basic computer
2. A mouse and keyboard
3. A black and white printer
4. Microsoft access 2000 for windows.

This will come to a maximum of £1000.

The computer will only have to have Microsoft 2000 so we will not need a huge processor or ram but a basic computer will do.

A mouse and a keyboard are obviously for navigating through the menus and entering data.

A black and white printer as we may want to see a copy of all the customers in case our system fails and we will not need a colour as there is not point as it will be more expensive.      

Software

The soft ware needed for my system to work is; a Microsoft operating system, Microsoft office 2000 which must include access 2000 and a decent anti-virus.  My system will not work to its full potential if these  

Design

This is a list of things that I need to design for my system to work:  

1. Customer table
2. Cars (linked to customer via ID) table
3. Repairs (linked to cars via number plate) table
4. Customer filter query
5. Repair history query
6. Booking form
7. Car form
8. Repair form
9. Switchboard

Inputs, Outputs and Processes

Inputs                

Outputs

PROCESSES