Car sales Solution Essay

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. Firstly you must make a query table, to it you need to add as many field options as you need such as type model, below each field type what you are looking. Save the table, open it and you should have some results. The car data type I need to put into the databases to solve the problem are Model, Make, Year, Type, Mileage, Mot, Colour, Extra features and history of owners. These will become the titles of the fields (fields are the tables in which you add all the information in the databases. I need to collect each of these items of data because this will give easy access to search for the customers desired feature of a car. For example if a customer wanted a red car I could just type red next to colour when searching. I have designed a data capture form, which shows all the details of a certain car. The car information I have entered comes from an ad in the local paper Herald and Post. The car information is taken from a Stanground Autos ad. 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 0 and