Computerising the system will solve all these problems plus bring a few more benefits to the company. For example:
- Using a computerised database system, with software like MICROSOFT ACCESS and hardware such as a computer, monitor, printer, and keyboard, the process of obtaining and entering information will become simpler and faster than in a manual system because information can be obtained simply by clicking on a button.
-
Computerising the system will also mean better presentation by using a universal font such as New times Roman or Arial, which is easier to understand than anyone’s writing
- Backup tapes can be taken for a computer in case the system is stolen or burnt down. That means only the hardware is lost but not the information because it can easily be loaded up to the new hardware, therefore minimum information is lost.
- A Company can have one computer to store all their information although the more information is added the more computers will be needed. Even though, computers are far less space consuming than filing cabinets, therefor Pearce & co can use the extra space for larger working spaces or even fit in an extra member of staff.
The best software to use in this database situation is MICROSOFT ACCESS. MICROSOFT EXCEL and MICROSOFT POWERPOINT can also be used as well but is not nearly as effective as MICROSOFT ACCESS because MICROSOFT ACCESS can be used to file the input information into sorts. These sorts can then be saved into queries so that particular sort doesn’t have to be entered in every time certain information is needed. MICROSOFT ACCESS can also give a range of different Forms, Tables or Reports at a click of the mouse using macros. MICROSOFT EXCEL cannot do all these things. EXCEL can only put information into a spreadsheet and can be saved as an individual file for 1 spreadsheet. That can be very space and time consuming if information is being looked up. MICROSOFT POWERPOINT is also not as good as ACCESS because POWERPOINT is mostly used for presentations, but it would be second best for this particular job, after ACCESS
Analyse
At the moment, the system, which Halletts uses to record their information for all the houses they have and have had for sale, is recorded manually. Employees go to the houses that are being put up for sale and record all the information about that house into a form. That form is then taken back to their headquarters in Newbury and then that form is put into a filing cabinet, which is sorted into different filing cabinets for each village in the Newbury area and is then sorted alphabetically by house address. When a customer enquires about houses in a particular village, the information can be looked up by going to the relevant filing cabinet and the writing down all the houses there are for sale.
The Data included in the system will be as follows.
*Number of bedrooms is put in so that the potential Buyer can tell the estate agent how many bedrooms he wants to have in his house. This information can then be entered into the search.
**House Price is put in so that The potential Buyer can tell the estate agent the maximum price he wants to pay and this information can then be entered into the database search aswell. A suitable house can then be found
In my system, collecting the data is collected and processed in the following way:
- Employees go to the house for sale with a laptop and enter all the information into a form with the field names specified above.
- The employee then returns to their headquarters in Newbury where the laptop is linked up to their network and then the loaded from the laptop onto their proper system.
- Then, relevant Queries and forms can be made to suit the customers needs
I think this is the best way to go about the job because:
- Telephone conversations can be difficult to understand and certain information can be misheard.
- E-mailing the information from the laptop requires a telephone port or a very advanced laptop, which can be very expensive.
- Manually filled in forms have to be re-entered into the system which uses up valuable time.
The present manual system works with forms filed into a filing cabinet. This can be very slow in entering (input) and obtaining (output) information. This computerised method is good because it is faster than any other method available, including e-mailing it back to the headquarters because like I said, e-mailing the form straight to the headquarters would need an advanced laptop, which can be very expensive. My method of obtaining information is best suited for the job in my opinion, it’s easy, fast and cost effective.
Input information into the database
E.g. Field names, datatype.
Process data by entering it into tables
and forms and sorting it by using
queries.
The output is the hard copy of the
Database (the print out).
Objectives for this Project
- To provide a quick and easy way to enter data about houses into the system, using tables and forms.
- To use validation checks to make sure all data entered is valid, and limit errors
- To present data in an organized way.
- To create a way of accessing data quickly and easily, using certain criteria.
Implement
This following table is the way in which all my data will be stored. It is also in the format that queries will be stored in.
Queries can then be done in the following ways:
This is a query for houses with 3 bedrooms.
This is a form putting all the information into one form where buttons can be clicked to perform a specific query. In this case “number of Bedrooms” will have to be clicked and then “3” will have to be entered to activate the same query as the previous one.
Another query can be neatly displayed in a form as such, this time for price (you can make a price range in a query by putting in the following formula: “>=[enter min price?] And <=[enter max price?]”
Another way of displaying information about all the houses for sale is by means of the following form:
I have spoken to my end-user and he has decided that for a form which displays all the houses on sale, he would like the form above, and for queries, he would like a “button sheet.” So now that I have tested it, I can start making the final database.
Evaluate
My project has several good and bad points for my end user. Here are all the things I consider good points about the Database I set up.
Good points about my Database
- Queries have been produced – This helps particular data to be collected quickly, without having to browse through all the information to find the records that you need.
- Forms have been produced – This helps so that data can be entered into the relevant fields easily and quickly. It also makes it easier to access the data for the end user, and makes it more presentable, as it is shown in form view, instead of tables.
- A switchboard has been created – This allows me to access 3 different queries from a single form. This makes it even easier and faster to search for information.
Weak points about my database
- No reports have been made – This is a good thing to have because, hard copies of information can be made. Seeing as this database is for an Estate Agent, not me or my end user really see a need for this, and customers can take away brochures of particular houses.
Have I met all the objectives set?
Objective 1: To provide a quick and easy way to enter data about houses into the system, using tables and forms.
- I have achieved this by setting up forms
Objective 2: To use validation checks to make sure all data entered is valid, and limit errors
- I have also created successful validation checks, such as number fields, and limiting the number of characters in each field.
Objective 3: To present data in an organized way.
- I have achieved this as well by using structured tables, forms, and a switchboard.
Objective 4: To create a way of accessing data quickly and easily, using certain criteria.
- I have achieved this by setting up queries using macros, and have also put this into the switchboard. This means houses can be found according to certain criteria, like price range.
As you can see, I have met all the original objectives set by me and my end user.
My end user suggested that one possible change could be to create reports. This would mean that hard copies can be printed off. He said that instead of having a separate system for brochures, we can use these reports as brochures. I then explained that we will need much more information on houses to be able to create that, like description, directions and size, if we wanted it to look like one of their current brochures.