• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1859

mail merge

Extracts from this document...

Introduction

Identification My granddad, Sam Screen, runs a local video and game rent or buy shop and he is finding it hard to update all the customers about returning late videos or games, because of the large amount of customers he has received over the years he has had the shop. The customers who have not sent back the video/game will get a notification letter of a continuous 6 hour fee, if a customer is abroad it will be a daily fee. One of our customers name is called Adam Sate, his phone number is 07658548358 and he lives in 117 Edgware Road, London, Middlesex, I17 H1O One way I could help him is to just write out the letters by hand and then send them out to the customers, another way I can help him by using mail merge so he could write 1 letter but when completed he would have (if needed) 10 letters ready for printing then mailing. Using mail merge this will also help him by keeping a documentation of all his customers, addresses and phone numbers for future reference. The advantage of using ICT over manual methods is that you can write out the letter you want, copy it and paste, it for however many letters you want then you can type in all the addresses, names and also prices. Another advantage of using ICT is that instead of typing out the letter and copying and pasting then typing in the names, addresses, phone numbers ect... ...read more.

Middle

which links to a piece of software turning the picture of the Membership details into data which is then inputs the details such as videos, name and address into a complicated Microsoft access database. If this does not work I will have to put in the man power to convert all of the data manually into the computer system, once this is done I can move onto using my facilities such as Microsoft Access so I can start customizing my database and use my other facility Mail merge to create and test out the invoices or queries No Yes No Yes No Yes No Yes No Yes No Yes No Yes No Yes Yes No No Yes Output: I will now be talking about the various functions that the PC will actually produce for me. The first is screen based; this is so that I can see what I am doing on the PC. The second is printed; this is so that when I have finished my work (Mail Merge letter) I can have it on a sheet ready to be sent off. The paper size I am going to use is A4 this is because if I have a too small piece of paper everything will be squashed together and hard to read, and if the piece of paper is too big it is a waste of money, it will need a bigger envelope which will cost more money and when the customer opens the envelope the sheet will bee to large to handle. ...read more.

Conclusion

in the centre, the customer address at the top of the page above the contents of the letter, and finally the signature and the name of the manager underneath the contents of the letter on the left hand side. I made these changes to the design because it made the letter look extremely untidy, and I also made these changes because all the information was all over the letter and really confusing to look at. Dear Mr Jordan Ezekiel, I think that your method of helping me organise all of my customer's information and writing out all of the letters was quite helpful and it also made giving out letters to customers a lot easier and it also saved a lot of time. Based on the problem beforehand these solutions were very helpful. One other problem however, is that I have so search through all of the customers return dates every day and this can take up a lot of time. In addition to the new system I have an idea of making ID cards for each customer or a new customer. Yours sincerely, Mr Sam Screen Further improvements to this work is that I could use the software called Microsoft Excel and I will use this software so that it indicates when a video/game is overdue, and after this if there is a website their will be a managers account and this will also automatically update on late videos/games and this will be in date order. ...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. Recommending hardware and software for an ebay company.

    The business accounts are kept on a spreadsheet file and updated weekly. The PC is also used regularly for online banking. The business owns a domain name and setting up a website advertising the online shop is a possibility for the future.

  2. To investigate and try solving the information handling problems of MovieZone a small video ...

    Thank you for taking the time to complete it. Please hand it in to receive your free rental voucher (one per customer only). Interview questions Sample documents Problem Description This project will aim to solve the information handling problems of MovieZone Video a video rental service based in Kidsgrove, Stoke-on-Trent.

  1. Creating a computer system for a video rental shop

    had had to collect my own user information on the requirements of the new system and what the problems were with the new system there are four techniques I could use these are: - 1. Interviewing staff at different levels about the present system and what they would like to see from the new system.

  2. Moviezone video rental system.

    This will cost �450. To install and run this software they will need to upgrade the memory in their computer from 16Mb to 24Mb. This will cost �40. Mr and Mrs Marshall will also need to buy a printer so that they can print out things like lists, reports and letters to members with overdue videos.

  1. ICT Case Study Coursework - Hull Daily Mail Publications Ltd.

    * Storage and access for user software All of the software for the users is stored on their local Hard Disk. This is because it is a lot quicker to load a program, and it saves unnecessary network traffic. When a machine is set up there are no access restrictions

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    The new automated depots are failing to perform at the planned levels." * "IT systems have also failed to deliver the anticipated increase in productivity and the costs today are a greater proportion of sales than they were few years ago."

  1. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    The assistant finds the card with the member's details on it in the members box. The member is asked to confirm their name and address as a security check. If the details that the member gives match the ones on the card the assistant asks how many days they want to rent the video for.

  2. ICT Solutions.

    fun to create, but decided against Powerpoint because it is used for presentation purposes and it won't solve my problem because all my friends would have to sit at a computer to get the recipes. Also I am using Word because my project involves a lot of writing, formatting text

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