የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 1 of 7
Sector: Economic Infrastructure Development
Sub Sector: Information Communication Technology
Occupation: Web Development and Database Administration
Candidate Name_________________________________________________
Assessment Center: Misrak Polytechnic College
Assessor Name: _________________________________________________
Assessment Date: _________________________________________________
Candidate’s Package: _________________________________________________
The assessment covers the following units of competence:
Operating database Application
____________________________________________________
____________________________________________________
____________________________________________________
Candidate’s instructions and worksheets
Instructions to Candidate
Methods of Assessment
1. Observation/Demonstration with Oral Questioning/Interview
2. practical assessment
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 2 of 7
Occupation: Web Development and Database Administration
1. Read this booklet carefully
2. All your questions and clarifications should be addressed to the assessor only.
3. Complete the task/project described in this booklet.
4. You are given fifteen (15) minutes reading time and 3 hours to accomplish the whole projects.
5. After you finish this assessment, you are not allowed to copy anything from this booklet or tear any page.
6. You are not allowed to use your own calculator and this must be presented to the assessor before start of
the test
7. After you finish the assessment, you should pack field equipment and return to store.
INSTRUCTIONS TO THE CANDIDATE
Project Information
Given the necessary tools, equipment and information, you are expected to perform the
following project.
The assessor should ask oral questions on which s/he is not satisfied by your performance.
Assessment Venue: Misrak Polytechnic College
Total time for all project: 3 hours
Project : Operating database Application
Total time for the project: 3:00 hours
Competencies covered:
1. Operating database Application
2. ____________________________
Instructions:
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 3 of 7
Suppose assigned to create a new database by the name MISRAK COLLEGE having the
following two tables, proceed to answer the following Questions?
Task1: Create the following two tables’ structure under MISRAK COLLEGE database?
Department Table
Filed Name Data Type Description
Dept-Code Text Department code
Dept-Name Text Department name
Staff Table
Field Name Data Type Description
Dept-code Text Department code
Ref-ld Text Department name
Emp-Name Text
Sex Text
Birth-Date Date/time
Salary Number
Marital Status Text
Task2: Assign proper primary key for each table so that you will not have duplicated
records?
Task3: Create a validation rule and validation text for the following fields.
Fields Validation rule Validation Text
Dept-code To accept only WV-001, Please type the correct value
WV-002, WV-003, WV- of Dep-Code
004 or WV-005
Sex To accept only F or M Please type the correct value
of sex
Task4: Create an input mask for the field Ref-id?
Task5: Create a Martial status field as a look up field in staff table that lists Single, Married
or Divorce?
Task6: Format Birth Date in medium date format?
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 4 of 7
Task7: Define a possible relationship between the two tables?
Task8: Enter the following data for department and staff tables?
Department Table
Dept-code Dept-Name
WV-001 Administration
WV-002 Finance and Audit
WV-003 Information Technology
WV-004 Public Relation
Staff Table
Dept-code Ref-id Emp-name Se Birth Salary Marital-
x Date status
WV-001 (W-252)-1453-60 Tesfaye Hailu M 01/02/56 5000 Single
WV-001 (W-252)-1453-61 Senait Fekadu F 01/04/60 12579 Married
WV-001 (W-252)-1453-62 Dereje Solomon M 08/12/68 13000 Divorce
WV-001 (W-252)-1453-63 Abraham Getaw M 04/06/55 7700 Single
WV-002 (W-252)-1453-64 Sara Hagose F 08/11/61 10500 Married
WV-002 (W-252)-1453-65 Henock lemma M 04/02/69 12000 Divorce
WV-002 (W-252)-1453-66 Tigist Belachew F 03/03/67 11500 Single
WV-002 (W-252)-1453-67 Lidiya Biruk F 01/01/44 7800 Married
WV-003 (W-252)-1453-68 Girma Belay M 04/02/72 14500 Divorce
WV-003 (W-252)-1453-69 Yeshi Leul F 03/03/67 12500 Single
WV-003 (W-252)-1453-70 Frehiwot Asmore F 05/06/90 8000 Married
WV-003 (W-252)-1453-71 Tolosa diriba M 05/08/61 7100 Divorce
WV-004 (W-252)-1453-72 Berhanu Assefa M 05/06/58 8000 Single
WV-004 (W-252)-1453-73 Bekele Ararsa M 04/07/69 8350 Married
WV-004 (W-252)-1453-74 Hailu Girmay M 03/06/65 12600 Divorce
WV-004 (W-252)-1453-75 Saba Daniel F 11/11/58 10500 Single
Task9: a) create and save a multi-table select query by the name monthly pay having the
following field lists Dept-code, Dept-Name, ref-id, Emp-Name, sex, Birth –Date, Salary,
Marital Status, Allowance (300 for each employee), pension (7%), tax (10%), net pay and
age where allowance, pension, tax, net pay and age are calculated fields?
b) Create and save a make table query by the name my new record using the query you
created in question 9a which contains only records who are in WV-001 OR WV-002?
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 5 of 7
c) Using my new record data source, create and save a query called “ salary increment”
that enables to update salary of an employee by birr 1000 on the top of their previous
salaries?
Task10: Create and save cross-tab query that summarizes numbers of employees’ salary
by department and sex for question numbers 9a?
Task11: Create a query criterion to filter those records based on the following condition
from monthly pay query?
A) Filter those records whose Dept-code is WV-001 or WV-002?
B) Filter those female records that are married?
C) Filter those records whose name starts with letter S or whose Age greater than 50?
D) Filter those records whose salary greater than 10000 having a male sex?
E) Filter those records that are information technology department but not married?
Task12: create and save the following data entry form for staff table.
b) Create the following calculated fields for staff table using text box control
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 6 of 7
Allowance (1000 birr for each employee)
Pension (7%)
Tax (10%)
Net pay
Age
c) Based on the data entry form that you design enter the following records for your staff
tables?
Dept-code Ref-id Emp- Sex Birth- Salary Marital-
name Date status
WV-001 (W-252)-1453-76 Belete M 1/2/56 9800 Single
Daniel
WV-002 (W-252)-1453-77 Fisseha M 1/4/60 8700 Married
Legese
WV-003 (W-252)-1453-78 Samera F 8/12/45 6500 Divorce
Feleke
WV-004 (W-252)-1453-79 Lebesu F 4/6/55 9780 Single
knfu
Task13: Create and save a main/sub form having the following layout?
a) Dept-code…….
Dept-Name……….
Ref-id Emp-name Sex Biirth-date Salary Marital-
status
b) Using the above main/sub form enter the following records
Dept-code WV-005
Dept-name program coordination
Ref-id Emp-name Sex Birth Date Salary Marital-
status
(W-252)- Moges M 1/2/68 9800 Single
1453-80 Kelebesa
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
የተቋም ስም የሰነድ ቁጥር
Company Name Document No.
ምስራቅ ፖሊ ቴክኒክ ኮሌጅ
OF/OBT/DP/014
MISRAK POLYTECHNIC COLLEGE
ርዕስ ዕትም የገፅ
Title
ቁጥር ቁጥር
INSTITUTIONAL OC ASSESSMENT PACTICAL EXAMINATION TEMPLATE Issue No. Page No.
01 Page 7 of 7
(W-252)- Chala M 5/8/58 7540 Married
1453-81 Gutema
(W-252)- Seada F 5/8/59 6700 Divorce
1453-82 Mohammed
(W-252)- Betelhe F 4/7/74 9678 Single
1453-83 H/luel
Task14: a) create and save a tabular report by the name Report 1 that list all fields in both
tables?
b) Format the above report having a nice look
Task15: a) create a group/total report that shows employees grouped by department and
save it
by the name report 2.
b) Format the above report having a nice look
c) Calculate no of staffs and average salary
Task16: Using label wizard create staff members monthly pay slip for all employees
having the following structure and save it by the name salary slip.
Salary payment payroll slip
Emp-name: { Emp-Name}
Department: {Dept-Name}
Paid on: {Current Date}
Net pay: {Net Pay}
Tools & Instruments:
Quantity Item description Specification
1 Desktop PC dell optiplex 3020,8GB Ram and 500
2
Prepared by: Asnake Signature___________
Approved by: _____________________________ Signature___________
ሰነዱን ከመጠቀምዎ በፊት ትክክለኛ ዕትም መሆኑን ያረጋግጡ!!
PLEASE MAKE SURE THAT THIS IS THE CORRECT ISSUE BEFORE USE!!
