INSTRUCTIONS TO CANDIDATES
- Write your name and index number at the top right hand corner of each print out.
- Write your name and index number on the Compact Disk.
- Write the name and the version of the software used for each question attempted in the answer sheet.
- Answer ALL the questions.
- All questions carry equal marks.
- Passwords should NOT be used while saving in the Compact Disk.
- All answers MUST BE saved in your CD.
- Xyz hospital intends to use a database to manage doctors and patients’ records.
- Open a database program and create a database named XYZ hospital. (1mk)
-
- Create three tables named tbldoctor, tblpatient and tblailment in the database file created in (a) using the following details. (8mks)
tbldoctor
Field Name Data Type and Field properties Doctor_ID Text First Name Text(size=10) Last Name Text(size=10) Specialization Text(size=1=20)
tblpatient
Field Name Data Type and Field properties S_No Autonumber Patient_No Text Patient Name Text County Text Age Number Gender Yes/No (yes for Female) S_No Autonumber
tblailment
Field Name Data Type and Field properties Doctors_ID Text Patient_NO Text Ailment Text Date of Visit Date & time Charges Currency - Set primary key(s) and create relationships between the tables (5mks)
- Enforce referential integrity between the tables (3mks)
- Create three input screens with navigation buttons for each table, give your forms appropriate titles (6mks)
- Enter the following data into their respective table in the database (10mks)
tbldoctor
Doctor_ID First Name Last Name Specialization D_001 Jim Green Nephrologist D_002 Lucy King Pulmonologist D_003 Bob Smith Dermatologist D_004 Alexia King Endocrinologist D_005 Nelly Walk Neurologist D_006 Freda Ford Pulmonologist
tblpatient
Patient_No Patient Name County Age Gender P_101 Abigael Marie Nairobi 41 F P_102 Alexa Kate Nakuru 32 M P_103 Alexander William Kericho 33 M P_104 Brianna Lynn Kericho 40 M P_105 Aiden Lake Kajiado 24 F P_106 Anelia Faith Bungoma 20 F P_107 Alexis Jade Busia 39 M P_108 Benjan Clay Nairobi 30 M
tblailment
S_NO Doctors_ID Patient_No Ailment Date of visit Charges 1 D_006 P_101 Cold & flu 12/7/2019 2,000 2 D_005 P_102 Conjuctivitis 14/8/2019 15,000 3 D_006 P_103 Headaches 15/8/2019 18,000 4 D_004 P_104 Stomachaches 19/9/2019 5,000 5 D_004 P_101 Diabetes 20/9/2019 20,000 6 D_003 P_105 Cancer 28/10/2019 85,000 7 D_003 P_106 Asthma 2/10/2019 13,000 8 D_002 P_107 Arthritis 3/11/2019 14,000 9 D_001 P_108 Tuberculosis 4/11/2019 10,000 10 D_005 P_102 Cancer 4/11/2019 80,000 - Create a query to display the fields;
- Patient_ID, Patient Name, Doctor_ID for all patients treated by D_006. Save query as D_006patients. (2mks)
- Patient_No, Ailment, Date of Visit and the actual charges if 5% discount was offered to patients. Save query as patientpayments. (3mks)
- Doctor_ID, First name, Last Name and specialization; combine First name and Last name, Save query as DoctorName. (3mks)
- Doctor_ID, First name, Last Name and specialization; Sort specialization field in descending order, Save query as Sort. (2mks)
- Create a macro for D_006patients query, save query as D_006patients macro (2mks)
- Create a report to display S-NO , Doctors_ID, Patients_No, Ailment and charges.
The report should display sutotals for each patients charges and the grandtotal, save the report as grand total (5mks) - Print grandtotal report (1mk)
- Create three tables named tbldoctor, tblpatient and tblailment in the database file created in (a) using the following details. (8mks)
-
- Using a Word Processing package, type the congratulatory note below as it appears and save it as CONGRATURATIONS. (15mks)
- Create a data source with the following details and use it with the letter you have just typed to generate personal letters. Save the file as personnel. Save it as Details. (15mks)
George Kinoti
P. O. BOX 5678
Kericho
Software Developer
Ksh.125000
Wilberforce Kenya
P. O. BOX 5678
Kisumu
ICT Officer
Ksh.125000
Henry Odongo
P. O. BOX 5678
Kilgoris
Database Admin
Ksh.125000
Grace Akinyi
P. O. BOX 5678
Nakuru
System Admin
Ksh.120000
Beth Mugo
P. O. BOX 5678
Migori
Secretary
Ksh.30000
Sharon Wangoi
P.O. BOX 5678
Nandi-Hills
Accountant
Shs.45000 - Insert data fields in main document and generate the letters for the employees. (10mks)
- Generate individualized envelops for each employee (8mks)
- Print the first two letters. (2mks)
- Using a Word Processing package, type the congratulatory note below as it appears and save it as CONGRATURATIONS. (15mks)
MARKING SCHEME
Q1 | Maximum score | Students’ score | |
a | XYZ Hospital | 1mk | |
b(i) | Field Names and field properties | 8mks @ ½ mk | |
(ii) | Primary keys Tbldoctor (Doctor ID) Tblpatient (Patien_No) Tblailment (S_No) Two correct Links |
1mk 1mk 1mk 2mks |
|
(iii) | Tbldoctor - Tblailment (one to many) Tblpatient -Tblailment (one to many) |
1mk 1mk |
|
(iv) | - Input screen for each table. - Command button(s) |
3mks @ 1mk 3mks @ 1mk |
|
(v) | Correct data entry Tbldoctor Tblpatients tblailment |
2mks 4mks 4mks |
|
(vi) a) |
Correct fields Patient treated by D006 |
1mk 1mk |
|
b) | Correct fields Charges after discount |
1mk 2mks |
|
c) | Correct fields Combined fields (using a formular) |
1 mk 2mks |
|
d) | Correct fields Sorted field |
1 mk 1 mk |
|
(vii) | Macro | 2mks | |
(viii) | Correct fields Subtotals Grandtotals |
1mk 2mks 2mks |
|
(ix) | Printed report | 1mk | |
50mks | |||
Q2 | Maximum score | Students’ score | |
(a) | Letter Address typing Company logo Letter typing Letter formattings Autoshape Autoshape fill color Autoshape behind text |
1mks 3mks 3mks 3mks 2mks 1mk 2mks |
|
(b) | 6 contact information correctly typed. Data source saved as Personnel. |
12mks @ 2mks 3mks |
|
(c) | 6 personalized letters | 10mks | |
(d) | 6 personalized envelopes | 8mks | |
(e) | Printing | 2mks @ 1mk |
Join our whatsapp group for latest updates
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Download Computer Studies Paper 2 Questions and Answers - Joint Pre-Mock Exams 2021/2022.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students