The municipality keeps track of companies contributing to the pollution problem - NSC Computer Application Technology - Question 5 - 2021 - Paper 1
Question 5
The municipality keeps track of companies contributing to the pollution problem. As part of the effort, they also investigated residents' recycling habits in terms o... show full transcript
Worked Solution & Example Answer:The municipality keeps track of companies contributing to the pollution problem - NSC Computer Application Technology - Question 5 - 2021 - Paper 1
Step 1
5.1.1 Change the field size of the Coverage field to Decimal.
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
In the tbl5_1 table, navigate to the Coverage field and modify its properties to set the field size as Decimal. This allows for more precise data entry related to coverage values.
Step 2
5.1.2 Insert a combo box for the PollutionType field with the values Air, Land and Water.
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
For the PollutionType field, insert a combo box. Set the Row Source to include the values 'Air', 'Land', and 'Water', allowing users to choose from predefined pollution types rather than typing them in.
Step 3
5.1.3 Values entered for the Level field must range from 100 to 1 000.
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
To enforce data integrity, set a validation rule for the Level field as 'Between 100 And 1000'. This ensures that the user can only enter valid levels within the specified range.
Step 4
5.1.4 Insert a field called Evidence with a suitable data type.
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
Add a new field named Evidence. Choose the appropriate data type to store documents or files, such as an Attachment or Hyperlink, ensuring proof of actions can be included in this field.
Step 5
5.2 Modify the form called frm5_2.
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 frm5_2 in Design View. Change the form header to 'Survey'. Insert a data control in the footer for displaying the date only. Apply the NewDrop header to the form and set the YearBorn field format to Medium Date.
Step 6
5.3 Display the average number of drop-offs for each recycling activity.
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 query qry5_3, group the results by RecyclingActivity. Use the AVG function to calculate the average number of drop-offs. Ensure that the output is formatted to display as an integer to meet data presentation requirements.
