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

Devise a system that would help the owner of a car dealership to organise the business.

Extracts from this document...

Introduction

Task: Devise a system that would help the owner of a car dealership to organise the business. The aspects that the owner needs help with are: > A record of all stock has to be kept so that if a customer comes in and makes enquires about a specific car salesman can immediately inform them whether the dealership has such a car. > A record of customers has to be kept for further mailings about special offers. Analysis: I am computerising a car dealerships business system. The current user is using a paper file system and the problems which they are encountering are: > The quantity of paper > Lost records > Retrieving records i.e. being filed wrongly by human error > Archiving as it is time consuming > Sorting records is time consuming > It is a fixed system to retrieve files by so no files can be received easily outside the fixed system. > Capacity of files / space > No backup / copy > Don't know exactly what is in the files The system would require some specific features such as: > The user would need to be able to retrieve records by multiple keys and many keys > The user may need to find specific customer details > The user may need to inter link databases > The user may need to mail merge information to inform customers of offers > The user may nee monthly reports i.e. ...read more.

Middle

Whereas by visiting I would get limited information and the information would not be as complex. The current system used by the company has a number of different inputs and outputs but only one process. These are: INPUTS PROCESSES OUTPUTS 'Have you a blue Audi TT?' Look through index cards of paper filing system of Audi Make then TT then Blue Make of car Model of Car Colour of Car `Have you a Renault under �8000? ` Look through index cards of the paper filing system for Renaults and extracting all under �8000 Make of Car Model of Car Price of Car ` Have you an automatic car? ` Look through all the index cars of every make and extracting all the automatic cars Make of Car Model of Car Price of Car Gearbox of Car `Have you a manual Green Vauxhall under �10000? ` Look through the Vauxhall index cards and extracting all the manual cars then the blue then the ones under �10000 Make of Car Model of Car Gearbox of Car Colour of Car Price of Car `Have you a diesel Ford? ` Look through the Ford index cards and extract all the diesel fords Make of Car Model of Car Fuel type of Car `Have you a car under �13000 with a 1.4 litre engine? ` Look through all the index cards and extract all the cars under �130000 then extract the Cars with a 1.4 litre engine Make of Car Model of Car Price of Car Engine of Car This system ...read more.

Conclusion

L.Carvey. I could use a template to set out the letter in a more formal way. Put the company address into a header. 1. Print Screen of a query in Design View 1: Print Screen of the query proccess : Print Screen of the output of the query i.e. the results 2. Print Screen of design layout of a query 2: Print Screen of the output: The advantages of Layout 1 are: > Easy for the user to work as the parameter querys have instructions in th dialogue box > Easy to be used as a set query The disadvantages of Layout 1 are: > The parameter query limits the amount of things that can be searched for as they are designated in the design view > There would have to be many different queries for each table The advantages of Layout 2 are: > There is no limit to what the query can be used to search for > Only one query would have to be set up per table The disadvantages of Layout 2 are: > The user would have to edit the design view and if they were unfamilliar with databases this would be challenging. > There are no onscreen instructions to help the user. In my final database I have chosen to use parameter queries as they are more user friendly and enable the search to be more efficiently. There is also no risk of the database being edited as the design view is not used in the process of the query. Candidate Name: Louise Carvey Centre Name: Dr Challoners High School Candidate Number: 8172 Centre Number: 52207 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. Marked by a teacher

    Unit 4 Business Studies

    4 star(s)

    Managing the website also costs a lot of money as you to need to pay someone to sit at a computer and update the website and protect it from being hijacked or even virus being set up on it. If hackers do set up virus's on a new website which

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    Economical Feasibility The present computing facilities that are at the garage are adequate for the needs of the upgraded system that Cain Motors require. There's also an adequate power supply to run the system so no electrical points will need to be added.

  1. E-commerce in Business Companies of Bangladesh.

    Facilitate easier access to relevant market information, e.g. prevalent market prices of specific products in different locations. This would help the village people to have better bargaining capacity in selling their produce; f) Provide computer compose and printing facilities at a low cost in rural areas; g) Enable student contact with educational/research institutions and libraries abroad; h)

  2. In this coursework I need to produce a detailed business report on one medium-sized ...

    Less attention is paid to preventing errors and defects in the first place as they will be picked up later by the inspection system. A quality control system must ensure that there is regular contact between those departments that have a particular interest in quality matters.

  1. business plan and organise event

    do not want to have to many entries otherwise the tournament will drag on for to long and lose a lot of interest from the audience. I am going to use the 6th form because it will be like a small bonding session, there are a lot of new students

  2. Fusions Acquisitions: Compaq - HP Merger.

    In May, It was named as one of the "Top 25 Most Innovative Wireless Companies" by Unstrung, an influential publication in the wireless industry. In September, Compaq demonstrates first global storage network using Internet and Fibre Channel technologies. ( http://www.compaq.com) Its financial performance from 1999 to 2001 is as following.

  1. Investigating the current system at a new car company.

    Interviewing allows you to investigate the personal experience of someone using the system. You can then ask more questions based on the answer they give, which is not possible in a questionnaire, which leads to a more detailed answer. A disadvantage of using this method is that it is very

  2. Report for StGeorges School computer system

    Problems with current system Problems associated with the schools current IT infrastructure are that it frequently crashes hence why the school wants a quick upgrade or implementation of a new system. There are also many other problems with the current system which I have listed below with a description on

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