• 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

    Appropriate Hardware identified This is the computer and printer I believe is suitable for use now and in the future of the Maintenance and the running of this efficient system: Manufacturer: Packard Bell BV Processor: Intel(R) Core(TM) 2 CPU 6300 @ 1.86GHz (2 CPUs)

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

  1. a level ict project

    In addition, to cost it is time consuming because of the slow methods that have to be used. Employees are obliged to spend time doing paperwork, as a result have the opportunity cost of not being able to more productive such as attending to the cars of customers.

  2. 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)

  1. System requirements analysis

    change fail Re-record macros, but this time, whilst recording macros, change the doctors name as well. 2 Appointments page: combo boxes Change of name for each address, DOB etc. Day and doctor combo boxes do not work, when you click on a certain day, the date does not change, but the name changes according to the postcode.

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

    I don?t need to attach an external keyboard, because this one works just fine. 4. Mouse: I have attached a wireless optical epro mouse to the computer. I prefer using this mouse to the touchpad, because the touchpad of the laptop can be inaccurate and tough to use.

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