• 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. In this (2b) report I am going to investigate software application, Input and Output ...

    How/Why Sainsbury uses Internet? Sainsbury supermarkets now have websites which allow it to shop over the internet, this has allowed them access to different markets i.e. people who do not have transport to get to the store. Sainsbury have recognised that the internet allowed people to interact with each other in a different way,

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

    Possible Solutions MovieZone Video Rental could employ someone to organise his record collection, choose records for each disco and write their details down for him. If this were someone's job they would have more time to choose records and make sure that the lists didn't get lost.

  1. Creating a computer system for a video rental shop

    Objectives for the New Systems Qualitative 1. Data entry should be as intuitive as possible. 2. The input screens should explain themselves. 3. Data entry should be quick. 4. The mechanics of the application chosen should not be apparent to the user. 5. A main menu should be loaded automatically when the database is loaded, and the whole system should be menu driven.

  2. Main aims and functions of Buckingham Bingo.

    * Booksales - The type of supplier this department needs is a company that supplies bingo books and bingo equipment. This department use's up huge amounts of bingo books each week, so they need a company that can supply this and at a quick speed.

  1. Moviezone video rental system.

    The assistant works out the date that the video will due back and writes it on the video details card, which is then attached to the member details card with a paper clip and put into loans box. When a video is returned the assistant searches through the loans box to find the video and member details cards.

  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