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

    User feedback Dear Website Designer, I am very impressed with the website you have designed for me and my company and I am very pleased you have managed to get a video into the homepage of the website and I am also very pleased that you managed to get animated Gifs into the website.

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

    I use the VCR when I need to relax for a couple of hours. I use it 2 or 3 times a week. A VCR player/recorder is really good but you are extremely limited to watching those things you have.

  2. Information Security.

    Turn off your computer or disconnect from the network when not in use Turn off your computer or disconnect its Ethernet interface when you are not using it. An intruder cannot attack your computer if it is powered off or otherwise completely disconnected from the network.

  1. special needs

    The software ensures that she can send the CV that she created to the job centre via job centre web pages; online. This allows her to submit her CV online through the relaxation of her own armchair as she needs software to input information, which MS Word clearly aids her to do so.

  2. Free essay

    Impact of ICT in Community

    The phonebook stores up to 250 contacts with entries for: name, address, home phone, mobile phone, office phone and email address. It can help Marry as she can call her family whenever she wants. Marry will also use the mobile phone to stay in contacts with her clients.

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

    The Internet offers many advantages and some disadvantages as an alternative promotional medium. Businesses are also using traditional advertising channel magazines, newspapers and radio etc. (Chaffey and Mayer 2000, pp.41) and (Reuters Business Insight 2000, pp.26) In terms of attractiveness, online advertising offers marketers benefits beyond those offered by traditional media.

  2. Defining computer viruses

    Companies have become involved in e-commerce for a number of reasons. First, the Internet enables them to significantly reduce their transaction costs. For example the cost of conducting a simple bank transaction over the Internet is less than 5% of the cost of conducting the transaction face-to-face and less than 25% of conducting that transaction using an Automated Teller Machine.

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