Question 3
- Sort the table on SURNAME and FIRST_NAME in ascending order.
- Delete the record for employee 279.
- Create a report from the table and name it SALARY.
- Format:
- Apply border line.
- Insert your full name and index number.
- Print and submit to the supervisor.
Using a database application, design a database for employee salary table as shown below:
I.D. |
SURNAME |
FIRST_NAME |
JOB TITLE |
SALARY |
134 |
IBRAHIM |
HAMZA |
ACCOUNTANT |
300,000 |
160 |
ADEMOLA |
AYO |
ENGINEER |
350,000 |
198 |
OBI |
NDIDI |
CLERK |
150,000 |
264 |
YUSUF |
GARBA |
MESSENGER |
100,000 |
279 |
OSUNDE |
AMINA |
PROGRAMMER |
400,000 |
340 |
MAMUDU |
ENIOLA |
MANAGER |
500,000 |
INSTRUCTIONS
The header of the report should read “EMPLOYEE SALARY’.
(i) the column headings of the report with font size 14 pt and bold;
(ii) the other inputs with font size 12 pt.
Observation
The expected answers were:
Candidates were required to use MS Access to create a database table.
The chief examiner reported that most of the candidates’ responses showed poor knowledge of the application. Majority of those who attempted this question were reported to have used MS Word to perform the task.