Fig. 1 shows part of a database form used by a mobile bicycle-repair service. A client completes the form when booking a repair. The technician wants to avo...
Question 1 Report
Fig. 1 shows part of a database form used by a mobile bicycle-repair service. A client completes the form when booking a repair. The technician wants to avoid inconsistent values in the RepairType field because these values will later be used in a query and a report. The service stores the client ID, contact number, bicycle type and requested repair. During task a2, the technician must create a form that is easy for staff to use and must save evidence in a document.
The diagram is a draft only. Staff must be able to select standard repair descriptions without typing a different spelling each time.
(a) Identify the form control shown for RepairType. [1]
(b) Give one benefit of using this control for the RepairType field. [1]
Answer Details
(a) The RepairType control is a combo box, also called a drop-down list. [1]
(b) It lets staff select from standard repair descriptions rather than typing freely. This prevents spelling variations such as different versions of the same repair and makes later queries and reports consistent. [1]
Download The App On Google Playstore
Everything you need to excel in your exams
