A charity repairs donated laptops for students. Its database records DeviceID, DeviceType, FaultDescription, RepairHours, PartsCost and ReadyForCollection. ...
Question 1 Report
A charity repairs donated laptops for students. Its database records DeviceID, DeviceType, FaultDescription, RepairHours, PartsCost and ReadyForCollection. The workshop supervisor needs a query to find laptops that took more than 3.5 hours to repair and are ready for collection. The results will be used to create a report for the collection desk. DeviceID, FaultDescription and PartsCost must be shown, with PartsCost sorted from highest to lowest.
The supervisor has asked an assistant to complete task a2 using the query design view. The assistant must save the query as ReadyLaptopsLongRepair and place a screenshot in the document task. A form is used for entering repairs, but the query must use fields from the stored database table rather than values typed into the report.
(a) Create the criterion for DeviceType. [1]
(b) Create the criterion for RepairHours. [1]
(c) Create the criterion for ReadyForCollection. [1]
(d) Create the sort order for PartsCost. [1]
(e) Give one reason why FaultDescription should be included in the report. [1]
Answer Details
(a) Use Laptop as the DeviceType criterion. [1]
(b) Use >3.5 as the RepairHours criterion. This means more than 3.5 hours, not 3.5 hours exactly. [1]
(c) Use Yes or True as the ReadyForCollection criterion. [1]
(d) Sort PartsCost in descending order to put the highest costs first. [1]
(e) FaultDescription helps collection staff identify the repair or check that the correct device is being collected. [1]
Download The App On Google Playstore
Everything you need to excel in your exams
