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


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.


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.


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. The Entourage System: A Feasibility Study

    Email is another benefit that users will find particularly useful. It will allow for general communication of details of a role, negotiation of rates and contracts as well as the speedy transfer of scripts and other supporting materials as attachments.

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

    Fuller Change Description: Version 1 of the database does not have the facility for recording estimates given to customers, and or if they have been preceded or declined. The change requested is to develop an estimates log for customers, cost price, retail price, date estimate quoted and if customer has proceeded or declined.

  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. 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

  1. Fusions Acquisitions: Compaq - HP Merger.

    senior managers who left Texas Instruments and invested $1,000 each to form their own company. The first product was a portable personal computer, which is able to run all of the software being developed for the IBM PC. In January of 2000, Compaq was named "world leader" in Consumer PC Market according to IDC.

  2. Compare 2 types of business letter with those of 3 companies.

    Company/business logo. 2. Company/business address 3. Contact numbers 4. Headers and footers containing some business information. 5. Adequate space for orders 6. Devices used top aided completion of form e.g. tick boxes etc. 7. Details of where to send information back to 8. Details of how the information can be sent back Description of each document

  1. E-commerce in Business Companies of Bangladesh.

    "E-commerce is about doing business electronically and encompasses many diverse activities both in the business-to-business market and in the business-to consumer market. Activities include electronic trading of goods and service, online delivery of digital content, electronic fund transfer, electronic share trading, commercial auctions, collaborative design and engineering online sourcing, public procurement, direct consumer marketing and after- sales service.

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

    In 1960 it took over a chain of 212 stores in the north of England and added another 144 stores in 1964 and 1965. In 1968 the Victor Value chain became part of the company. Tesco introduced the concept of a superstore in 1967 when it opened a 90,000 square feet store in Westbury, Wiltshire.

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