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.