Bunyore Maranda MOCKS 2016 Computer Studies Paper 2

« Previous Topic
Bunyore Maranda MOCKS 2016 Computer Studies Paper 1

Next Topic »
Bunyore Maranda MOCKS 2016 CRE 1

Download PDF for future reference Get on Whatsapp for 50/-

Create a database and save it as school database.

Create a Table called 'Students Table' in the school database with the following. (7 marks)

FIELD NAME	DATA TYPE	FIELD SIZE/FORMAT
ADM-NO	Text	10
Name	Text	15
Surname	Text	15
Tel-No	Number	Long Integer
Date of Birth	Date/time	Medium date
Fee - Paid	Currency	Currency
Foreigner	Yes/No	Yes/No

Make the "AM_Number" Find the Primary Key (1 mark)

Open the "Students Table" and enter the following records. (3 marks)

ADM-NO	Name	Surname	Tel-No	Date of Birth	Free-paid	Foreigner
4567	John Maina	Muiru	55-67543	19/09/1990	25000	No
4576	Mary Nthenya	Mutua	44-23456	20/12/1991	27000	No
4398	Mark Okech	Otieno	22-65473	13/03/1992	20000	No
5678	Peter Rick	Ben	11-76742	15/06/1994	29000	Yes
4378	Joan Liz	Patel	13-89734	18/09/1990	26000	Yes
4897	Peter Amos	Ben	33-37482	17/04/1993	20000	Yes
4643	Muoka Muoki	Nzoki	44-45362	12/12/1991	23000	No

Insert the record given below as record 4. (2 marks)
4120 Rebecca Kalewa Ben 44-24242 13/10/1990 27000 No
Delete Mary Nthenya's record from the database file. (2 marks)
Sort the table in Ascending order by surname. (2 marks)
Move the Date-of-Birth and Tel-No fields so that Date-of-Birth field is now directly after the surname field. (4 marks)
Change the field size of the surname to 20 (1 mark)
1. Create a Form with all fields on the Students Table. (2 marks)
2. Name the form student Entries. (1 mark)
Insert a picture in the form in a way that all text is visible. (3 marks)
1. Create a report based on the Student's Table showing the Fields Name, Surname and Tel No. (3 marks)
2. Name report Telephone list. (1 mark)
Insert a picture in the report header. (2 marks)
1. Create query 1 showing all fields of those students whose surname is Ben. (3 marks)
2. Create query 2 showing all fields of those students born after 1991. (3 marks)
3. Create query 3 showing only the Student's name, Student's Surname and Student's Date of birth. (3 marks)
4. Create query 4 showing the fee balance of all students given the total fee is 35000 and Fee-balance = Total_Fee - Fee_paid (3 marks)
Print Students table, Student Entries form, Telephone list, query_1, query_2 and query_3, query_4 (4 marks)

The following is a worksheet extracted from business Join Venders. They have come together to do a business of selling computer accessories.

Names	Cost	Sales	Gross Profit	Expenditure	Reserves	Net profit	Remarks
Benson	700	350		450
Betwel	400	700		50
Kimwat	200	900		200
Amos	300	1000		300
Tembur	100	500		100
Korir	400	600		40
Towett	600	850		55
Maritim	500	350		70
Kerich	200	350		45
Beney	500	1000		40
Danson	600	900		170
Kones	900	1000		20
Koech	100	800		130

Additional Information
(a) Gross profit = Sales - Cost
(b) Net profit = gross profit - (expenditure + reserves)
(c) Reserves = 10% gross profit
(d) Remarks are: "very good vendor," "good vendor", "domain vendor", "burden vendor", "Quite vendor"

REQUIREMENT
1. Create the workbook and enter the details, save as vendor. (15 marks)
2. Keep the title of the workbook to be JOIN VENDORS and format it to be bold, font size 14 and align at 20^o(4 marks)
Format the figures in sale column to 2 decimal places. (3 marks)
Insert two rows between Tembur and Koris and enter the records below: (5 marks)
Name Bii, cost 100, sales 500 and expenditure 10
Name Mutai, Cost 800, Sales 2000 and expenditure 80
Use non function to calculate gross profit for each member (3 marks)
Use product function to calculate reserves for each member. (3 marks)
Use "IF function" and net profit to analys the vendors, taking the following remarks. (6 marks)
1. If net profit >= 55, then "very good vendor"
2. If net profit >= 400, then "good vendor"
3. If profit <= 300, then "domain vendor"
1. Use names of the vendor and cost to insert a line graph. Keep the title of the graph to be PRODUCTIVE ANALYSIS, format it and place it in a separate sheet. (5 marks)
2. Save the changes as productive analysis. (2 marks)
3. Print the "Join Vendor" and "productive analysis" including gridlines. (4 marks)

Bunyore Maranda MOCKS 2016 Computer Studies Paper 2

Download Bunyore Maranda MOCKS 2016 Computer Studies Paper 2.

Why download?

Related items

What does our community say about us?

Join our community on: