Observation

    (a) Steps involved in creating the query
                   In MS Access,

• click on Create;
• select Query Design;
• add table tblCustomer to QBE interface;
• select the field lastName from the grid;
• select the field firstName from the grid;
• select the field Town from the grid;
•  type ‘John’in the Criteria rowunder lastName field;
• tick all the check boxes.in the Show row, under lastName, firstName and Town fields.

         (b)    Steps to generate the SQL statement for the action in 4(a)

• Right click on Query (QBE) Interface;
• select SQL view.

                                    OR

• From Design view, click view;
• select SQL view.

                                    OR

• Click on SQL at the bottom right corner.

The question tested candidates’ knowledge of database management system.
It was reported that candidates’ responses showed poor translation of practical skill in database management system.