• 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

    This can be very useful when using a formula to calculate a certain equation. * You can name cells, which makes identifying cells easier. * Excel is a multi dimensional spreadsheet, this means that you can have as many sheets as you want, this is also known as a three dimensional spreadsheet.

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

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

    * "The contract of Sainsbury with other supermarket is being renegotiated to involve the company more fully in the selection and implementation of systems and IT solutions. Accordingly the company is rebuilding internal capability." Sainsbury's uses several computers which are located in a room known as the system office and form the supermarkets own local area network.

  2. ICT Access

    with an easier process which the paper-based methods were unable to do. Mr. Hock intends me to produce the database as he lacks the IT ability and time, we have both decided Microsoft Access application would be best for the purpose and would influence the proposed audience.

  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.

    It also sells bingo markers which you need in order to play your bingo. * Once this department has finished selling their bingo books etc. it works out how much money has been made and what prize money should be used for each page in the bingo book.

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