Search
Free School Management System
Free School Management System for Kenya

Free School Management System

Learn More

KCSE CLUSTER TEST 14

Computer Studies Paper 2

1.

- Check for the formula in each column (10mks)

- All entries well entered. (2mks)

- Saved worked. (2mks)

- Projected work. (18mks)

- Printed work. ( 2mks)

- Graph. (11mks)

- Averages, expenses, sales and profit. (5mks)

-

50 marks

2.

a) Using the information to create a database named STORE and enter the data in tables Products, Suppliers and Orders. (30mks)

(b) (i) Creating the relationships between the tables. (4mks) (ii) Creating a query to find the Cost of the products and save it as Product cost (7mks

(c) Creating a form to allow the entering of the product details and add an appropriate form title and save as product form. (5mks)

(d) Print the three tables and the query (4mks

50 marks

Back Top