• 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
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  • Level: GCSE
  • Subject: ICT
  • Word count: 4288

Ict Access Coursework

Extracts from this document...

Introduction

Lucy Kitching TLA - 16447 Candidate no - 2090 Edexcel GCSE ICT Project 3 Access Part 1 - IDENTIFY Statement of the problem Mrs Dickinson is a proud owner of 'Lucy's Estate Agents', what is a well-known Estate Agent all over Britain. Mrs Dickinson owns ten different 'Lucy's Estate Agents' plotted all over Britain. The business is a family business that has Been up and running for about 6 years now. It has a good reputation to the public as it fits all of the public's needs. There is a variety of different customers starting with new home buyers going to business building buyers. Mrs Dickinson has set a target to achieve double as much customers as she has now for next year and in the companies total income have a 10% increase by next year. In order to achieve these targets Mrs Dickinson will have to find a solution to a large problem that she has recently had. As said above Mrs Dickinson has a major problem with recording the information of properties, customers and viewings on a system for employees that work for Mrs Dickinson running the business. At the moment the employees record this information on paper what has recently got out of hand as there have been a lot more customers lately so they have lots of unorganised stacks of paper showing lot's of information that they need for the future. The paper could easily get chucked away, lost, stolen and also if there's a building fire all the information can be destroyed and there will be no back up copies. Also another problem is that if a customer comes in with a query about a property or if the estate agents have a query about a customer then they have to search through stacks of paper to find the information about the property/customer. Sometimes the Estate agents have to say that they can't solve your query to customers because they cannot find the information, this then gives 'Lucy's Estate Agents' a bad reputation to the public. ...read more.

Middle

I am going to be asking a variety of questions. The design that has the best outcome of results I will be using to design for the estate agents. Questions Design 1 Design 2 Design 3 1) What Design is the clearest to understand overall? 12 5 3 2) What font is the clearest to read? 15 2 3 3) What colour scheme is the most simple and not too over done and matches the companies colour scheme white, blue and orange? 8 7 5 4) Which buttons of all three of the designs are the best sizes? 10 2 8 5) What layout is the clearest to look at? 9 8 3 As the survey states Overall design 1 is the best design. Overall out of all three designs I believe that design 1 is the most appropriate to use in an estate agents. From the questions I asked the majority of people choose design 1 as the best of all questions. This shows that design 1 is the best and most appropriate. Look above at all pie charts and you will see this. Menu structure diagram Data flow of switch board: Final designs - justification Test plan Test Purpose of test Test method Expected Result 1 Check Programme loads up Double click on the Microsoft Access icon. Microsoft Access loads up. 2 See if file opens Click on the open icon on the top toolbar (It is a yellow folder) and see if your work is saved on there by browsing through then double click it to open once you have found it. File loads up. 3 Save function Click on the save icon on the top toolbar to save your work. Work saves on Microsoft Access. 4 Check if buttons work. Follow through switchboard to see if all buttons are going to the correct places. The buttons take you to the correct place. ...read more.

Conclusion

Also some staff have problems constantly using a computer at work and would prefer to have larger text to help there eyes from straining. o Lastly we believe that the buttons could be larger so its easier to just click through the database. Except from a few improvements that could be made overall we believe that the database is fantastic. There are lots of great features that have made this database a great success. Down below we have listed a few favourite qualities of the database. o We believe that the colour scheme is excellent as is matches our companies colour scheme exactly. o We also believe that the forms layout is great and fits onto a page well. We do not have to scroll down or up to get to what we want. o Lastly personally I believe that the queries that are asked are just what we need. We will be able to find a customer/property very fast. We would like to thank you so much for the effort you have put into the database, we are so pleased and would like you to design future plans for us. This has solved our problem, Once again thank you. Yours Sincerely The Lucy's Estate Agents Company Mrs Dickinson Further ideas for improvements There are many factors that could be further improved with this database. I will be listing them down below. o Firstly I believe that by putting a print macro on every page would be easier for Mrs Dickinson and staff to print off reports. o Also I believe a great improvement would be to make the text larger on reports and forms so it makes the users work a lot easier. o Lastly I believe that a wider range or queries should be on the database to make Mrs Dickinson's work a lot easier. I cannot think of any more major improvements that can be made to this database. I have put a lot of effort into the new system and hopefully Mrs Dickinson uses my design. ...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 Communications 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 Communications essays

  1. In this piece of coursework I will be looking at how Tesco uses ICT ...

    Purchasing in Tesco Tesco's modern technology allows them to have a self-order system. This is an automatic re-ordering system for when goods get too low on the shop floor. The laser scanners and barcodes are used to identify all products individually that are sold.

  2. Web design Coursework (Evaluation part 5)

    Also I love the colours and other images used in the website as the compliment each other. However I found that some of the information you have put into the website is quite useless so I would like to see less information that is useless and more information that tells

  1. special needs

    them when studying and consuming and seeking awareness of a particular topic at primary, secondary or further or in basic terms; higher level. The software itself has widely assisted these groups of people and in the same way it has enabled Maria to have a better working conduct in her life.

  2. Free essay

    Impact of ICT in Community

    The phone lets you to send text message and received text messages. * The user can listen to their phonebook, call registers, received and edited messages, caller identification, signal coverage and other common mobile phone functions * The Phonebook which lists name can store up to 250 addresses, home phone,

  1. A report on how ICT affects me as an individual, and other members of ...

    I can listen to the music of my own choosing. My mp3 player is small and portable with personal ear phones. I can wear it around the house or take it out with me including when I go on holiday or long journeys.

  2. Information Security.

    to it * Integrity : information should be modified only by those who are authorized to do so . * * Availability : information should be accessible to those who need it when they need it These concepts apply to Internet users just as much as they would to any corporate or government network.

  1. SK-II has already established as a leading brand within its' skin-care industry. By empowering ...

    OnLine Chat room service Forum service SK-II online skincare consultation and education services: As per our suggested improvement in sub-section 6.4.2 "Partner with net-based training companies to provide cosmetic training to net surfers", this skincare consultation and education services can achieve the following purposes: * Gain more confidence to SK-II

  2. Development of a set of marketing recommendations, marketing mix campaign and customer care initiatives.

    of the benefits of a product and assist them in their buying decision. As the Internet becomes more wide spread more access devices are become available. These two are: * Interactive TV This has a dedicated Internet access set up boxes.

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