• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  • Level: GCSE
  • Subject: ICT
  • Word count: 7197

ICT Access

Extracts from this document...


Part 1 - IDENTIFY Statement of the problem Mr. Hock is the proud owner of a recently configured estate agent. Mr. Hock invested a large quantity of money obtained from both savings and loans to produce a successful business. Mr. Hock is keen to generate a local estate agent that will enable the delivery of a level of personal service unmatched by larger corporate companies to his clients; he maintains a policy of a personal promise to provide a quality service enabling a stress free move. He employs a mature specially selected local team offering a combined experience of over 125 years in estate agency therefore viewers can be accompanied by staff if required. His employment also extends to Sales Coordinator a specially trained individual member of staff to do all the work for the customer once the sale is agreed and an exchange of contracts is completed ensuring the sale proceeds smoothly to a successful completion. He incorporates competitive sole and multiple agency commission rates representing excellent value for money. When he bought the company 4 months ago he was aware the previous owners earn't a substantial amount, with high profits. He offers a range of affordable housing, enticing many clients. He wants to encourage a constant supply of reliable clients recommending his services to both friends and family. Often users of the website comment on their experience of the site and he receives e-mails on the online computer located with in the store. He receives personal recommendation which he allows access to by potential clients allowing them to see the ever expanding file of comments from customers very happy with the service that they have received. His team offer valuations considering numerous factors affecting the sale ability of the property and its current market value, however it would be more appropriate if he could inspect a database of properties currently on sale with them to confirm a reasonable price attracting a prospective buyer this would allow him to cross reference against ...read more.


The different devices used to enable the user to view a specific property or customer details table displayed on the system include a monitor which is the main source of allowing you to see, another output device is speakers which allow sound the be heard although on Mr. Hocks system it is not necessary as he is not using sound on his system, as the instructions are self- explanatory and un-aided by sound. Sound is only necessary to add interest and is not vital to control the system. A printer is also required to enable the efficiency of print macros this allows the printing of reports. Mr. Hock recently invested in a HP - Photosmart D7360 a fast high quality photo printer with the introduction of several new features allowing a combination of copying, scanning, faxing and printing. Mr. Hock also frequently uses a projector during his meeting to discuss and display the profits obtained however it is not needed to allow the system to work correctly. Back up and Security Strategy Mr. Hock's system will need to be protected to do this files will be saved on a floppy disc for security reasons; it will not hold a high percentage of capacity on the disc as it an Access database. Mr. Hock will take the disc home with her every night to keep if safe in-case of fire hazards or other dangerous hazards that could jeopardise the information or even loose it. You will also need a password to access the system to she can keep potential hackers out. Mrs Heart is applying a virus protector so when she needs to use the internet she will be protected from pop up emails. The site is also protected from users entering cells in which only Miss Heart can enter therefore resisting information change. To make the Microsoft access secured so no hackers or viruses from the computer can damage or steal the system I am going to make a list of security actions we ...read more.


The Customer Details Form closes. 24 Exit database. Click the Exit button on the Main Menu. Database closes. The breakdown of solution into subtasks on my system: 1. I opened Microsoft Access Application and I began by applying the relevant information with the specified details and the correct data types for example OLE object for the property image. In the field Customer ID and House ID I ensured I incorporated primary keys enabling the depiction of unique data. In the Field name I entered the significant headings to my Estate Agency. This is an individual account of information which relates to the other fields, I then selected the Data type e.g. Autonumber, Text and Date/Time relevant to the opted field. My primary keys are Customer ID and Property ID. 2. I then applied the client and property details within my tables; this consisted of the following customer details [Surname, first name, date of birth, address 1, address 2, town, county, post code, telephone, mobile number, email address and price range]. And the property information includes [Price, location, type, bedrooms, bathrooms, garage, garden, extras, facilities, double glazing, central heating and pictures]. 3. I developed the design aspect which enabled me to apply colours, the companies opted colours were neutral pastel colours these allowed a clear separation of the ' ' Estate Agency, against other local agents. I allocated a certain colour scheme throughout to simulate the company's colours, the font will be maintained to avoid confusion. 4. I linked the two above tables together in a 'Viewing table'; some were look up tables, for example house types, these were typed in with the options whereas others required the entry of text to successfully work. 5. The queries were then made for certain aspects of the system. For example bedrooms and type, or customer name. These queries were a range of normal queries or and/or queries where there can be more than one preference. 6. I then made reports for a selection of these queries. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    thief using your own money without being detected * Buses can ruin schedules by coming late due to an accident of sorts Conclusion The Oyster card/travelling system is extremely useful for a citizen in London. It's an extremely advantageous system to have and people benefit tremendously.

  2. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    Newsletter Evaluation Good Points I agree with some of the points given, but I disagree with others. I agree that the use of my variety of fonts and use of techniques such as centred, underlining, bold ? which added empathy to my information.

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Then click create when you have found the right location. Using Formats (in Dates) The way you do this is by first of all you open Microsoft Access then after that you click table and inside that you click on information that you have already have created from before, after

  2. Different types of technology How I use ICT at home and at school

    This can mean a few different things. To maintain MSN, you need internet. Internet costs a lot of money and can increase in price the more bandwidth you use, if you don't have unlimited. This means that if you lose internet connection, MSN will disconnect which can cause problems.

  1. Creating a computer system for a video rental shop

    We found that every non-key attribute is functionally dependent on the unique identifier (transaction number To check for the 3NF, It shows that all non-key attributes are mutually independent. There is no calculated attributes in the entity. The Data Flow Data Flow Diagram To help me design an effective and

  2. ICT Report 2b: ICT in Organisations

    today they also come in patterns of dots, concentric circles, and hidden within images. Barcodes can be read by optical scanners called barcode readers or scanned from an image by special software. Barcodes are widely used to implement Auto ID Data Capture (AIDC)

  1. I will design a new video database for the video shop that will also ...

    spent on maintaining and storing information and more time is spent on dealing with customers. It will also prevent Staff from overbooking rentals as the system will only allow rentals in stock. If a Staff has inserted a rent for a customer, a message will notify anyone who tries to

  2. Impact of ICT on the community

    Some might not even have computer. People in my community are multicultural and came from other countries so they will need to communicate with their relatives in a cheaper way so internet cafes will meet their need. They need ICT that provides them with cheaper internet and let them have access to internet with cheaper offers as well.

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