As a database administrator for a company, create a table named tbl-Employee 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 tbl-Employee
tbl-Employee
|
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 tbl-Employee table.
(d) Insert your full name and index number as a label on the report.
(e) Save the report as rpt-Employee.
(f) Print your work and submit to the supervisor.
Contributions ({{ comment_count }})
Please wait...
Modal title
Report
Block User
{{ feedback_modal_data.title }}