• 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)

    Parents can look up education and find the best schools to go to in the area for their children using the site. They can find which school would fit their exact location and needs. This is extremely useful and helpful to children as parents can choose which school would suit their child best.

  2. Financial Model to help organise the year eleven prom

    I done this with ease using Validation rules. However on the "user input" page the information mostly came from the "raw data" page. So the only limitations I could achieve on the page were only allowing currency on the profit and prices.

  1. ICT Coursework (MarcoS)

    balance of August is displayed 111 Formula in the cell F70 in the Profit & Loss sheet The tot. balance of September is displayed 112 Formula in the cell F71 in the Profit & Loss sheet The tot. balance of October is displayed 113 Formula in the cell F72 in the Profit & Loss sheet The tot.

  2. Ict Powerpoint Coursework

    the users' opinions and what can be improved as well as what is up to standards. The questions were thought by me and some work colleagues as the whole PowerPoint Slideshow is based on everyone's opinions and not just my own personal opinion.

  1. Database Coursework

    Do you advertise? If so, then how? A) Yes, we do advertise. At first, our main form of advertising was by sending pamphlets and posters through the post to different homes, and sticking posters around Ilford. But now, we are able to advertise through the radio and television. Q)

  2. GCSE IT Coursework

    it will save time because the staff won't need to remember all the prices of all the products on sale. I also suggested a swipe card reader after asking them if they had many people asking to pay by credit card as it becomes inconvenient for the customer if they have any other form of payment.

  1. Ict coursework full

    Appropriate software identified The computer will run Ubuntu Linux Hardy Heron, which is a free operating system, and OpenOffice Calc comes already installed. This seems to be a very good idea, because it is saving Mr. Burnquest roughly �340. Data required The customers will have to give the staff information,

  2. OCR Nationals Unit 21 - Task 8

    I have put 'Background Picture' at the bottom as I want it behind all the other layers as it will contain the background. Their is no point of having a background at the front. I added each layer by clicking on the little plus sign at the bottom on the left, before naming them like I did.

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