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

My aim is to create a system to store on computer all the information a car garage needs including a full list of cars the garage has, along with details of these for example the colour of the car or the year of manufacture.

Extracts from this document...

Introduction

My aim is to create a system to store on computer all the information a car garage needs including a full list of cars the garage has, along with details of these for example the colour of the car or the year of manufacture. Also a list of customers names and addresses will be kept so that they can be informed of dates and times for repairs etc, or for news about offers. Also the customer will be able to search for the ideal specifications of a car for example a black ford with a CD player and alloys for under �5000. Having this system on computer would be far easier than having to do the same functions manually, it would also be far more efficient and up to date. Firstly I will have to create an easily accessible list of cars with there specific details, then I will have to find a way to search for a car with the specifications that the customer wants. ...read more.

Middle

Benefits Of Updating If both the records of cars and the customer's files were put onto computer then all records would be in the same place, clearing office space and helping towards the smoother running of the company, customer records would be accessible at the same time as looking at the car the garage has. Everything would be much easier faster and more accurate than the existing system. Saving our employees time and providing a better service for our customers than we are able to at present. Now instead of flicking through the card filing system, which is outdated and time consuming, to find a car now all employees will have to do is set up a search and the customer can enter his or her ideal car and it will give a list of choices on the screen of the computer in a matter of seconds. I will use a questionnaire to ask employees about change o the current system so they can use suggestions and comment about their own experiences with the current system. ...read more.

Conclusion

To set up a search function for customers to find their ideal car I will again use Microsoft access and the queries function on this program which will enable a customer to select the fields he requires for his car and then show him a list of compatible cars. Comparison table of Microsoft excel and Microsoft access Activity Microsoft Access Microsoft excel Searches Can be made easily using the 'Queries' Function of this program. You can 'filter' the information on the page to leave the information you want. Charts Charts of information can be formed with each specific area of information listed at the top and details listed below. Charts of information can be formed with each specific area of information listed at the top and details listed below. Mail Merge Mail merge is effective and easy to use. Not that effective, relatively easy to use. Graphs There is no facility to produce a graph. Graphs are easy to make using a wizard, or manually. This table shows the advantages and disadvantages of two choices of program, which may be suitable for the purpose they computer system must serve. ...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. Financial Model to help organise the year eleven prom

    I saw this as the only available rule that I could recognise. I limited the amount of characters you could enter into these cells. The limit was 30. Currency Validation This was used in the columns with the costs. I chose these because it would stop somebody entering insignificant numbers that were way out of reality such as �2000.00 etc.

  2. Creating a computer system for a video rental shop

    First Name Text(15) Surname Text(15) Address Text(50) Town Combo box Text(50) postcode Text(10) DOB Date/Time Rentals Attribute name Comments Data type and length Validation Customer ID Automatically incremented Long Integer Unique Primary Key Staff ID Automatically incremented Long Integer Unique Primary Key Video ID Automatically incremented Long Integer Unique Primary

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    This is costing the company a lot of money to pay for all these lost games. Sometimes when a staff member has messy hand writing then it is hard for anyone else use information that he/she has written down.

  2. The impact of ICT on a person with special/particular needs

    allows Sarah to work with it much easier than a non-touch technology. She doesn't have to press too hard due to the easy sensitivity and it's also adjustable so Sarah can find a setting that matches her needs. One of the most outstanding features of not just the iPhone 4

  1. Benefits of using my IT system in the Travel Agents.

    * First, you should go on Microsoft Access. * Then, you should go on Blank Database. * After that, you should Right Click on Table and click on Design View. * Furthermore, you click on Postcode. * Finally, you click on Input Mask and type in (LL0\ 0LL).

  2. Planning a system to handle school records.

    My aim is to create a system that allow user to save the record of individual student result with correct calculation. To fulfill my aim I need some information. The list of User Requirements will be used to identify as much of the information I will need, as possible, and

  1. I am creating and producing an online interactive guide presentation on Chelmsford to help ...

    My computers which people will view the presentation on will be stand alone computers. My recommendation would be to buy a system such as a Packard bell imedia 2218. This system hardware has a 160 GB hard drive. This particular system is a desktop personal computer and including in the

  2. Ict coursework full

    * Information about the number of each item left in stock must be given. * The system must be able to hold a large amount of data, incase new items are added. * New hardware or software should not have to be bought; all that will be needed is OpenOffice Calc (or Microsoft Excel if preferred by the user)

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