COMPUTER STUDIES PAPER 2 - 2017 MURANG'A MOCK EXAMINATION

Share via Whatsapp
  1.  
    1. Create the form letter shown below and save it as FORMLETTER.                           (8marks)

      Kenya Planters Association Ltd.,
      P.O. Box 90009 00100,
      Mombasa (Kenya).

      <First Name> <Second Name>
      <Address>
      <City>
      Dear <First Name>
      RE: ANNUAL GENERAL MEETING
      We wish to invite you for our annual general meeting which will be held on <Date> of <Month> 2017 at <Time> A.M. The venue will be at <Venue>
      The agenda for the meeting will be as follows:
      • elections
      • Financial Reports
      • Dividends
      • AOB
        Please, make sure you carry your membership card without which you will not be allowed entry at the gate.
        Yours truly,
        MD-KPA

        Required:
    2.  
      1. Align the address at the top right to be at the top left. Similarly do the same for the last two lines of the letter.    (2mks
      2. Bold and underline the line staring with RE.   (4mks)
      3. Replace the bullets with numbers 1, 2… 4 and save the document as FORMLETTER2. (4mks) 
    3.   
      1. Create a data source that has the following structure and save it as DATASOURCE. (8mks)

        First Name

        Second Name 

        Address

        City

        Date

        Month

        Time

        Venue

                       
      2.  Add the following six records to the data source.                                                             (9mks)







        First

        Name

        Second Name

        Address

        City

        Date

        Month

        Time

        Venue

        Joseph

        Scott

        P.O. Box 20

        Nairobi

        20

        August

        10

        Town Hall

        Teresa

        Wanja

        P.O. Box 27

        Kisumu 

        20

        August

        10

        Town Hall

        Mark

        Meza

        P.O. Box 79

        Mombasa 

        20

        August

        10

        Town Hall

        Musa

        Mako 

        P.O. Box 10

        Nairobi

        20

        August

        10

        Town Hall

        Masese

        Milka

        P.O. Box 66

        Nairobi

        20

        August

        10

        Town Hall

        Nyang

        Osborn 

        P.O. Box 44

        Nairobi

        20

        August

        10

        Town Hall

    4. Insert the merge fields in the FORMLETTER2 to replace the text marked with the < > signs.(9mks)
    5. Merge the FORMLETTER2 and the DATASOURCE to a new document and save it as MERGED       LETTER.                                                                                                                              (5mks)
    6. Print FORMLETTER, FORMLETTER2, DATASOURCE and MERGED LETTER.     (5mks)
  1. A media house sells advertising space on its channels. It has a database of two tables.
    1. Create a database file and save it as ADVERTS.    (2mks)
    2. Create two tables containing the following fields.   (6mks)

      CUSTOMERS_TABLE

      FIELD

      DATA TYPE

      FIELD SIZE

      Customer_ID (PK)

      Text

      4

      Customer_Name

      Text

      50

      Target Audience

      Number

      Long Integer


      RATES_TABLE

      FIELD

      DATA TYPE 

      FIELD SIZE

      Rate_ID (PK)

      Text

      4

      Rate_Name

      Text

      50

      Rate_Cost(Ksh)

      Number

      Long Integer

      Time

      Number

      Long Integer

    3. Validate the Time field to accept entries between 30 and 60 only.
    4.  
      1. Create a one-to-many relationship between the CUSTOMERS table and the RATES Consider that one customer can be charged many rates.   (4mks)
      2. Enforce the following constraints on the relationship:          (6mks)
        •  Referential integrityc)                      (4mks)
        • Cascade update related fields
        • Cascade delete related fields
    5. Create a form based on the CUSTOMERS_TABLE and use it to enter the following data. (4mks)

      Customer_ID

      Customer_Name

      Target Audience 

      1000

      Wello Ltd

      600000

      1001

      Lamp International

      1000000

      1002

      Texas Kenya

      100000

      1003

      Vail Co

      500000

      1004

      Mills Vigo

      200000

      1005

      Orient International

      300000

    6. Create a form based on the RATES_TABLE and use it to enter the following data. (4mks)

      Customer_ID

      Rate_ID

      Rate_name

      Rate_Cost(Ksh)

      Time (s)

      1000

      2

      Morning

      3000

      60

      1003

      1

      Afternoon

      5000

      30

      1000

      3

      Evening

      2500

      30

      1005

      2

      Morning

      3000

      60

      1000

      1

      Afternoon

      5000

      30

      1005

      3

      Evening

      2500

      30

      1004

      2

      Morning

      3000

      60

      1003

      2

      Morning

      3000

      60

      1001

      2

      Morning

      3000

      60

    7.  
      1. Create a query named CUSTOMER_BILLS that shows Customer_ID, Customer_Name, Rate_ID and Rate_Name.  (6mks)
      2. Sort the CUSTOMER_BILLS query in descending order by Rate_Cost.         (2mks)
    8. Create a tabular report based on the CUSTOMER_BILLS query that satisfies the following conditions:      (12mks)
      • Should have a title: “BILL PER CUSTOMER” bolded and centered at the top.
      • Subtotals based on Customer_ID with subtotals.
      • It has total amounts payable by all customers being the sum of the Rate_cost field.
        • Save the report as CUSTOMERBILS.
    9. Print CUSTOMER and RATE tables, CUSTOMER_BILLS query and CUSTOMERBILLS
Join our whatsapp group for latest updates

Download COMPUTER STUDIES PAPER 2 - 2017 MURANG'A MOCK EXAMINATION.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest