• 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. AQA GCSE ICT Specification B

    This allows information to be readily on hand and prevents human error in calculating totals. 12. Each button on the main menu must have a simple explanation. Allows for faster usability and simplicity. Test Plan Criterion to test Test I.D.

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    Advanced Macros (Auto_Open, Auto_Close, print) Auto_Open Above shows the result of the Auto_Open macro. It means that a dialogue box, displaying a welcome message, will always appear when the user opens the spreadsheet. I created this macro in visual basic, a section of which is shown below.

  1. Evaluating a relational database solution

    forms or queries you want to use, and I could decide where I wanted the button to take me to e.g. next record, a welcome page. It was easy to see how outputs would look like with the 'design view' in Access.

  2. The aim of my project is to make the task of the allocation of ...

    To rectify this we can simply click on the money symbol in the toolbar, which will convert the number to the appropriate output. Finished solution H Spreadsheet showing data See following page. Spreadsheet showing formulas See following page. Macro code Sub Button2_Click()

  1. A Program for a Cinema Manager

    The initial menu is going to be in the web page form to make it even easier. Once I have implemented the spreadsheet, I am sure it will be very useful to the manager and will have a positive affect on the business and will help to run it more smoothly.

  2. GNVQ intermediate ict unit 4

    3- Insert memory stick with system on it. 4- In Excel go File- Open and go to the "Look in" box choose the drive that has the "system" work on it and click on the file to open it. 5- Insert the name of the event where it prompts you on the Interface sheet.

  1. Database - The Problem, the sloution

    Data power can link pages together by linking the pages, this means that one page can directly benefit another and change all the details. Also when fields are changed you can organise the database so that it automatically does things for you.

  2. Database design for a games shop.

    name Text Game information Address Text Home address Town Text Town of residence postcode text Postcode of member Contact number text Phone number Field name Data type description validation Membership id Number A foreign key from the members table. This makes sure that no errors are made.

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