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

    As more and more people are recommending them to other this is a form of advertising so this goes onto help them achieve their aim of a service which goes on to help the customer in their everyday life as they are offering quality products; but Cars Direct do hold

  2. E-commerce in Business Companies of Bangladesh.

    A better understanding of the potential benefits of e-commerce by the policy makers and bureaucrats is essential for speedy implementation and further reforms. 12. Advantages of E-Commerce : Many established companies still think of e-commerce in terms of defense rather than offense.

  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. In this coursework I need to produce a detailed business report on one medium-sized ...

    It helps firms to do the job properly the first time, because the scheme is designed to prevent failures rather than detecting errors once they have occurred. In this way a quality assurance scheme (QAS) differs radically from quality control systems which involve inspection procedures at various stages of production.

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

    time consuming and yet again some answers may be inaccurate like in the questionnaire although it seems to be more effective than the questionnaire. Another method of investigation is taking part in a group discussion. This is where all members of staff sit together with me and we will discuss the current system.

  2. Report for StGeorges School computer system

    the organisation Office 2003 Suite Offers all the software applications that the users will need to operate the system - will also be used by administration for spreadsheets and databases Windows XP Pro, to be installed/used on each machine on the network allows the users to perform various tasks, Dependent upon a Volume License is purchased from a Microsoft dealer.

  1. MG Rover. Latest news shows that the car company, MG Rover will be taken ...

    They may also be against the fact that there car has not been made in Britain; therefore it can only be fixed if it was sent back to the manufacturers in China. Reports have shown that there are three types of cars that they will introduce under the new manufacturers 'Shanghai Automotive'.

  2. The Entourage System: A Feasibility Study

    able to save the results returned from their searches in their private filing space, for later review without having to perform another search. Benefit of the Search facility to the Users Simple Search Facility * Allows the casting director to search for a wide range of Actors that meets specified criteria used as the keyword in the search.

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