Helpdesk: WhatsApp: 0736552548 Email: info@kenyaplex.com

Computer Studies Paper 2 Practical Questions

Institution: Secondary level

Course: Computer Studies

Content Category: Study Guides

Posted By: Willask

Document Type: DOCX

Number of Pages: 175

Price: KES 299
 
    

Views: 1918     Downloads: 2

Summary

(b) Create queries to determine.
i. Number of people with basic salary greater than 32,000/= .Save the query as basic (5 Marks)
ii. Number of people with basic salary less than 45,000/= AND come from computer department. Save the query as computer. (5 Marks)
iii. Names of people who are either married or single . save the query as Status (4 Marks)
iv. Those whose salary fall between 25,000/= and 50,000/=.Salary (3 Marks)
v. Those whose name begin with letter M or end in letter S. Save the query as Names (3 Marks)
(c) (i) Create a query to compute the new salary if there is an increment of basic pay by 16% Save the query as Salary increment. (7 Marks)
(ii) Filter using query those who earn above 33000/= and aged between 39 and 70.Save the query as Ages (5 Marks)
(d) (i) Create a form using form wizard in the Dept table above. Save as Form A (3 Marks)
(ii) Create a form in design view using the Dept table above on the form and calculate the total basic salary for the whole table, add current date and time on the form header.
Save the form as Form B (5 Marks)
(iii) Create a report from Dept table using design view to display all the data in the table the title of the report should be Employee details. Save the report as Employee Report and print it.


Below is the document preview. Purchase to access the complete document.

  • Computer-Studies-Paper-2-Practical-Questions_8223_1.jpg
  • Computer-Studies-Paper-2-Practical-Questions_8223_2.jpg
  • Computer-Studies-Paper-2-Practical-Questions_8223_3.jpg
........

This is the end of this document preview. Buy to download the complete document.


More Resources


  • A guide on the Pearl by John Steinbeck

    A guide on the Pearl by John Steinbeck.

    Price: KES :  250

     
  • Guide To The Blossoms of the Savannah

    Blossoms of the Savannah Guide: Detailed and Comprehensive

    Price: KES :  150

     
  • Mwongozo wa Tumbo lisiloshiba na hadithi nyingine

    Dibaji Mwongozo huu ni matokeo ya jitihada za Maria Mvati, James Kanuri na Saul S. Bichwa. The NES wameona kuwa ni muhimu kutayarisha mwongozo huu ili kuwasaidia walimu na wanafunzi katika kuelewa...

    Price: KES :  200

     
  • Guide To The Memories We Lost and Other Stories

    This document contains a definitive guide to the new set book "Memories we lost and other stories". It is the best to have at the moment. Brief Overview: About the Author The author...

    Price: KES :  290

     
  • Blossoms of the Savannah Guide

    This study guide provides a detailed analysis of the novel Blossoms of the Savannah. The analysis is aimed at preparing KCSE candidates for both the excerpt and the compulsory essay question in paper...

    Price: KES :  200

     
  • KCSE Revision Oral Literature and Poetry

    KCSE Revision Oral Literature and Poetry. Detailed and comprehensive study guide. Brief Overview: What is poetry? It is not easy to say what exactly poetry is. But poetry explores the...

    Price: KES :  300

     
  • Combined Guide for Caucasian Chalk Circle and Betrayal in the City

    This is a combined analysis of Caucasian Chalk Circle and Betrayal in the City set texts. Brief Overview: The Caucasian Chalk Circle Summary The Caucasian Chalk Circle begins with a Prologue...

    Price: KES :  50

     
  • Geography Charts Diagrams

    Explore Geography Charts and Diagrams - a versatile resource providing visual aids to enhance geographical understanding, perfect for teachers and students alike.

    Price: KES :  0

     
  • Guidelines For English Paper 1

    This is a handout that gives learners and teachers tips on areas to prepare for before they sit for their English Paper 1 KCSE examinations. ENGLISH PAPER 101 CONTENT AND GUIDELINES By Zacch...

    Price: KES :  350

     
  • He's Far Too Much Guide Book

    This notes can be used by a tutor and student-teachers for reference purpose in the set book He's Far Too Much. Brief Overview: The play is written by Said Mohamed "AMEZIDI" but translated in...

    Price: KES :  180

     
  • Carribean Literature Notes

    This is about Caribbean literature: its early inhabitants and history of oppression with description of George Lammings book "In the castle of my skin" ..............

    Price: KES :  0

     
  • A Doll's House Guide - Notes

    This is a guide to the text "Doll's House".It has handled the form and structure of the text. Thus guiding both the teachers and students in preparation for the examination. ABOUT THE...

    Price: KES :  200

     
  • Research Methodology Notes

    This document contains the process and the format of writing a research project. UNIT OF ANALYSIS ? Unit of Analysis refers to the level of aggregation of the data collected during the subsequent...

    Price: KES :  500

     
  • KASNEB Accounting Technicians Diploma Syllabus July 2018

    KASNEB Accounting Technicians Diploma Syllabus July 2018. TABLE OF CONTENTS LEVEL I Page Paper No. 1 Introduction to Financial Accounting 1 Paper No. 2 Principles of Business Law 3 Paper No. 3...

    Price: KES :  50

     
  • Helping Children with Special Needs

    Introduction By the end of this article, you should be able to: a) Discuss bow to identify', rehabilitate and refer children with special needs. b) Explain how to counsel children with special...

    Price: KES :  100

     
  • An attachment/Internship study guide

    This attachment guide will be useful for students going for attachment/internship or taking an internship attachment. I will be useful and you prepare to start your attachment, during your...

    Price: KES :  100

     
  • Simplified Poetry Study Guide for Form 1 to Form 4

    Simplified poetry study guide book with exhaustively discussed poetry concepts supported with enough explanations, illustrations and exemplifications. for K.C.S.E, P.T.E and students taking...

    Price: KES :  200

     
  • Arrow of God Short Notes

    This document has analysed the characters and has summarized the plot of the novel arrow of God.it can be used by student teacher's during revisions. Arrow of God Summary The novel is set in the...

    Price: KES :  200

     
  • Mwongozo Wa Chozi La Heri

    Huu mwongozo ni kazi fiti sana ya kukuwezesha mwalimu pamoja na mwanafunzi katika kujitayarisha kuelewa na kuchambua Riway kipya cha Chozi Heri chake Assumpta.Jipatie nakala yako leo.Kando na...

    Price: KES :  150

     
  • Kiswahili Karatasi Ya Pili: Matumizi Ya Lugha

    Faili hii ina hoja za kila anuai zitakazo jenga uweledi wa mwanafunzi yeyote yule na kumfanya aje kuwa bingwa wa Kiswahili na bila shaka afaulu katika mitihani yake kwani faili hii imetengenezwa...

    Price: KES :  200

     
  • Mwongozo na Uchambuzi wa Ushairi

    Makala haya yanazungumzia ulingo wa ushairi na jinsi utanzu huu unavyochambuliwa.mwandishi amezingatia utanzu wenyewe kwa kufasili ushairi ni nini na pia kutoa mwelekeo wa namna mashairi...

    Price: KES :  100

     
  • Diabetes Insipidus Notes

    Short notes on Diabetes Insipidus: Pathophysiology, Diagnosis, Prognosis DIABETES INSIPIDUS Diabetes insipidus is a rare form of diabetes caused by deficiency of vasopressin or a defect in the...

    Price: KES :  100

     
  • Blossoms of the Savannah Sample Essays

    This document contains sample essays from The Blossoms of The Savannah. Brief Overview: 1. Blossoms of the Savannah is a novel about hope that leads to victory; write a composition to illustrate...

    Price: KES :  60

     
  • Estimated Cost of Rearing 100 Improved Kienyeji/Kuroiler Chicken in Kenya

    This document captures monetary calculation of keeping 100 kuroiler chicken until maturity. Current market price for feeds have been used. (UNGA FEEDS) This document can assist you in decision...

    Price: KES :  50

     
  • Maswali na Majibu ya Isimu Jamii

    Maswali na Majibu ya Isimu Jamii. Brief Overview: Saidi : Hallo............Hallo....Huyo ni Bw. Mohamed? Mohamed : Ndio...uko wapi... Saidi : Shuleni...sasa...ulinifikishia...

    Price: KES :  70

     
  • Maswali ya Marudio ya Tamthilia ya Kigogo 2021

    Maswali ya marudio ya tamthilia ya kigogo. Haya maswali huguzia sifa ya wahusika,maudhui mbali mbali,mbinu,umuhimu ya wahusika na maswali ya dondoo unayojitokeza kwa tamthilia hili. MASWALI KATIKA...

    Price: KES :  60

     
  • Tips to Excellence in Biology

    Tips to Excellence in Biology Biology Revision and Examination Tips BIOLOGY REVISION AND EXAMINATION TIPS Main reasons why Students Perform Poorly in the Biology Subject - Confusion of biology...

    Price: KES :  48

     
  • KCSE Business Studies Revision Booklet - Paper 1 and Paper 2

    KCSE Business Studies Revision Booklet - Paper 1 and Paper 2. Brief Overview: 1. Mention four limitations of advertising as a means of sales promotion. (4mks) 2. The capital structure of...

    Price: KES :  48

     
  • Maswali na Majibu Katika Tumbo Lisiloshiba na Hadithi Nyingine

    Maswali na Majibu Katika Tumbo Lisiloshiba na Hadithi Nyingine 1. Huku ukirejelea hadithi ya Tumbo Lisiloshiba na Shibe Inatumaliza, fafanua maudhui ya ukiukaji wa haki. (al.20) TUMBO...

    Price: KES :  75

     
  • Discuss the role of written and unwritten sources in the reconstruction of African history

    Discuss the role of written and unwritten sources in the reconstruction of African history. Brief Overview: Introduction The task of reconstructing African history has been a challenging one. A...

    Price: KES :  500

     

More Content By Willask


  • Tips to Excelling in KCSE Biology: Biology Revision and Examination Tips

    In this document there are detailed tips on how to pass biology. Tips to Excelling in KCSE Biology: Biology Revision and Examination Tips. Main reasons why Students Perform Poorly in the Biology...

    Price: KES :  100

     
  • Kiswahili Revision Questions With Answers

    This document contains Kiswahili revision questions and answers. Madhumuni yaUjumla (a) Kuendeleza mafunzoya Kiswahli yaliyo funzwa katika shule za msingi. (b) Kukuza uwezo wa mwanafunzi...

    Price: KES :  250

     
  • Compiled Phrasal Verbs for Writing Essays and Composition

    This document contains a list of compiled phrasal verbs for writing essays and composition.

    Price: KES :  100

     
  • Geography questions and answers booklet

    Geography questions and answers booklet This document contains best questions and answers for students preparing for KCSE. GEOGRAPHY PAPER II REVISION QUESTIONS AND ANSWERS 1. (a) (i) What is...

    Price: KES :  200

     
  • Computer Studies Form 1-4 Notes Booklet

    ERRORS IN MICROSOFT EXCEL SPREADSHEETS Applies To: Microsoft Excel 2010, 2013, 2016 and 2019 1. ###### error Problem: The column is not wide enough to display all the characters in a...

    Price: KES :  399

     
  • Functional Skills KCSE English Paper 1 Simplified

    ENGLISH PAPER 101/1: FUNCTIONAL SKILLS This is a paper that tests learners on the practical application of the functional skills taught/learned during the course. It is based on the four skills...

    Price: KES :  400

     
  • 2022 KCSE Computer Studies Paper 3 (Project)

    2022 KCSE Computer Studies Paper 3 (Project)

    Price: KES :  0

     
  • Fashili Simulizi For High School

    FASIHI SIMULIZI Fasihi ni sanaa inayotumia lugha kuwasilisha ujumbe unaomhusu binadamu. Sanaa ni ufundi wa kuwasilisha fikra na hisia za binadamu kama vile maneno, maandishi, uchoraji, uchongaji,...

    Price: KES :  290

     
  • Top Student Kiswahili Revision Kit

    SEHEMU YA C: MATUMIZI YA LUGHA (a) Andika kwa kinyume: (i) Nje kulikuwa kweupe. (alama 1) (ii) Mzizimo (alama 1) (b) Eleza matumizi ya "po" katika sentensi...

    Price: KES :  300

     
  • Detailed Phrasal Verb List

    Act on To take action because of something like information received. The police were ACTING ON a tip from an informer and caught the gang red?handed. Act on Affect. The medicine only ACTS ON...

    Price: KES :  200

     
  • KCSE Comprehensive Biology Notes: Support and Movement in Plants and Animals

    1. Support- the ability of organisms to bear their weight and maintain their shape. 2. Movement- change of position of part or whole of an organism’s body. 3. Locomotion- movement of the whole...

    Price: KES :  199

     
View all resources