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


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.


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.


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. The aim of my project is to make the task of the allocation of ...

    - It will allow detailed examination of all characteristics of show, such as the catalogues, the bar, the type of show, and whether it was a professional performance or an amateur, and price it accordingly showing the overall cost.

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

    At first, I did not know that if you started your table range from a different column other than A, then the first column of the new range would still start at 1, so it took me a while to figure out this concept, as every time I kept doing

  1. AQA GCSE ICT Specification B

    B: Return to main menu C: Exit 8. View previous orders 9. (Go to 5.) 10. Dates entry form displayed 11. Enter start date 12. Enter end date 13. View Sales summary 14. Choose option: A: Print sales summary B: Return to main menu C: Exit Implementation Hardware and Software Required Hardware Required Acer Extensa 26+17" * Intel Celeron D 430 Processor * (1.8GHz, 800MHz FSB, 512KB Cache)

  2. Project 1a. ICT

    I know I have mentioned my target audience various times throughout the project but I have not explained how I will keep this target audience in mind so I can make my project suit the needs.

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

    The 'CUSTOMER', the 'VIDEO' and the 'ISSUE AND RETURN' tables in the database will contain the following information taken from Mr. Hussaini, but first I am going to use the information about the customers only, which is as follows: * Name * Contact number * Address * Date of entry * Email address * Advance * The special id number.

  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

    * Not able to write on a CD. * It can read a large amount of data * The CD's are portable * Fast Access, the read speeds are above 48x. RAM To run Excel the computer requires Random Access Memory, so it can create temporary files which allow the programs to run smoothly.

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

    This invoice then must be transferred manually to a file, which is hence placed in among all the other hundred of files and later sorted in order of the date. This can often by very time consuming as well as irritating.

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