TEST OF PRACTICAL KNOWLEDGE QUESTION INSTRUCTIONS: (a) Sort the table on SURNAME and FIRST NAME in ascending order. (b) Delete the record for employee 279. ...

TEST OF PRACTICAL KNOWLEDGE QUESTION

INSTRUCTIONS: (a) Sort the table on SURNAME and FIRST NAME in ascending order.

(b) Delete the record for employee 279.

(c) Create a report from the table and name it SALARY. The header of the report should read "EMPLOYEE SALARY".

(d) Format:

(i) the column headings of the report with font size 14pt and bold;

(ii) the other inputs with, font size 12pt.

(e) Apply border line.

(f) Insert your full name and index number.

(g) Print and submit to the supervisor