• 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

    and a network with the computers and hardware devices must be established. As letters are handwritten at the moment some of them may not be understandable to read, to solve this problem I have decided to create and include a button within the database programme which will be linked to

  2. Moviezone video rental system.

    Access 2000 has more powerful features than PinPoint for customising a system such as macros and menu screens, which can be used to make it more user friendly. Mr and Mrs Marshall don't have Access 2000 on their computer but they have �1000 to spend on hardware and software so they can afford to buy it.

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

    * It takes a long time to look through the loans box to find out which videos are overdue. * It takes a long time to write out reminder letters by hand which are sent to customers who have videos that are overdue for return.

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

    If one of these files is missing, then that image is classed as unusable. When an image is inputted into the system, it is stored as a High Resolution image, and a low resolution copy is made instantly by a piece of software running on one of the servers.

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

    Sainsbury also plans to reduce spending on IT and the supply chain. Sainsbury said the following things about its IT * "Sophisticated customer and product segmentation over the past two or three years has required a complex supply chain solution which simply cannot be delivered to the required scale.

  2. Making a mail-merge for the company "mobiles4u".

    The features which makes it very attractive are the word art, clip art, font colour, line colour and fill colour because on word art you can choose lots of different types of styles to put as a title, clip art so that there are pictures and it makes it look better, the colours to make it even more ATTRACTIVE!!

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