Car sales Solution Essay

My task is to imagine my friend is setting up a automobile 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 coveted car information be sto red-faced and searched for easily .The system must also be aristocratical to use and I have been asked to find a solution to carry this out. Two ways that I could solve the hassle 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 speak out this would be the most efficient method to solve the problem, because information could be stored and searched for easily, using subject areas. To do this you read 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 apiece 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 field (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 standard 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 enlarge of a certain car. The car information I have entered comes from an ad in the local write up 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 administration rule is 0 and 0 and