Quiz 1 COMPUTER PRACTICAL LIII

COMPUTER PRACTICAL. L III

Instruction:

i) time: 1:30 min.

ii) Save your work in Desktop.

1.      Create the following table and save it using a suitable name.

2.      Create a query add two  columns, of “ Tax” and  Net salary where Tax:=15% *salary and Net salary: = salary – tax. “Calculated Query”

3.      Create form based on Query created above. name “Employee salary description.”

4.      Then create a report based on the Query.  name it “Salary report for employee”

5. Print your work.

TABLE 1: EMPLOYEE TABLE

S/N 1 2 3 4 5 6 7 8

FNAME Jones Jane Loise David Charles George Titus Ester

SNAME Thomas Ken Denis Walter Challa Michael Emma Tonny

DEPARTMENT Sales owner Sale accountant Sales Cooker cooker Sales

SEX Male Female Female Male Male Male Female Female

SALARY 4000.00 5000.00 4500.00 6200.00 8900.00 6000.00 6400.00 4200.00