COMPUTER STUDIES PAPER 2 - 2017 MURANG'A MOCK EXAMINATION

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:
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)

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

Insert the merge fields in the FORMLETTER2 to replace the text marked with the < > signs.(9mks)
Merge the FORMLETTER2 and the DATASOURCE to a new document and save it as MERGED LETTER. (5mks)
Print FORMLETTER, FORMLETTER2, DATASOURCE and MERGED LETTER. (5mks)

A media house sells advertising space on its channels. It has a database of two tables.

Create a database file and save it as ADVERTS. (2mks)
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
Validate the Time field to accept entries between 30 and 60 only.
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

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

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

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)
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.
Print CUSTOMER and RATE tables, CUSTOMER_BILLS query and CUSTOMERBILLS