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


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.


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. Ict Powerpoint Coursework

    The buttons on the slideshow will be a forward button to go to the next slide, a previous button to go to the previous slide, a home button to redirect the user of the slideshow to the main slide, where there is a variety of buttons redirecting the user to

  1. Database coursework

    Input mask I don't want people to enter invalid postcode so I use an Input mask. This mask will make sure that letters and numbers are at right places. I will use this mask (L?99LL) . It will allow any letter and then any letter or number, then it will

  2. Database Coursework

    It would make it much easier to look for specific records. Also, backups should be made of each record so that if the original gets lost, then there would be a spare copy that they can use. Spreadsheet System Using a spreadsheet would bring so many advantages to the company.

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

    Television is one of the biggest sources of distraction. 'Time to finish my ICT coursework', you may think. But then, bam! Friends is on, and who could resist that? Not me, but thank god it's 5am and everyone is asleep meaning I can't turn on the television. Thank god indeed, but I'm sure you get the point.


    Achieved Add New Student When the user clicks on add new student button on the front-end menu, a user form directly loads enable the user to enter student details. The user form is clearly laid out and structured. It is clear what data must be put in each box.

  1. ICT Report 2b: ICT in Organisations

    PS/2 Port This port is used to connect keyboards and mice to a computer system. Their ports are similar in shape and size; however if placed in each others allocations, the motherboard would be rendered oblivious to its presence and would not recognize either.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    Like"*"&[enter member id]&"*" like"*"&[enter customer id]&"*" like"*"&[enter customer post code&"*" This is the user interface: TESTING REPORTS > DVDs REPORT This is preview of the report for all the DVDs on the store. The user must use the navigations buttons to move from record to record.

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