A sports centre holds a database of equipment loans. A clerk is designing a form so reception staff can record returns quickly. The fields are LoanID, Membe...
Question 1 Report
A sports centre holds a database of equipment loans. A clerk is designing a form so reception staff can record returns quickly. The fields are LoanID, MemberID, EquipmentName, DateOut, DueDate, DateReturned and DamageCharge. The manager wants a query identifying equipment returned late during June 2026 where a damage charge is greater than 0 dollars. The report must show MemberID, EquipmentName, DueDate and DamageCharge.
The clerk will save the form and query, then include a screenshot in the document task as evidence. DateReturned must be completed before the query is run. The clerk also needs to prevent a negative DamageCharge because a charge cannot be less than zero. The database will be used by several reception staff, so clear field labels are important.
(a) Create a validation rule for DamageCharge. [1]
(b) Give suitable validation text for the DamageCharge field. [1]
(c) Create a criterion for DamageCharge. [1]
(d) Create a date range criterion for DateReturned during June 2026. [2]
(e) Explain why EquipmentName is included in the report. [1]
Answer Details
(a) Use the validation rule >=0. A damage charge cannot be negative. [1]
(b) Suitable validation text is: Enter zero or a positive charge. [1]
(c) Use >0 as the DamageCharge query criterion, since the report is for records with a charge greater than zero. [1]
(d) Use >=#01/06/2026# and <=#30/06/2026# for DateReturned. This includes all returns during June 2026. [2]
(e) EquipmentName tells staff which item was returned late and had a damage charge. [1]
Download The App On Google Playstore
Everything you need to excel in your exams
