Photo AI
Open the 7Statem word processing document which will be used for a mail merge with the tbClients table in the 7Acc database - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Question 7
Open the 7Statem word processing document which will be used for a mail merge with the tbClients table in the 7Acc database. 7.1 Link the 7Statem mail merge documen... show full transcript
Worked Solution & Example Answer:Open the 7Statem word processing document which will be used for a mail merge with the tbClients table in the 7Acc database - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Step 1
7.1 Link the 7Statem mail merge document to the tbClients table in the 7Acc database as a data source.
Answer
To link the 7Statem mail merge document to the tbClients table in the 7Acc database:
- Open the 7Statem document.
- Go to the 'Mailings' tab.
- Click on 'Select Recipients' and then choose 'Use an Existing List'.
- Navigate to the 7Acc database and locate the tbClients table.
- Select this table and click 'Open' to establish the link.
Step 2
7.2 Replace the text '<Insert Initials>' and '<Insert Surname>' with the initials field and surname field respectively from the data source.
Answer
To replace the placeholders:
- In the 7Statem document, locate the text '<Insert Initials>'.
- Highlight it, and then from the 'Mailings' tab, select 'Insert Merge Field'.
- Choose the appropriate field for initials from the list.
- Repeat the process for '<Insert Surname>' to insert the surname field.
Step 3
7.3 Complete the form as follows:
Answer
-
Insert a form control in the cell next to the text 'Current Date':
- Click on 'Developer' tab > 'Insert' > choose 'Date Picker'.
- Place it in the designated cell.
-
Edit the form control in the cell next to 'Amount Due':
- Select the control, go to 'Properties', and set the 'Format' to 'Currency', ensuring it displays two decimal places.
-
Insert a drop-down form control in the cell next to 'Payments':
- Go to 'Developer' tab > 'Insert' > choose 'Combo Box'.
- In the properties, set the list options to 'Up to date' and 'Behind'.
Step 4
7.4 Use the data in the spreadsheet to create a chart similar to the example shown below.
Answer
To create the chart:
- Open the 7Chart spreadsheet and select the data for 2014.
- Go to the 'Insert' tab and choose a 'Column Chart'.
- Use the 'Design' options to set the scale on both axes, ensuring the y-axis goes up to 10000.
- Label the x-axis with corresponding months: 'Jan 2014', 'Apr 2014', 'Jul 2014'.
- Include data labels and ensure the legend reads 'Cars Sold'.
Step 5
7.5 Open the 7Answ word processing document and insert your examination number.
Answer
To complete this section:
- Open the 7Answ document.
- Insert your examination number at the designated location.
- For each query, answer with the correct number of records and methods:
- For how many records contain 'wood' in the city name: Use a filter on the city field with criteria like '%Wood%'.
- For buyers with two initials: Apply a query filtering with criteria 'Like "??"'.
- For the average price of car buyers from Durban: Filter by city 'Durban' and calculate average price.