Maak die Tigers_Tiere-verslag oop en verander as volg: 5.13.1  Verwyder die veld genoem Gender_Geslag uit die verslag. (1) 5.13.2  Groepeer die verslag volgens die Country_Land-veld. (1) 5.13.3  Verwyder die prentjie gestoor as AnimalLove_Diereliefde wat as die agtergrond vir die verslag dien. (1) 5.13.4  Voeg ‘n funksie in die verslag in om die totale aantal besoekers (volwassenes plus kinders) per land te bereken. Verskaf ook ‘n geskikte etiket (‘label’) vir hierdie berekening. (4) 5.13.5  Formateer die prentjie in die verslag kopskrif (‘report header’) na ‘zoom’. (1) 5.13.6  Voeg ‘n hiperskakel in die verslag om te koppel (‘link’) met die Visitors_Besoekers-tabel. (1) 5.13.7  Voeg bladsynommers in die ‘page N of M’-formaat in die bladsyvoetskrif (‘page footer’) van die verslag in. Die eerste bladsy van die verslag moet nie genommer wees nie. (3)   Stoor en maak die Tigers_Tiere-verslag toe.         Stoor en maak die 5Guests_Gaste-databasis toe. Laai jou gestoorde weergawe van 5Guests_Gaste.accdb onder Vraag 5.2 in die OPLAAI Quiz op (GEEN PDF / .laccdb LêERS NIE)

Question 2 – Word processing Carli created an electronic form for guests to make bookings Open the 2Bookings_Besprekings document. 2.1 Remove the watermark that appears in the document. (1) 2.2 Group the two images on the first page of the document (1) 2.3 Find all occurrences of the words ‘Tiger Canyon’ and replace them with the words ‘The Tigers Canyon’, highlighted in a yellow colour. (2) 2.4 Locate the bulleted list on page 1 of the document. Right-click on this button and select the “Open link in new tab” option Format the bulleted list as follows: Change the bullets to the Webdings symbol (character code 228).  Align the bullets at 0.5 cm from the left margin. Set the distance between the bullets and the text at 0.5 cm. (1) (1) (1) 2.5 Locate the word ‘distinctly’ in the first paragraph of the text. Use a Word Processor feature and replace this word with a suitable synonym. (1) 2.6 Locate the table on the second page of the document. Insert a caption below the table. The caption must read Table 1: Tariffs. (2) 2.7 Continue working in the third row of the table. 2.7.1 Edit the drop-down field in the second column of the third row as follows: Remove the option R970. Add help text ‘Tariff’ to the control. 2.7.2 Work in the last row of the table. Change the text form field in this row to the current date format. (1) (1) (1) 2.8 Go to the ‘Book now!’ section on the last page of the document. Change the options under the heading ‘Book now!’ to resemble the example below: Right-click on this button and select the “Open link in new tab” option **NOTE: Set AND apply a 6cm hyphenated leader tab, as shown above, to ALL options. (3) 2.9 A table of sources has been created for this document. Insert an automatic bibliography below the heading ‘Bibliography’. (1) Save and close the 2Bookings_Besprekings document.

Question 2 – Word Processing   Upload your saved version of 2Bookings_Besprekings.docx here (NO PDF FILES)

OM JOU LêERS OP TE LAAI: Maak seker dat die lêers waaraan jy gewerk het gestoor is op jou rekenaar Maak WORD, EXCEL, ACCESS en NOTEPAD++ toe Al jou lêers moet opgelaai word in die OPLAAI quiz wat volg na hierdie quiz. Sodra jy heeltmal klaar is met jou vraestel, klik die “SUBMIT QUIZ” knoppie regs onder Om dan na die OPLAAI Quiz te navigeer moet jy die “NEXT” knoppie klik (regs-onder) en jy het 15 minute om die lêers waaraan jy gewerk het op te laai Let asb: GEEN .PDF of /.laccdb lêers nie.

Question 7.2   Upload your saved version of 7Export_Uitvoer.html here (NO PDF FILES)

Question 1 – Word ProcessingUpload your saved version of 1Tigers_Tiere.docx here (NO PDF FILES)

Question 6 – Web design (HTML)   Upload your saved version of 6TigerCanyon.html here (NO PDF FILES)

Question 7.5   Upload your saved version of 7Protect_Beskerm.xlsx here (NO PDF FILES)

Question 2 – Word processing Carli created an electronic form for guests to make bookings Open the 2Bookings_Besprekings document. 2.1 Remove the watermark that appears in the document. (1) 2.2 Group the two images on the first page of the document (1) 2.3 Find all occurrences of the words ‘Tiger Canyon’ and replace them with the words ‘The Tigers Canyon’, highlighted in a yellow colour. (2) 2.4 Locate the bulleted list on page 1 of the document. Right-click on this button and select the “Open link in new tab” option Format the bulleted list as follows: Change the bullets to the Webdings symbol (character code 228).  Align the bullets at 0.5 cm from the left margin. Set the distance between the bullets and the text at 0.5 cm. (1) (1) (1) 2.5 Locate the word ‘distinctly’ in the first paragraph of the text. Use a Word Processor feature and replace this word with a suitable synonym. (1) 2.6 Locate the table on the second page of the document. Insert a caption below the table. The caption must read Table 1: Tariffs. (2) 2.7 Continue working in the third row of the table. 2.7.1 Edit the drop-down field in the second column of the third row as follows: Remove the option R970. Add help text ‘Tariff’ to the control. 2.7.2 Work in the last row of the table. Change the text form field in this row to the current date format. (1) (1) (1) 2.8 Go to the ‘Book now!’ section on the last page of the document. Change the options under the heading ‘Book now!’ to resemble the example below: Right-click on this button and select the “Open link in new tab” option **NOTE: Set AND apply a 6cm hyphenated leader tab, as shown above, to ALL options. (3) 2.9 A table of sources has been created for this document. Insert an automatic bibliography below the heading ‘Bibliography’. (1) Save and close the 2Bookings_Besprekings document.

Question 5 – Database  Carli keeps record of all guests that visit ‘The Tiger Canyon’ in a database. Open the 5Guests_Gaste database file. Work in the Visitors_Besoekers table. 5.1 Insert a primary key on the most appropriate field. (2) 5.2 Change the InternetAccess_InternetToegang field to a Yes/No field. Display ‘yes’ and ‘no’ in this field, and not a checkbox (1) 5.3 Change the Surname_Van field so that duplicates will be allowed (1) 5.4 Create a lookup field for the Gender_Geslag field so that either ‘F’ for Female or ‘M’ for Male will be displayed. (2) 5.5 Format the Date of Birth_Geboortedatum field to the long date format. (1) 5.6 The default country must be South Africa (1) 5.7 Use a validation rule in the Adults_Volwassenes field so that no number bigger than 7 will be accepted in this field. Remember to use a suitable validation text in this field. (2)   Save and close the Visitors_Besoekers table   5.8 Open the Tiger_Tier table Use an input mask in the RegNo_RegNo field so that the registration number of the farm is displayed as follows: Three compulsory digits; followed by the ‘/’ sign followed by 3 compulsory capital  Save and close the Tiger_Tier table. (3) 5.9 Open the Information_Inligting query. Sort the query in descending order according to the Surname_Van field. (1) 5.10 Modify the query so that   5.10.1 Only the following fields are displayed: Surname_Van, Name_Naam, and the Date of Birth_Geboortedatum (1) 5.10.2 Display only South African visitors that were born after 1 January Save and close the Information_Inligting-query.  (3) 5.11 Open the Costs_Koste query Create a calculated field with the name ‘Total Amount’ and calculate the total amount of money that each group of visitors had to pay for the stay at ‘The Tigers Canyon’. Save and close the Costs_Koste query (4) 5.12 Open the Details_Besonderhede form.   5.12.1 All names of the Country_Land in the form must appear in italics (1) 5.12.2 Insert today’s date in the header of the form. (1) 5.12.3 Change the list box in the Occupation_Beroep field in the form to a combo (1) 5.12.4 Apply conditional formatting so that the name South Africa, is formatted to a red colour font. Save and close the Details_Besonderhede form. (2)