• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  • Level: GCSE
  • Subject: ICT
  • Word count: 2720

Mikes garage has been running for almost ten years now. Based in Iford Essex, it is a small business in comparison to most other garages. Installing a system.

Extracts from this document...

Introduction

ANALYSIS INTRODUCTION Mikes garage has been running for almost ten years now. Based in Iford Essex, it is a small business in comparison to most other garages. The garage provides a number of services for customers. These services include tyre change, oil change, engine servicing, MOTs and engine tune-ups. The garage hasn't really changed all that much since it was set up in early 1993. There has been a general increase in the number of mechanics employed by Mike. This was originally three but has increased to a dozen mechanics, each working a different shift. Although small in comparison to other garage businesses, Mikes garage seems to be growing at a fairly slow but steady rate. At present the garage employees a dozen mechanics, with Mike helping out on occasions. Recently Mike has introduced a number of new services, including a car washing and engine changing services. This introduction of new services was due to the large client demand in recent months. Since the business was set up new tools and machinery have been introduced. This recent investment was to replace old worn out tools. In recent years Mike has given some thought to the possibilities of future expansion. He is currently considering purchasing a garage within the local area. This will mean that Mike will have to employ more mechanics to man that branch. Currently Mike handles the client appointment making in the present garage. If he decides to purchase this new garage then he will have to employ someone to handle any inquires that may arise by clients at that branch. ...read more.

Middle

When a job takes longer than usual or if it is finished earlier than usual, then the client's details are used to contact them in order to inform them. A copy of the appointment details, including the day and time of the appointment is made for the customer as a reference for them to keep. INTERVIEW QUESTIONS AND ANSWERS 1) How are appointments for services recorded? A customer would call us up and I would take their details, writing them in the appointment book kept on my table. Depending on the day they would like and given that that day and time is free, they will be allocated a time slot for their service. Of course this will depend on whether we do that particular service. 2) How would you rate the importance of your booking system? Without a way of keeping a record a our clients details as well as their appointment dates there is no way that the garage would function. So I would say the appointment system is the key to the business running. 3) How regularly do you back up the data stored? We don't really back up information stored in the book. 4) Given that you don't back up the data stored in the book, what would be the effect to the business if the appointment book was damaged, lost, stolen or destroyed? Well it's like I said if the system should fail at any time there is no way of knowing which client is booked in. So if we get a number of clients turning up we won't know who is first to be serviced. ...read more.

Conclusion

More advanced features include advanced templates which may include field names for user data entry, selective mail merge, editing menu bar to include special/restricted functions. SOLUTION 3 The third solution was to construct the system on Microsoft Access. This is a database application, which allows you to construct databases. The basic features of access include relational tables with primary & secondary keys, creation of reports and data entry forms. However it also has some advanced features. These include complex queries based on multiple tables, validation checks, tables and figures imported from word processor and spreadsheet, summary reports, selection boxes on forms and field macros. FINAL SOLUTION Given all three options, I have selected option three. Microsoft Access will allow me to create a system, which will meet the requirements of the new system as well as a number of other objectives. The reports feature will allow me to construct reports regarding jobs, which require more time. The use of macros will allow me to make the system easy for the user to move around with in the system. The forms feature will allow the user to enter data into the system with the greatest of ease. The validation checks will also allow me to make the system easy for the user to use. ENTITY RELATIONSHIP DIAGRAMS END USER LITERACY Mike has never been into computers. As a mechanic he never really came into contact with them. From the interview with him, he claims that he has never really used them. This will mean that the system that I will design and construct will have to be simple enough for him to use easily. ICT SPECIFICATION YASSIR ELAMIN ICT SPECIFICATION YASSIR ELAMIN ICT SPECIFICATION YASSIR ELAMIN ICT SPECIFICATION YASSIR ELAMIN ...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. Different types of technology How I use ICT at home and at school

    thus preventing us from procrastinating in school as we'd usually not have space to download games and such with all our work in here. People are discouraged to put unknown files into their computer account and are warned of this explicitly.

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

    Without the internet, a computer's abilities are quite limited. But to be able to get internet, Sarah has to pay a monthly bill (depending on the ISP) and the price can get quite steep. This also adds on to her outstanding bill and while Sarah tries to spend as less as she can, the internet is quite important to her and she is obligated to pay the price.

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

    * Furthermore, you click on Gender. * Additionally, you click on Validation Rule and type in ("MALE" Or "FEMALE"). * Finally, click on Validation Text and type in (Enter "MALE" or "FEMALE" only please!). Creating Queries * First, you should go on Microsoft Access. * Then, you should go on Blank Database.

  2. I am now going to analyse my clients current system in order to get ...

    Disadvantages: * The form I choose might not have any problems. * I might not be able to spot frequent problems, as that document might not contain any. Overall, I have decided that I am going to choose two of the above-mentioned investigation techniques.

  1. Planning a system to handle school records.

    * Every part of the system must be accessible to the user with minimum fuss. > Quantitative objective: * The system should able to store the data of ten course and 15 children per class. * The data must be record and available to view with in 10 second.

  2. IT investigative process

    The Amazon region: Known for its incredible biodiversity, just one square kilometer of jungle houses a greater variety of species than the whole of Europe. The main tourist attractions in the country are: Old Providence and Santa Catalina, San Andres, Caparguna and Sapzurro, Bahia Solano, Nuqui, Quibdo, Leticia, and

  1. ICT COURSE

    Here is a explanation of the ICT tools used by Orchard Orthodontics to do this: Fax machine: Is used by people to send details to other people just does the same job as email it enable people to send anything which is on a piece of paper to other people

  2. Hospital Information System

    4 (40%) 10 The study reveals that the overall opinion of the managers, doctors and patients about the existing system in the hospital is satisfactory (80%) and 20% feel that the system is poor. Table - 2 Role of existing information system in Manager's responses regarding the existing system Strongly

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