• 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)

    The library in Walthamstow is called the 'Walthamstow Library'. It is located on the Walthamstow High Street, one of the biggest high streets in the country. This means it is easily accessible to a large range of people as the high street is linked to a lot of transport facilities.

  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. Impact of ICT on the community

    I will look at technologies that affect the whole of my community not a single person. I will also need to include how people benefit from using the service. And finally I will then evaluate how the technology will meet the need of my community.

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

    The first way is that if you have 1-3 people you can make them go college and pay for them to do an ICT course this won't be that expensive because there aren't a lot of people. The second way is that if you have 4-6 people then instead of

  1. Hardware & Software Requirements for Database

    RAM is a very good way of spacing out data. The more RAM the better, the faster and more effectively my database will work for Whipps Cross Hospital which will be beneficial to Whipps cross hospital as if they have more RAM that means that more then one programme can be open at once.

  2. a level ict project

    He could hire a specialist employee who would enforce these laws and introduce more if required. The specialist employee would draw up a system which would involve strict steps for the garage workers to follow, and could provide incentives such as appraisals or even punishments.

  1. Creating a computer system for a video rental shop

    it ensures that the value of the primary key can never be a null value.. The integrity rule requires that insert, update, and delete operations maintain the uniqueness and existence of all primary keys. * Referential integrity. Foreign keys are used in relational databases to implement relationships between the records in different tables.

  2. The impact of ICT on a person with special/particular needs

    Sarah's sister and carer helps set everything up for her, which is extremely easy to do thanks to the iPhone's user-friendly system. Sarah can then send calls by going to her address book by saying 'Contacts' and then saying the name of the contact she wants to call.

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