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

Car sales Solution - My task is to imagine my friend is setting up a car locating business and wants to install a computer system.

Extracts from this document...

Introduction

Coursework Project 1B Car sales Solution My task is to imagine my friend is setting up a car locating business and wants to install a computer system. The system must have the power to store different car information and have the function to search for desired car information be stored and searched for easily .The system must also be easy to use and I have been asked to find a solution to carry this out. Two ways that I could solve the problem is by (1). Putting the information in a table using Microsoft Word, information would be easy to store, but a disadvantage would be that it is, hard and time consuming to search for a desired car. Another way would be storing the information in Microsoft Access. Microsoft Access is a program that contains databases. I think this would be the most efficient method to solve the problem, because information could be stored and searched for easily, using fields. To do this you need to use a query. ...read more.

Middle

I have decided to create a way of validating data. The data type that needed validating was Mileage and Price. For the Price field the validation rule is; >0 and <10000, this means data input must be more than 0 but less than 10000 pounds. The format is currency; therefore only currency can be entered. The validation text I have put is 'Data input too high please try again! .' This message will pop up every time data is entered that doesn't follow the above rule for Price. For the mileage field the validation rule is; >0 and <90000, this means the data 'miles' should be more than 0 and less than 90000 miles. The format is number, therefore only numbers can be entered. The validation text I have put is 'Data input too high please delete and try again! .'This message will pop up every time data is entered that doesn't follow the above rule for mileage. I have created some queries in my database and run them. ...read more.

Conclusion

Setting up the database wasn't too hard to do, but might be quite challenging for beginners and takes a bit of practice. Searching using queries was surprisingly simple and quick to use; this would be an asset for businesses with the same type of initial problem. I have verified my car sales data to make sure it was accurate. I checked it myself than asked a friend to see if they could spot any errors. In a proper business thorough verification checks are used on data. Firstly an operator, against the source material checks the data input. This is usually a simple visual check. After that a second operator keys in the same data. The computer has the job of comparing the two files and warns off any mistakes. The source document is then checked again for the correct data. I am quite pleased with my finished work but some improvements that could be made to my solution would be: to arrange the car sales data in a more efficient way so better validation rules could be applied. Chiara Valente 10R I.C.T ...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. Creating a computer system for a video rental shop

    Staffs are given automatically incremented ID numbers. This form will be accessed from the editing form. There will be a button to add videos and a button to delete videos and a list box will be used to view details of videos already allocated.

  2. Designing a Car Mechanic's Database

    Say if a customer or car is just introduced to the garage. The information needs to be able to be added to the system without a lot of hassle. My files all need different field names and data types. In the vehicle database, I will use a combination of both

  1. ICT PROJECT

    = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time. You failed to enter data in one of the required field!", vbOKOnly, "Student Entry Message:" End If If Range("B2") = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time.

  2. Spreadsheet Project - computer system for a video hire shop.

    My findings are as follows: Test Name Test What? How? Test Data? Expected Outcome Actual Outcome Valid Membership Test that only numbers between 0 and 2000 can be input Inputting valid and invalid numbers and text 39 2930 horse 605 Allow input Validation error message Validation error message Allow input

  1. Camelot Restaurant Bookings System - computer system design

    So I created a macro to stop this, it is shown in the commentary on Testing. In B9 the formula: "=IF(SUM(I71:J71)>150,"Overbooked-Too many People in between 12:00 and 14:00"," ")" This was for the validation rule that guests over 150 in two hours means the restaurant is too full, there are

  2. Creating a computer system.

    I must also take into account the current problems and the needs of the user(s). Then I will need to generate some ideas, considering the resources available. I will also need to justify the ideas. The design will include thorough testing strategy and plan.

  1. Create an IT system for my karate club.

    such as search for addresses and the end user simply clicks on the button and types in the persons name, it will then bring up all the results in no time at all. This allows the user to get familiar with the use of the system and it isn't too difficult to grasp.

  2. Benefits of using my IT system in the Travel Agents.

    * After that, click on Microsoft Office. * Then you click on All Programs. * Finally you click on Microsoft Word. Create letterhead * First, you should go on Microsoft Word. * Then, you should click on Insert. * After that, you should click on Header and Footer.

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