• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19

Estate Agents I.T. Problem

Extracts from this document...

Introduction

Estate Agents I.T. Problem Choice Of Problem Ward and Partners are an estate agents in Eynsford, Dartford and Gravesend. They advertise houses in their windows and in newspapers. However for a potential buyer looking for a house they will want specific things, e.g. 3 bedrooms and 2 bathrooms. So basically what I am saying is that the estate agents cannot match a house perfectly to a persons needs, as they do not have all the information stored about every house in their memories. So I am going to design a working database/website that people can search for their perfect house on 24hours a day. There are many ways of solving this problem for the data handling and communications coursework. You could make a database to hold all of the information and quickly search through the records of the houses but a better way of performing this take would be to make the database a part of a web page so that people could access the system 24 hours a day. When looking to buy a house it is very time consuming having to visit the estate agents often to see the new houses on the market and to keep looking through 2 or 3 papers. So I am going to create a web site which includes a database which holds all the information about all the houses that the company has to offer. People can then search the database on the internet 24 hours a day. To make this website I will have to find information about houses and input the information into the database. The website will be very user friendly so everyone can access it. Description Of Problem The system will be very simple , it will use peoples needs to find their ideal house. I am planning to do this by asking a few simple questions about what the user wishes their ideal house to be like. ...read more.

Middle

* Software Packages Now that I know that I need to use a database or a powerful spreadsheet and a web page editor or programming language, I need to look at the different software packages and languages that are available for me to use. First the database. Software package_Facilities and information * __Microsoft Access_Database only, so will have more facilities * More commonly used than Microsoft Works * Very powerful tool * Difficult to use properly without proper training__Microsoft Works_Combined word-processor, spreadsheet, database and address book so will not have as many facilities as Microsoft Access or Excel * Less commonly used than Microsoft Access and Excel__Microsoft Excel_Designed to be a spreadsheet so it focuses on facilities for producing web pages however, it has basic database facilities * Easier to use than Microsoft Access * More commonly used than Microsoft works __ Now the web page editor. Software package_Facilities and information * __Microsoft Word_Doesn't support frames * Text can be easily inserted and formatted * Hyperlinks can be inserted between pages * HTML code cannot be seen * Forms can be inserted * Tables can be inserted * Backgrounds can be set easily * Word Art can be used * Creates a lot of unnecessary code__Microsoft Front Page Express_Doesn't support frames * Text can be easily inserted and formatted * Hyperlinks can be inserted between pages * HTML code can be viewed and altered if needed. * Forms can be inserted * Tables can be inserted * Backgrounds can be set easily * Web bot connections (time and date) can be inserted * Created a lot of unnecessary code __ Finally the programming language. Language_Facilities and information * __HTML (Hyper Text Mark-up Language)_All web pages use this code to tell the browser that the code is a web page * Can take a long time to learn and use quickly * Web pages can be made to look exactly as you want them to * Can be used with other programming languages e.g. ...read more.

Conclusion

The macro allowing data that has been entered in a form has not been hidden so that if the people putting data into the database choose to enter the data in a form they can still validate the data easily and correct it where necessary. Documentation * Technical Documentation Minimum system requirements: * processor speed of 200 MHz * Memory * sound card * video card * CD-ROM drive * Windows 95 * Microsoft office 97 * Free hard disk space The hardware and an operating system usually comes already installed on most computers that have been bought, so this is not a problem. To install Microsoft Office 97 you will require a CR-ROM drive and a CD containing Office 97 on it. When the CD runs, the set-up will help you to install Office 97 onto the system. I could pass on my system and web site by burning the database, web pages and images onto a CD to allow easy storage, and protection. I could have used a 3.5 inch floppy disk, but data can easily be over-written and they can be damaged easily, whereas, CDs are more robust than floppy disks and cannot be over-written unless: a) The company, Ward and partners, has a CD re-writer and then, b) I burn the data onto a re-writable CD The CD would be inserted into the CD-ROM drive and all of the information on it copies onto the computer's hard disk, so now there are two copies of the data, so that if one is lost, there is still a back-up copy of the data. The files can then be opened and edited Before my system can be used by a customer, real data about houses and their current owners must be inputted into the database, as I have made 99 sets of imaginary data just for demonstration purposes and to show that my system works properly and does the jobs that it is supposed to do. ?? ?? ?? ?? _ USERNAME \* MERGEFORMAT _ckd_ _ DATE \@ "dd/MM/yy" _12/08/02_ _ TIME \@ "HH:mm" _20:01_ ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Stace & Dunphy (2001) identify five dilemmas of change

    In the same way, in France, reducing working time by law finally was, in many companies, the best way for actors to co-operate in changing work organisation. The deal was clear, with advantages for both partners. Such a social actors' involvement in regulation of work organisation is now converging with

  2. I have been given the task to design a database for a company called ...

    Entities are things of interest to an organization about which data is held. In order to be able to draw an entity-relationship diagram you need to know the degree and the name of the relationship. The degree of the relationship will come under one of three categories: 1. One-to-one, e.g.

  1. Different ways of data capture

    Some WP lay out a document based on the printer being used. If the document is transferred to another computer and a different printer, the document may appear with a completely different layout, with line breaks and page breaks appearing at different places.

  2. Free essay

    Setting up and E-Commerce Site

    This may consist of an office, in which case we may need a computer, a chair, a desk, a fax machine a network of computers. The list in endless, in which case we need to budget for these and buy as appropriate, buying unnecessarily however does impact on profit and loss however.

  1. Spare Parts Database Project

    Add all records and put only 6 digits in 'Mobile Tel Number' A message box must appear saying 'Mobile Tel Number must contain 7 digits' OK Module: Transaction File TEST NO. TEST EXPECTED RESULT REMARKS 1 Click on 'Add' command button.

  2. Purposes and Features of a Relational Database

    Similar to a spreadsheet, a database will store a small amount of data in each space. Each table will have a certain number of fields. Each field defines a specific piece of data about each record. A record is a set of data about one specific item.

  1. Smart Card System

    It still retains full backward compatibility with the existing 1.1--some of which is clarified further--so all existing WinSock applications can continue to run without modification (the only exception are WinSock 1.1 applications that use blocking hooks, in which case they need to be re-written to work without them).

  2. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    The organisation is not a large-scale operation and at present the client owns just one apartment but is looking to expand into the property rental market which is set to grow in Bulgaria and additional residencies will be required to meet demands.

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