• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

Extracts from this document...


Background The other day I phoned up the local garage and made a booking, as there was a problem with my car. So I took it down the next day and there was a huge queue AT the office. When it was my turn I asked them what was going on and they said that they double booked the whole day and there were a lot of angry customers. As it was one of my friends who owned the garage he made a bet with me, he said that if I could open and run a more successful garage he would sign the deed of his garage over to me. So, me being a betting man I accepted this challenge and I now had to think of what I could do better than his garage to make mine more successful. I had already got 10 mechanics in mind so all I needed was a booking system. I thought of making a computer system. This idea struck me as quite reasonable so I stuck with it. So I got to thinking and I remembered my AS ICT course work and I thought of doing the same type of thing for my garage. ...read more.


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. ...read more.


A print out of all of our customers and their details All the data about the customer This is in case our computer crashes or we have a power cut and this would be our backup. Repair history of a certain car The owner of the car The car Previous problems and the date of these recorded problems This is so we can see if a car has a fault history with a certain part egg if the steering seems to go a lot. Look up a customer The customer and car info This is for when the work on the car has finished and we can let the owner know. PROCESSES Description What? Comments An on screen display of a to do list Booking=today's date Report layout This will be an onscreen display but it will also be able to be printed off if needed. Customers & details Print all customers and their details. This will be a backup incase the system crashes Look up customer Filter of all customers and their customer id's This is of when we want to contact our customers when their car has been finished. REPAIR HISTORY OF A CAR Filter the car itself and its repair history. This is to see if there has been a constant problem with the car. ?? ?? ?? ?? AS ICT Coursework 05/05/2007 Daniel Woodbridge 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    Allows you to get money out when you most need it, meaning you don't have to carry large amounts of money wherever you go and put yourself at risk * Printable receipts so you can have proof of withdrawal or deposit in-case a problem occurs * Need of pin number

  2. Financial Model to help organise the year eleven prom

    Therefore the prom committee wouldn't need Data capture forms and it would solve the palaver of long-winded sessions just to enter information. (Picture 1) (Picture 2) Validation Rules Although I had solved the problems with the formulas I still needed to limit the amount or what the user could enter.

  1. Designing a Car Mechanic's Database

    This database shows what spares are used by the garage, how commonly they are used and how much they are. * Specialist Garage List A garage can't always do a job if it doesn't have the right tools or men to do the job, so the garage needs to be

  2. Ict Powerpoint Coursework

    are also shown so the viewer of the presentation is aware of the brand image of the drinks available at S.A. Foods. Slide 6: This is a variety slide of chicken and salads which S.A. Foods have to offer, descriptive text is below the image so the viewers of the

  1. Database Coursework

    or if he doesn't have enough to pay for it in less than 20 seconds. * The user should easily be able to see which DVDs need to be replaced. This will happen as when a certain DVD is nearly overdue it will say in one of the forms.

  2. GCSE IT Coursework

    It will contain data used by the manager to pay staff, and order new stock. * Staff Names * Staff location * Staff Wages * Hours Staff have worked * Levels Of stock * Total Weekly Income * Total Weekly Expenditure The reason that I have split my project into

  1. Ict coursework full

    Also, the customers could fill out a search form on the company website, allowing them to search for information on any product with ease, from their own home. It is important that the stock information is updated regularly, if not connected to the spreadsheet of data.

  2. ICT Coursework (MarcoS)

    results - what did you find out after talking to the manager and end user about the system * How is the company currently using the system * Discuss the problems with the current system, and why changing it would be beneficial * Recommendations I've interviewed, first, the manager of Middle East Construction Company, Mr.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work