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

Fix the problem of the car company's storage problem, using either excel or access.

Extracts from this document...

Introduction

ANALYSIS The task is to fix the problem of the car company's storage problem, using either excel or access. To gather full information, I researched the problem by going round the company showrooms and asking relevant questions to both the salesman and the manager. I have tried to ask them questions about the weaknesses of their data storage and the strengths. I can then see what needs to be improved and make the database as effective as possible. The questions will also give me an insight of what is needed in the database and I will use the internet and books to answer the questions. I presented the software to them, Excel and Access. Excel Excel is a spreadsheet and has the ability to create, analyse and share data quickly. Excel can be used as a database but it has severe limitations and is more useful for maing graphs and calculations. Access Access is a powerful database for analysing and managing data. ...read more.

Middle

I personally know how to use access and am comfortable with it so I think it will be the best. 6) Currently, how many computers have you got? Unfortunately we only have 2. 7) Do you have access? Yes we do. To the salesmen/women 1) Do you think the current system is good? 2) Do you think the current system is safe? 3) Would you prefer a better storage system? 4) Are you comfortable with excel? 5) Are you comfortable with access? 6) Are you comfortable with lotus? 7) What are you most comfortable with? From the questions I asked, I have discovered the areas which need to be improved. From the questions I asked, I found out that the company had only 2 computers with but they did have access. The system they are currently using is using paper. The problem is that the data is not safe and takes long to access. The possible solutions were either using spreadsheets or a database. ...read more.

Conclusion

A database will be the best solution as they could add cars and take away cars which have been sold. Databases are an advantage because: * They allow large amounts of information to be stored in a relatively small space. * Information can be quickly and easily retrieved from the database (much quicker than searching a filing cabinet). * Data can be re-sorted very quickly into any desired sequence. * Information can be kept up-to-date with very little effort. My objectives had been set, set-up a simple database, containing data such and bhp and price, which all the users could use, so that the company could quickly sell their cars and make money. I had to make a database where data can easily be added and removed. The data will come from the actual car showroom. For the first set of cars, the details of the cars will be transferred from the paper into the database. Any new cars that come into the showroom, will have there details put on a specially designed form (in the design section). ...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 Software 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 Software essays

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    mark, followed by the cell range; this then allowed me to work between the two sheets. However, I only needed to do this in certain formulas e.g. the VLOOKUP table, but I did not have to do it during my IF statement as it allowed me to select a different sheet whilst I was creating the statement.

  2. AQA GCSE ICT Specification B

    Combo Box: Allows a limited selection of responses available to the user. It is quicker to find the chosen answer and prevents the user typing invalid data. Useful in details such as Colour and Payment type. More convenient than a list box as it takes up less room on the

  1. Database analysis of 'a video lending library'.

    And these are as follows: * Microsoft works: this is a very simple version of Microsoft access. Some of the requirements of this system are not possible to implement using works. * Microsoft access: this is a relational database, which will make it possible to link the tables needed for this database.

  2. Spreadsheet for a basketball company

    Word Processor * Graphs can be created easily * Easy access * Tables, borders and columns help readability * Cannot employ formulas * Tables do not respond due to lack of relational structure Manual * Does not necessitate electricity thus expenditure is minimized * Cannot be hacked or get effected

  1. Excel - Analyse

    * Lifespan is not bad for the price that is paid. The ball mouse seems like a bad choice because there are several disadvantages, I am planing to use wireless mouse because it removes the clutter of cables, and the latest ones are accurate because based on Optical technology.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    I will design a spreadsheet that will, be based on the study of the sales of every item the shop sells, or refunds having a column incorporating the amount of VAT, and telling the amount of Vat due. It will be very simple to use but as efficient as possible,

  1. GNVQ intermediate ict unit 4

    The background is striking and the information is clear to read. Consequently it might have been more accurate but not easy to read quickly by the scorer. For my system graph I will choose a variation of the bar chart used in the first graph.

  2. design an IT system for UTourEuro is a UK coach company who have bus ...

    * I will design a range of IT solutions to help the UTourEuro Company to run as a professional service saving time and money. * I will create a database which will contain the details of their tour customers which contains necessary information that the company may require (such as

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