• 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. GCSE Excel Project ICT

    49 secs* Data collection (Data required, source, and method of collection) Products The only data needed for the invoice is the product names some detail (specifications) of the product and the price. This will be obtained from Alex, as some of the products he offers he makes himself, which runs under the name 'WARLORDTF'.

  1. Hardware & Software Requirements for Database

    at least 512MB on each computer to run my database and queries on my database effectively. All the computers contains a certain amount of RAM in there PC's but to compress the memory it is quiet expensive according to the memory size, the higher the memory the expensive it is.

  2. a level ict project

    a long time before their ability can provide maximum returns by system, plus there will be increased costs of training staff up to this standard. Moreover, even though a majority of tasks are automated, the system is still susceptible to human errors during the input stage of the system when information is keyed in.

  1. Access Database

    a field called Stock of Videos There was not the field, which I wanted 10. Age group of videos There should be a field called Age group of videos in video form There was the field, which I wanted Testing Table 11.

  2. System requirements analysis

    detail what action you need to take, and how effective the action was once taken. Date Task Problem Identified Solution Front End 29-09-06 Gridlines On menus page, there are gridlines present. Click on 'tools', and underneath the section that says 'window options' click on the tick-box that says GRIDLINES to unmark it.

  1. ICT car insurance quotation System Coursework

    cell, I typed in this code below into the Visual Basic Editor for that wordbook. This adds that professional touch to my system. Private Sub Workbook_Open ( ) ' ensure that The system Opens On the quote System and ' start in Cell C6 Sheets ("Quote")

  2. Computer study project outline - library and book club database.

    USBs: I am using two USBs in this project. They are both Kingston USBs, 4GB each. I use them to save my project and report as back up.

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