Fig. 1 shows a report layout drafted for a meal-delivery database. The report is intended for a driver collecting meals from the kitchen. The query behind t...
Question 1 Report
Fig. 1 shows a report layout drafted for a meal-delivery database. The report is intended for a driver collecting meals from the kitchen. The query behind the report selects orders for Route East that have not yet been delivered. The database includes OrderID, ClientName, Address, MealType, Route, Delivered and DeliveryNote. The driver needs enough information to take the correct meal to the correct client, but the report should not show DeliveryNote because it may contain private information.
The report must be edited before task a2 is saved. The manager also wants a total number of orders at the bottom of the report.
(a) Identify one field shown in Fig. 1 that should be removed. [1]
(b) Give two fields from the database that should be added to the detail section. [2]
(c) Create the criteria required for Route and Delivered. [2]
(d) Explain why a count of OrderID is more suitable than a sum of OrderID. [1]
Answer Details
(a) Remove DeliveryNote. It may contain private information and is specifically not needed for the driver’s report. [1]
(b) Add two useful fields such as Address and OrderID. ClientName and MealType are also valid because the driver needs to identify the client and take the correct meal. [2]
(c) Set Route to East and Delivered to No or False. Both criteria are needed to select undelivered East-route orders. [2]
(d) OrderID is an identifier, so counting OrderID gives the number of orders. Adding identifier values has no useful meaning. [1]
Download The App On Google Playstore
Everything you need to excel in your exams
