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 tbClients Table
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To link the 7Statem document to the tbClients table in the 7Acc database, navigate to the Mailings tab, select 'Select Recipients', and choose 'Use an Existing List'. Locate the 7Acc database and then select the tbClients table as the data source.
Step 2
7.2 Replace Placeholder Text
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In the document, replace '<Insert Initials>' with the field for initials from the data source and '<Insert Surname>' with the surname field. These will dynamically update based on the data source.
Step 3
7.3 Complete the Form
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Insert a Date Picker control next to 'Current Date' to allow date entry. For 'Amount Due', change the control to accept numerical values in rand currency format with two decimal places. Add a drop-down control next to 'Payments' and set its options to 'Up to date' and 'Behind'.
Step 4
7.4 Create a Chart in 7Chart Spreadsheet
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In the 7Chart spreadsheet, select the relevant data for the year 2014, then insert a bar chart. Ensure that the x-axis lists months ('Jan 2014', 'Apr 2014', 'Jul 2014'), the y-axis is scaled appropriately (up to 10000), and the legend is labeled 'Cars Sold'. Finally, add data labels to the chart to display values.
Step 5
7.5 Record Count for 'wood' in City Name
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find out how many records contain the text 'wood' in the city name, perform a filter operation where the city contains 'Wood'. The result should show a total count of 10 records.
Step 6
7.5.2 Count Buyers with Two Initials
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To determine how many records contain buyers with two initials, use a criteria in a query that looks for initials fitting the criteria: Like '??' or LEN(Initials) = 2. The result returns 113 records.
Step 7
7.5.3 Average Price for Car Buyers from Durban
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find the average price paid by car buyers from Durban, filter the city field to 'Durban', then use the Average function on the price field to compute the average, resulting in an average of 125350.13.
