Computer Studies Paper 3, WASSCE (SC), 2019

Question 3

     

    As a database administrator for a company, create a table named tblEmployee in a database application package containing the fields:

     “Employee Name”,  “Department”,  “Assumption Date”,  “Address” and “Designation”.


    (a)Enter the data as shown in the table tblEmployee:

    tblEmployee

    Employee Name         Department           Assumption Date    Address                     Designation
    Kate Willikie              General Office        03/08/18              3 Lagos Crescent        Secretary
    James Elliot                 Security                  27/11/10              2 Cocoa House Villa  CSO
    Paul Akinson               Admin                    03/11/12             12 Millo Avenue         HRM
    Abdul Kaduna            Registry                  05/06/16               2 Park Lane Rd.          Clerk
    David Madu                Management          22/03/94               34 Lakeside                 MD 

     

    (b)Sort the data using the Assumption date from oldest to newest.


    (c)Create a report in tabular, landscape using the tblEmployee table.


    (d)Insert your full name and index number as a label on the report 


    (e)Save the report as rptEmployee.


    (f) Print your work 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.