Index No.

:
Question 1 Mark(s) Award Name: …………………………Admno………………class…........
1 a saving workbook 1 QUESTION 2 - DATABASE
heading 1 Required Mark(s) Award
Merging cells 1 Database Named KingsSchool
records12 @0.5 6 2i correct Database Saving@1, other 0.5 1
Borders 1 ii Table Students 2.5
Centre alignment 1 p.k 1
Table Exams 2.5
11 Table library 2
b Names correctly entered [email protected] 3 p.k 1
c Correctly saved work 1 iii Relationship
naming worksheet Rank 1 Approppriate Relationship 2 @ 0.5 1
2 Enforcng Referentoial Integrity 1
d Correct average 1 iv Forms
Absolute cell referencing @1 1 Create forms 2@3 6
correct calculation @1 4 Correct records entered @ 0.5 10
6 v Borrowed borrowed books query
e apply one decima point to average 2 saving 1
Books borrowed 1
f Class average 3*1 3 vi Totals calculation Query
g Rank function 1 Correct saving 1
correct calculation 2 correct Result 2
3 vii Age Query
h sorting using average 1 Correct saving 1
ascending order 1 Correct fields selected 1
2 correct Result 3
i inserting column @1 1 viii THE A query
Naming @1 1 correct saving 1
If Function 3 Correct query 2
Displaying the correct results 1 ix performance report
6 correct report saving 1
j MAX (3*0.5) 1.5 correct field selected 1
MIN(3*0.5) 1.5 correct grouping 1
3 correct result 1
k Title of the chart 1 x students report
axis 1 saving 1
Legend 1 correct report 1
inserting the chart in a new sheet 1 xi printing 3
correct chart 2 50
6
l Printing
GRADE 1
RANK 1
CHART 1
3
50