Page 43 - My Own Workbook for CSEC Information Technology Examinations

Databaase Management SECTION 6
(d) A calculated field named ‘Surcharge’ is required in the Registrations table. The field will store either $45.00 or $0.00. If the data field ‘Subjects.Practical’ or ‘Subjects.Oral’ contains the value “Yes”, the value $45.00 should be stored, otherwise $0.00 should be stored.
Write a query to create this field.
.................................................................................................................................................................................
.................................................................................................................................................................................
(e) A report is required that lists each candidate (in alphabetical order) and the subjects for which that candidate is registered. The report should show the number of subjects for which each candidate is registered.
State how EACH of the following reporting features could be used to produce the report required.
(i) sorting
.................................................................................................................................................................
.................................................................................................................................................................
.................................................................................................................................................................
(ii) grouping
.................................................................................................................................................................
.................................................................................................................................................................
.................................................................................................................................................................
(iii) summary features
.................................................................................................................................................................
.................................................................................................................................................................
.................................................................................................................................................................
(f) A report may be previewed on the screen. List TWO OTHER options for generating a report.
................................................................................................................................................................................. ................................................................................................................................................................................. .................................................................................................................................................................................
IT-book-edited-8,3x11,7.indd 81
9/11/18 7:25 PM
Copyrighted material. All rights reserved.
9 789769
611337
78
DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE