• 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

    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.

  1. ICT PROJECT

    McrForm Sub mcrForm() ' ' mcrForm Macro ' Macro recorded 29/01/2007 by 21bor2413j ' 'removes flash when macro is run Application.ScreenUpdating = False 'Select Pivot A Sheets("Pivot A").Select Range("A4").Select ' sort out pivot to add accurate fields to pivot ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Form" PivotItems("(blank)").Visible = False 'Add Titles to chart Sheets("Chart1").Select With

  2. ICT Report 2b: ICT in Organisations

    It helps the workers because they can communicate with each other via intercom and improves the moral and chemistry between the staff team. Finally speakers help the customer because they can hear advertisements and/or promotions on the shop floor. It helps the company meet the need for high customer service and good communication throughout the organisation.

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

    id]&"*" like"*"&[enter actor name]&"*" Like"*"&[enter DVD title]&"*" On the report, the user must use the navigation buttons to move from record to record. The report will look like this: > DVDs REPORT BASED ON THE QUERY On this one, the same criteria that we use on the query like in

  2. Ict Powerpoint Coursework

    Food franchises. Using these methods there would be more awareness of the PowerPoint Presentation and this would be one of the purposes to overcome Mr. Akram's problem. DESIGN Output The questionnaire shown below is based upon the contents of the PowerPoint Presentation and is a typical primary research field on

  1. Database coursework

    of system Crashes so that I can obtain data in system crashes. Physical The company will use electronic locks. The second thing the company will use is Id-cards as part of the electronic locks. These id-cards will be used to access offices or the company's documents.

  2. Database Coursework

    Not only would it be more organised, but it would also mean that there is much less work for the receptionist and the mechanics. Instead of having to write all the details out onto a record and placing it into the folder, all she has to do is type it in, and it will be stored into the system.

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