Question 7 – Integration 7.1 Newsletters will be poste…
Question 7 – Integration 7.1 Newsletters will be posted to guests who visited ‘The Tigers Canyon’. Carli asked you to help her prepare envelopes for the newsletters.Open the 7Envelopes_Koeverte word processing file and continue working in it. 7.1.1 Use the Visitors_Besoekers table in the 7Invited_Genooi database as the source for the mail merge. (1) 7.1.2 The following information should appear, in this order, on the envelopes. (Use the number 10 envelope) Right-click on this button and select the “Open link in new tab” option (2) 7.1.3 Only South African guests will receive the newsletters. (1) 7.1.4 Save the 7Envelopes_koeverte document and complete the merge. Save the completed envelopes as 7Merged_Saamgevoeg. Save and close all the merged documents. (1) 7.2 Export the Visitors_Besoekers table in the 7Invited_Genooi database to an HTML document Save this document with the name 7Export_Uitvoer. Save and close the database file and the html file. (1) (1) 7.3 Open the 7Info spreadsheet and work in the Decline_Afname worksheet 7.3.1 Insert the name of the worksheet as a field in the header of the document. (1) 7.3.2 Change the effect of the image that appears in the Decline_Afname worksheet to the ‘Metal Frame’- effect. (1) 7.4 Copy the chart in the 7Info spreadsheet and paste it in the 7Paste_Plak document, so that the chart updates automatically if the information changes in the spreadsheet. Save and close the 7Paste_Plak and the 7Info documents (1) (1) 7.5 Open the 7Protect_Beskerm spreadsheet. Protect the range A1:B12 in the Password_Wagwoord worksheet. Use the password ‘123’. Save and close the 7Protect_Beskerm file. (2) 7.6 Open the 7Circus_Sirkus word processing file 7.6.1 Remove the line numbers that were inserted in the document (1) 7.6.2 Convert the text, which is highlighted in a yellow colour, to a two-column table. (2) 7.6.3 Format the date in the text box filled with a green colour to the yy-MMM-dd format. (1) 7.6.4 Place a horizontal line above the text that appears in the footer of the document. (1) 7.6.5 Remove the bookmark that appears in the document. (1) 7.6.6 Change the vertical alignment of the whole document to centre. (1) Save and close the 7Circus_Sirkus word processing file