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

    certain location which happens by sending the footage to the corresponding office it is connected to where it is viewed by the security of that particular place. For example, they could be cameras showing footage of a school, a supermarket or any other office environments.

  2. ICT car insurance quotation System Coursework

    Another possible explanation for a change in the system would be due to the makes of cars being added or change to the UK market. A third possibly explanation could be that the age category may have to be changed to an increase in the minimum age for a teenager

  1. OCR Nationals Unit 21 - Task 8

    Background I decided to make my background to be a picture of space, as what is being offered in the banner is something to do with space. I looked for a picture using google.co.uk, and when I found one I saved it into my Unit 21 folder.

  2. Smarts Leisure Park Database Booking System

    buttons for the user to press making the menu simple to use. Creating the Database Introduction Having completed my design of the database system for SLP I am now going to create the database using MS Access. I will explain what I am doing and I will also provide screenshots for this.

  1. System requirements analysis

    An alternative software package that could have been used is Microsoft Works. Microsoft Works in an office Suite that is available from the Microsoft Corporation, hence the name being Microsoft Works. It is considered to be a smaller and a cheaper alternative to the Microsoft Office Suite.

  2. Financial Model to help organise the year eleven prom

    Changing one firm of a cost each time. This is of course assuming there is going to be 200 people coming. An expensive way of solving the problem would be to use a specialist program that would work out the sums automatically. However the program would have to be designed which costs a lot of money.

  1. Ict Powerpoint Coursework

    The PowerPoint Presentation would be easy and simple to show to everyone as it is mainly used for advertising purposes. Also they're will be administrator accounts to help answer user questions, update the PowerPoint Presentation etc... Information of the products would be placed on the information slide on the presentation.

  2. Creating a computer system for a mobile phone shop.

    * All the people with a specific feature (games, wap etc.) These reports need to professional looking and show all the data required in a presentable format. Design of the ICT system Within my database, there will be three tables :- tblCustomers - the table containing the information about my customers, phones are not mentioned in this table.

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