Get premium membership and access revision papers, questions with answers as well as video lessons.

Coe 121: Inroduction To Computer Applications Question Paper

Coe 121: Inroduction To Computer Applications

Course:Bachelor Of Electrical And Computer Engineering

Institution: Moi University question papers

Exam Year:2012

1. The data entry clerk at Kenya Women Finance Trust (KWFT) wishes to process the employees’ payroll using the following information organized into PERSONAL and SALARY tables.

PERSONAL TABLE

NAME GENDER AGE ID NO DISTRICT DEPARTMENT
Monica Lewa Female 29 22804850 Taveta IT
Caroline Omondi Female 31 28405160 Migori Marketing
Leonida Kirwa Female 43 21604850 Nandi Marketing
Thomas Wafula Male 34 20468056 Bungoma Accounts
Grace Otieno Female 45 20867074 Siaya Purchasing
Jane Ndanu Female 27 20214850 Machakos Communication
Zainabu Oyiera Female 27 20468470 Kakamega Health
Jane Njeri Female 28 25804856 Nyeri Hospitality
Julias Ndinga Male 35 22804956 Busia Accounts

SALARY’ TABLE

JOB GROUP BASIC PAY NHIF NSSF ID NO COMMUTER ALLOWANCE
K 25000 200 300 22804850 2500
E 17000 200 300 28405160 2500
E 17000 200 300 21604850 2500
J 23500 200 300 20468056 2500
D 15000 200 300 20867074 2500
L 28000 200 300 20214850 2500
G 19000 200 300 20468470 2500
H 21000 200 300 25804856 2500
L 28000 200 300 22804956 2500

a) i) Create a database called KWFT SYSTEM and design the above tables

ii) Use combo box property to enter information under department and job group column
ii) Set the validation rule and the corresponding validation text for gender column.
b) i) Create the relationship between personal and salary table
i) Create a query with the fields names, NAME,DEPARTMENT ,JOB GROUP,BASIC PAY,NHIF,NSSF and COMMUTER ALLOWANCE in that order
ii) Modify your query by adding the fields:
HOUSE ALLOWANCE, TOTAL ALLOWANCE, TOTAL DEDUCTIONS, GROSS PAY and NET PAY in that order given that house allowance is calculated as 15% of the basic pay. Save your query as SALARY QUERY in the root of the diskette.
c) i) Use SALARY QUERY to create a form with the following labels:
NAME,BASIC PAY,NHIF,NSSF,COMMUTER ALLOWANCE,HOUSE ALLOWANCE,TOTAL ALLOWANCE,GROSS PAY,TOTAL DEDUCTIONS and NET PAY in that order.
i) Add “PAY SLIP” as the form header and format it with 12 points bold with Garamond type face

b) i) Using SALARY QUERY, create a tabular report with the following headings in the order listed
NAME, BASIC PAY, TOTAL ALLOWANCE, GROSS PAY, TOTAL DEDUCTIONS and NET PAY.

ii) Format it using formal style. Apply 14 points bold and white font colour in a dark red background for titles and 10 points aerial narrow with blue font colour for the rest of the text all centered.
iii) Save the report as SALARY REPORT in a landscape orientation.

i.

Coe 121: Inroduction To Computer Applications Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams