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

ICT - making a database of used cars.

Extracts from this document...

Introduction

Introduction For my coursework, I am going to be making a database of used cars. The database is to help customers and staff to see what cars are available and specific information about them. Having a database file of the cars will prove beneficial to the staff as it would take less energy, time and money to search for cars than searching through paper based files. Paper based files can get lost or damaged much easier then electronic files. Electronic files can be copied, emailed, exported and backed up making it easier to organize for the business. This would be more efficient, because you can search specifically through the database to look for certain requirements to meet a customer's need. In a database, you can add, edit, save, query and print records. These features are very simple for staff to carry out and are very effective. Using a database allows you to avoid errors through validation rules and input masks. A database can store a large quantity of records, which is also efficient for the business because they can store loads of information about customers. With using a database, you can also make reports, visualisations of data (graphs and charts), tables and data entry forms. This is useful to a growing business that also has a chain of shops/outlets in the country, because data can be emailed easily and the information would be sent in reports and visualisations so managers won't have to organize meetings and waste money. ...read more.

Middle

14. Which Vauxhall cars do you have that have 5 or 4 doors? 15. Which cars do you sell that have 2 doors and are petrol? Sources For my coursework, I used a range of sources for my database. These sources are all varied slightly according to the details that were present. These are the 3 different sources I used: Motor Point - www.motorpoint.co.uk The Car Shop - www.carshop.co.uk NK Motor - www.nkmotors.co.uk (Sources are shown on the next three pages.) These sources seemed all accurate, and I decided on what field types I used based on the data present from these sources. I didn't use all the data from every one of these sources, as some seemed unnecessary or didn't include enough information. Example: One record only presented the make, litres and price and because it contained so little data, I did not use it. Some data, I did not copy down because I already had similar records present already: so I was looking for more of a variety. In a business, a car database will have numerous amounts of similar data for cars, but for my coursework I wanted to show as much variation as possible. Example: NK Motors: Vauxhall Zafira 1.8 Club Auto, 5 doors, Grey, �5495 The Car Shop: Vauxhall Zafira 1.8i Club Auto, 5 doors, Grey, �5995 These two records seem too similar, so I only used one of them. ...read more.

Conclusion

The required output is a report based on information that is processed from the database and you can't produce reports easily in Excel which is one of the first reasons I decided to use Access. It's easy to setup and you can manipulate it to make sure there are no mistakes. Multiple users can access database files which is more efficient for a business that has a lot of staff and requires updates of records. You can query a database which is relatively easier then filtering spreadsheets. You can also do more complex queries in Access then in Excel. You can find information quickly and efficiently which reduces time and money in a business. You can control what is inputted in each cell and create validation rules and error messages to assist user's i.e. staff. In Excel you can't control what you put in any cell, so if you make a mistake without realising, that mistake will remain unknown which can corrupt the data and cause there to be false records present. I personally prefer to use Access Database because of its easy user interface and setup. The data that the company will be using seems more compatible for this software as well, because some of the fields are Yes/No answers which can easily be inserted using a tick box. Overall, Excel spreadsheet does have its advantages, but compared to Access Database, it isn't as efficient as it could be. ?? ?? ?? ?? Project 1a 1 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    Sorts I sorted my holiday dates in order to make it easier to find holidays closer to the current date. Searches I did searches on holidays with cruises. By using a search, it was quicker and easier to find the holidays that catered for my specific holiday.

  2. Different types of technology How I use ICT at home and at school

    For someone young like me, easily influenced and quite impressionable, these sexual themes, drug-addled characters and general violence can desensitise me to all this. While I may have been against these, now I'm indifferent .Then it gets to the point where I see these themes everywhere that they start becoming my own urges and that's how television negatively influences you.

  1. GCSE Excel Project ICT

    The customer will repeat the process until he/she has made a final decision of choosing singular components to build up the computer; also, the accumulative total will be calculated. The customer can then input billing/address details and have their order archived (objective 1)

  2. Hardware & Software Requirements for Database

    It will mean that the computer will not work with slow speed as well and work efficiently. Each memory slot can contain 256 MB, 512 MB, 1 GB, or 2 GB of double data rate synchronous dynamic RAM .Whipps Cross Hospital is required to have a random access memory of

  1. Access Database

    is a field for the stock of the videos * Age group of videos I will check in my forms that there is a field for age group of videos Objectives What should happen? What actually happened? 1. Must have more than one table (entity)

  2. a level ict project

    causing a lot of visual pollution as space needs to be prepared constantly to accommodate more files meaning that space that could be used for a more productive purpose is lost. In addition, the old system does put a strain on the tangible as well intangible resources of the company.

  1. System requirements analysis

    for 2 weeks and then drag it down. Appointments : all processes 10-10-06 Drop-down menus D.O.B was not linked to the patients name We had to link everything by using the cell link $c$2.

  2. Smarts Leisure Park Database Booking System

    The password for the database is "dsr". This will make it secure to allow nobody to get into the database. With this password, only the user will be permitted to enter the database because they will know the password. Now when I open my database, it asks me for the password.

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