• 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

    You can highlight a cell by first clicking on the cell you want and then the fill colour icon, which brings up a range of colour, you can also colour the text or lines. * There is a formula bar at the top, which displays the formula of the cell

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

    The computers are used to control the stock and are connected to the checkouts. Theses are the 'branch computers'. The computers are multifunctional, and each can access the data, which gives the management a number of access points. Sainsbury admin and stock control staff now have access to hand held computers, SEC (Shelf Edge Computers).

  1. System requirements analysis

    The booking software is very easy to use and the layout is quite clear. 'Excel' comes with the 'Microsoft office' package and it comes quite cheaply. This would be ideal for the health centre as it has only just opened and has a low budget.

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

    Information about videos on loan is stored in another card index box. When a customer wants to rent a video they take it from the shelf and hand it to the shop assistant who takes the video's details card from inside its case and asks the customer for their membership number.

  1. 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!!

  2. Main aims and functions of Buckingham Bingo.

    * The other function of this department is to collect plates, cups and cutlery. After everything has been collected they then wash and clean them in the kitchen. * The supervisor of this department has to keep on top of the stock levels, if they running out of stock the

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