Computer Studies Paper 3, WASSCE (SC), 2018

Question 3

     

    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

    1. Sort the table on SURNAME and FIRST_NAME in ascending order.
    2. Delete the record for employee 279.
    3.  Create a report from the table and name it SALARY.

    The header of the report should read “EMPLOYEE SALARY’.

    1. Format:

    (i)      the column headings of the report with font size 14 pt and bold;
    (ii)     the other inputs with font size 12 pt.

    1. Apply border line.
    2. Insert your full name and index number.
    3. Print and submit to the supervisor.

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.