Outputting Data
When using and changing data it can become a mess if it is hand-written. When using Data if somebody else apart from you writes it could be part unable to read. Changing data can cause this, just imagine you have two people that want to swap houses and one of them live in a street almost the same as another customer. These leads to other problems, you first have to find the data, then change or destroy it. This can also cause a great mix-up in the two addresses When Changing data you will have to cross out words for a start or have tip-ex which causes a great mess and also wasting a lot of time. Also as well as no extras that you can have on a typewriter, It is harder to delete Words, letters etc.
Analysis
Different methods that could be used would be using an electronic package such as a computer to save time and effort and avoid a lot of mistakes that are happening now.
Feasibility
Collecting data
- Collect the data from the customers at the estate agents and recording the data on a form view on a computer.
This would be at an advantage because forms can be easily read. Data can be easily entered but would be difficult to protect from other employees. JAMES
- Visit the customer’s house and retrieve data using a data capture form.
-Or-
Take a portable computer e.g. laptop, to record data from the customer.
(Disadvantage: this cost a lot of money.)
Storing
1) Non-specialist program e.g. Access
2) Specialists Package
3) Getting a specialist to write a program for you.
4) Microfiche
We have chosen the non-specialist package because it is technically feasible. It is economically feasible because it does not cost as much as the specialist package. Although it costs more than the microfiche, it benefits us better because it is easy to use, easy to find and is flexible.
The non-specialist package also has fewer disadvantages than the specialist package and the microfiche. The non-specialist package’s disadvantage is that it is not specific to the Estate Agents and it is liable to crash. It also has the most advantages out of the three.
After buying the computer and certain packages, other items need to be bought. One of these items is a printer.
Samsung Izzi plus Laser Printer
Price inc. VAT £199.99
Is the cheapest printer that was found.
Design
Some of the objectives of the design phase are as follows:
- To be able to access the database quickly (preferably under a minute.).
- To be able to retrieve specific data using questions (preferably in less than two minutes.).
- To be able to retrieve data a print out a report in under 2 minutes.
Giving out data as a data capture form is a quick and easy way of collecting data. It is also easier to read if the sheet has boxes for the reader to fill by the reader using block capitals and having multi-choice questions to tick.
Storing data will be much easier if a computer is involved. If a mistake is made then it can be changed while still being neat, but if you make a mistake on paper, to keep it neat you will have to re-write it all again.
The retrieving of data is much easier when it is in the form of a query. This can be accessed through Microsoft Access, which can filter out information wanted by the user.
Using and changing data can be done easily and efficiently when using a P.C. It can be easily read and is a lot neater and doesn’t take a lot of time. Always make sure you have a backup in case the information has to be changed or something happens to the computer e.g. Computer virus.
Analysis
Collecting data from other companies is the thing you need in order for your own business to succeed. Don’t just use their ideas add some of your own. Collecting data is a fast and easy way if you have a computer. It is a lot harder if you do not have a computer and also takes up a lot more time e.g. it will have to be hand written and rushing can make your handwriting very scruffy and untidy.
You need a lot of space and filing cabinets if you have a paper based office when storing information. There is also the problem of having the right information. When your business grows, your shop space will also need to grow (if it can). It will also be a lot harder organising the data. Which also gives the problem of whether other employees can understand it.
When retrieving data it can be easily destroyed and a mess and unable to be read. Even worse it can be incorrect and if it is important it could destroy your whole business. Which could make you deeply in debt. If files that play a big part in your business get lost, this mistake could destroy the business.
When outputting data it could waste valuable time and if a mistake is made while writing a document you would have to write all over again to make it more readable and neatly organised. If you have a lot of customers and you have some information to give out to your customers you have to re-write all of your letters to each individual customer and this method could take weeks.
Implement
Collecting data is easy and efficient when using data capture forms. Data capture forms allow the customer to fill in the form using block capitals which is easy for the customer to fill in and is also easy for the sender to read as some handwriting is hard to read by others. Below is the capture form half created for handing out to customers- (appendix A)
Then I had to create another data capture form for employees to use when finding houses (appendix B)
When I had retrieved all the data I needed, I then stored it in Microsoft access as a table because I could enter and retrieve data quite fast and easily. Again below are two tables showing customers and information from houses- (appendix C)
This is what the customers’ table looks like. On the next page is the house information table- (appendix D)
Below is what the tables started off like using access and then going into design view.
Retrieving data was done through Microsoft Access. I would make a search for the information that I needed and then I would use it. A faster way to find information is to make a query to find a certain person or people that I needed from a particular group.
The design view is as shown-
The query is shown (appendix E). Also I needed a report that employees could get to easily as seen below I used ‘owners with semi-detached houses’ as an example (appendix F)
Using Microsoft Word then creating a mail merge letter using information from the forms made in Microsoft Access carried out outputting data. Then I had type a certain document that I needed and then the mail merge copied out the sufficient amount of letters needed for all the customers in that certain document.