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

Creating a database for Buy a Motor.

Extracts from this document...

Introduction

Buy a Motor Statement of Problem Buy-a-motor is a car trading company. It puts the sellers of second hand cars in touch with those who want to buy them. They normally keep records in filling cabinets and contact people through telephone and letter, and buyers call them for info on the cars, which are available to meet there requirements. However this method has become out dated and they need to improve. I will need to create a database that can display all of their data, as efficent but hopefully better than the excising system. Investigation and Analysis If Buy-a-motor change their system to a database the information will be quicker to access and it would be more efficient as they would not have to use paper to print everything. There could also email their files to people to speed up the service. To research what type of data and information are included in adverts for cars I went to these different areas * Auto Trader * My Dad * The Internet I found that they all agreed that you want to know: - 1. The Age 2. The Make/ Model 3. If it's had an MOT 4. It's Service History 5. ...read more.

Middle

Software Resources Buy-a-motor will also need to purchase some software, these will include, but not be limited to * Microsoft Access, for the database to be on * Microsoft word, for writing out letters to clients The software needs to be able to * To save information so that it can be retrieved for later use. * To be able to print off data, so that it can be sent to potential clients. * Alter Data so that new cars can be added * Inform someone when they have made a mistake (validation rule, etc) * To be able to get sent via email to clients. Microsoft Access can do all of the tasks, very efficiently. It is also available on the school network. To run these programs you would need a Windows operating system, preferably windows 98,2000/ME or XP. Data Input Form (See next sheet) Data Structures Field name Why it is needed Example of typical data Data type Max field length Could it be coded? Could it be validated? Surname To identify the owner Smith Text 25 No No Area To know where the car is North East Text 15 (3 if coded) ...read more.

Conclusion

At first my database would not store details of cars correctly because the input boxes were incorrect (text is number etc). I corrected this and it can store details now. I entered 27 Details in to the data base, this could be transferred by email or 3 1/2 inch floppy disk, so they could store 1000's of cars on their database. * It must be able to be altered and updated with ease (e.g. add or delete stock etc) I can test this by entering test data when it is completed. This is very important that the database can do this. I can enter new data and it is easily done if people know a little bit about MS Access * Allow for a search of the data base for specific cars e.g. A make or Price Range, this can be tested by, again entering in test data. My project managed to do this but it is not very user friendly, people would struggle with the queries. If I were to do my project again or improve on it I would add an easy input screen, so that people who don't have knowledge of access can use the database. The data capture form is very easy to fill in and is not to demanding, for less intellectual people Gareth Jones 10L ...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. GCSE Book DataBase Project

    It takes so long to find some ones file if your filing cabinet is not filed properly. Paper documents take up a lot of room up. You have no back up. You can't share the records because you only have one copy.

  2. Organising the database at Costsloadsless.

    hour because another customer will come in and they will have to remember there data as well as the first customers * They don't have to pay electricity on the computers therefore saving money for the business. * They will go threw a lot go pressure to remember everything!

  1. Smarts Leisure Park Database Booking System

    - Customer Data I will need data about the customer such as Name, Age, Gender, Address, DOB, and E-Mail. This data will come from the customer, giving the details on booking. It will be entered by the receptionist. - Activity Data I will need data about the activity such as

  2. ICT PROJECT

    Select edit record and when the data form appears select a student record and then press delete To check if data entry form is working properly The specified student record should be deleted fully from the data store without leaving any gab As expected before and after screenshot are shown

  1. Designing a Car Mechanic's Database

    The customer list will include the regular things such as address, postcode and telephone, and the specialist garage will be similar, but will include what they are good at. The following tables show the properties of the fields I will be making: CAR DATABASE Field Name Data Type Other Ref No.

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

    this on the criteria: Like"*"&[enter DVD id]&"*" like"*"&[enter DVD title]&"*" like"*"&[enter director name]&"*" like"*"&[enter actor name]&"*" This in the interface that the user will see after the search for the query has been finish. > MEMBERS QUERY On the members query I have set up three different parameter to allow the use easier access to the information the may need.

  1. GCSE Database Project ICT

    After data has been inserted into the spreadsheet function, mathematical functions can be created and with the results graphs or charts to display average data easily. Microsoft Access The Second solution available in the Microsoft office 2007 suite is Microsoft Access, which hold many advantages.

  2. ICT - making a database of used cars.

    Can you show me a list of black cars? Which of these cars are priced under �10,000? 7. Which Ford cars do you have? Which of these cars is priced �10,000 to �15,000? 8. Which cars do you have that have air conditioning? Which of these cars is under �10,000?

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