Open the 5Support database - NSC Computer Application Technology - Question 5 - 2021 - Paper 1
Question 5
Open the 5Support database.
5.1 Open the tbl_5_1 table in Design View and change it as follows:
5.1.1 Insert a new field, RegionId, as follows:
- Place the new fie... show full transcript
Worked Solution & Example Answer:Open the 5Support database - NSC Computer Application Technology - Question 5 - 2021 - Paper 1
Step 1
5.1.1 Insert a new field, RegionId, as follows:
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
Start by opening the tbl_5_1 table in Design View. Insert a new field called RegionId as the first field. Set this field as the primary key and configure its data type to 'AutoNumber' to automatically assign numbers. Then, change the 'New Values' property to 'Random' to ensure unique random values are assigned to the field.
Step 2
5.1.2 Change the RegionCode field as follows:
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
While in Design View, examine the RegionCode field to understand its format. Set the field size appropriately. Create an input mask with the format >LL0099 to restrict user input to the specified format.
Step 3
5.1.3 Change the StaffAvailable field to automatically display the value 10.
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
In the Design View, select the StaffAvailable field and set its 'Default Value' property to 10 to ensure it automatically fills this value for future records.
Step 4
5.2 Create a form called frm5_2 based on the tblVolunteers table:
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
Create a new form named frm5_2 based on the tblVolunteers table. Insert a control in the form header to display your examination number, ensuring it's visible in Design View but hidden in Form View. Change the CountryToVolunteer field's text box to a combo box linked to the tblCountry for easier selection.
Step 5
5.3 Open the qry5_3 query and display only records for return volunteers:
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
Open the qry5_3 query in Design View. Set criteria to display records where the ReturnVolunteer field is 'Yes' and NumberOfWeeks is greater than or equal to 20. Sort the records by the Surname field in ascending order.
Step 6
5.4 Open the qry5_4 query and display specific fields:
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
In qry5_4, display only the fields: Name, Surname, CountryToVolunteer, and MedicalService. Apply a filter to show records of volunteers who are not involved with HIV/Aids and ensure they either volunteered for Zimbabwe or Angola.
Step 7
5.5 Modify the qry5_5 query to display 17 records:
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
Modify the qry5_5 query to ensure it displays 17 records. Include calculations for SumOfNumberOfWeeks and sort by MedicalService. Set criteria for the StartingDate within the specified range for the records to be included.
Step 8
5.6 Edit the rpt5_6 report based on the tblVolunteers table:
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
Open rpt5_6 in Design View. Insert the $Rescue image, resizing the image box to 1.6 cm high and 2 cm wide. Add a grouping based on the ReturnVolunteer field. Finally, include a suitable label for the MedicalService group.
