Week 14 Unit 3

Summer holidays have finished!! Back to working on this ICT problem. I have started to complete bits and bobs that I had left incomplete like the mail merge letters and the rest of the queries I need to create.

I have first of all created both letters regarding payment reminders and revision classes that have been attended which are part of the milestones;
milestone 4 (for select information) which is to send out a letter stating the outstanding amount owed: The screenshot shown on the left confirms the completion of this as it shows the mail merged letter. This can also be found in 2b select information. I didn't face any difficulties with this.





This letter on the other hand is about revision classes and sends out letters to students who have been entitled to a £5 discount raising awareness of the fact this has been deducted and they now owe £5 less or maybe even a refund of the amount.  I had produced this using my query where I created a list of students who had attended. I had imported in the contacts through this.

For this section I have yet to make reports based on the queries that I have created which I plan to proceed with next week.