• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  • Level: GCSE
  • Subject: ICT
  • Word count: 2955

I want to design a database that will allow faster and easier sales of cars, it will also help organise them too.

Extracts from this document...


Contents page Section Page > > > > > > > > Car Database project I want to design a database that will allow faster and easier sales of cars, it will also help organise them too. Before I design a database I need to find out what information I will need to include in my database, to this I will produce a questionnaire, which will be sent out to several garages in my local area. When I get the questionnaire results I will then design my database around the wants and needs of other garages I am going to produce a database that will allow salespersons to use a PC to speed up the search process for the customer. If the customer is searching for a particular type of car, i.e. make, model, mileage, year of manufacture. The database, which I have created, will allow the sales person to search for a car meet the customer's requirements. I am doing this because it will be much easier for the salesperson to find a car, which will meet the customer's requirements. Implementation You must use the software to process and store data entered from the questionnaire for required output. You need to produce a report, which describes in simple steps how you created the database using the selected software. This will match your design. Printouts and screen shots are required and the data has to match the data collected from the data capture sheets (one from each garage). Database should be approximately 50 cars and 5 garages. For a good mark your database should be a fully functioning system. Proof could be in the form of screen shots and reports showing that customer questions (from questionnaire) ...read more.


Click on "Create New Table Using Design View", on the screen that has just appeared, which should like something like this: Where it says "Field Name" enter all the fields you want to appear in your car database. The different fields you enter should all the information you think a first time buyer would like to know. Once all of the information has been entered save your work then open up your table and enter the information about 50 cars, for example enter what type of fuel the car uses, the price, make, model, year of manufacture, colour of car, which garage you can buy the car from also the extras the car has. Once this has been achieved you must save and exit, you should then come up with the screen mentioned above, click on "create new table in design view". Once it has loaded up enter the name of all the garages, the address, the phone number of the garages and a contact number for the garages. Make sure the name of the garages is exactly the same as the name in the other table containing all the information about the cars. If you made a spelling mistake when entering the names of the garages when you come to linking both tables together it will not work, so you must be extra careful at this stage because it could waste lots of your time if you make one mistake. One all the information from the garage table has been entered accurately, save the table and close down the table. Once the table has been closed down a screen like this should appear: Right click on the empty white space (where the arrow is pointed) ...read more.


Here is the exact list of ways for which you can search for cars. Max price, Minimum number of doors, Minimum price, Maximum number of doors, Make, Model, Garage location. The reason I made it so you could search the database for the above list is because I feel that these are all important factors to a buyer when buying a car. I have also included instructions on how to use my database so that anyone who wished to perform searches would then know how to do them. After I had designed my database there were several changes that I made. I had to take into consideration the actual file size of the database. I did not want to be taking up space, which was not being used. When choosing your design fields there is a box labelled "filed size" the default setting for this is 50. This means that for every box in the table it will allow up to 50 characters to be entered into that box. Even if you do not enter 50 characters into that box it will still put space aside for them. So one box would take up a minimum of 50 bytes. I have hundreds of boxes in my database, so this was taking up lots of unnecessary space. To change it just click in the box and choose a more appropriate number. The number I chose was 25, as this is enough space to enter in the information I needed and would also leave me a bit of space to add to the boxes if need be. Another change that I made was to change the colour of the database so that things would stand out clearer. Mark Austen Centre Number: 51515 I.C.T Coursework Candidate number: 8137 Mark Austen Centre Number: 51515 I.C.T Coursework Candidate number: 8137 ...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 Software 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 Software essays

  1. ICT: Long Project Design - Travel Agency

    On the database, the fields must have the correct type of data. For example, the field 'First name' must have the type of data: 'text.' This will minimise the mistakes being entered because you wouldn't be able to put a date of birth in a first name field.

  2. Documentation of a database for a sports centre.

    , Number * Member on Site - Text Field name Example Data type Length/ Properties Validation Description Title Miss Text - Can either be "Miss", "Master", "Mr" or "Mrs" Forename Julie Text - Member forename Surname Smith Text - Member surname Membership number 4720 Auto number 4 unique Key field

  1. Database design for a games shop.

    fill in the customer form, or in case of a returning customer they will just have to write the name of the game that was rented. Common input data will be automatically validated by the databases 'autonumber'. Autonumber is a unique primary key which is used for certain information such as 'items' or 'people'.

  2. bookings database

    Output will be on screen Yes Screen Title:- "(Find a returning guest") Yes Surname (input) Yes Postcode (input) Yes Title (Dr., Mr., Mrs.) (output) Yes First name (output) Yes Address (output) Yes Guest number (output) Yes Desired outcomes (qualitative) 1.

  1. Project 1a. ICT

    near future, it will be a story booklet for children aged 4 to 8 years old. The application is used to create my booklet is Microsoft PowerPoint which is a brilliant source for updating slides and for copying and pasting lots of different pictures suitable for children in a children's story booklet.


    going for it and that is that it is free to use online with no installation needed which can save valuable space on your computer and you wouldn't have to worry about accidentally deleting your work neither would you have to worry about losing it if your system crashes or goes down.

  1. Spreadsheet Report

    Each graph has a title and labels for each axis. An example of this is 7 Do some What if.... Queries I decided to test out my spreadsheet by changing the cell "B14", "C14", "D14" this used the what if The result of this was when a hirer spent over

  2. Powerpoint review project

    I will use the JPEG (compressed bitmap) to shrink the photos but the photo quality will not be as great. The transition between slides will be customised for perfect timing of the animations and for a better accuracy of the presentation overall.

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