Instructions to candidates

1. Type your name and Index number at the right hand corner of each print out.
2. Write your name and Index number on the CD provided.
3. Write the name and version of the software used for each question attempted in the answer sheet
4. Answer all the questions
5. Passwords should not be used while saving in the CD provided.
6. All answers must be saved in your CD provided.
7. Arrange your printouts and staple them together
8. Hand in all the printouts and the CD used
9. This paper consists of 4 printed pages.

QUESTIONS

QUESTION 1: WORD PROCESSING

1.                        
   1. Open your word processing application and type the following letter on a new blank page (include the dashed line). Save the letter as Course Letter. (15mks)
      
   2. Open a new blank document and create the table below. Save the file as Course Participant Data. (12mks)
      
   3. Using the Course Letter as a form letter and the Course Participants Data as the data source merge the two documents and insert the merged fields Title, First_Name, Surname, Address and City fields above Dear Participant in the letter, as shown below. (12mks)
      
   4. Save the mail merge document as Course2021. (2mks)
   5. Prepare envelopes for the participants. Save them as Participant envelopes (7mks)
   6. Print the letter and envelope for Mrs. Mary Collins (2mks)

QUESTION 2: DATABASE
The following records were provided by a Uchumi Bora Supermarket . Study the table and answer the questions that follow. The products having the ProductID starting with value 1 are premium products, others starting with 2 are ordinary products.

1. Create a database file named “Uchumi Bora Products”. (2mks)
2. Split and design the above table into “Products” and “Sales” tables to record products items and sales made respectfully. Set the SalesID to Auto Number. (7mks)
3. Add appropriate key fields and create a relationship between the two tables. (2mks)
4. Create the following forms: (6mks)
   1. Columnar Products form named “ProductsForm”, having the title “Product Entry Form”.
   2. Columnar Sales form named “SalesForm”, having the title “Sales Details Entry Form”.
5. Using the forms in (d) above post the products and sales details to their respectful tables. (8mks)
6. Create the following queries.
   1. A query named Sales Query that computes sales amount as a product of Sales Quantity and Sales Rate (5mks)
   2. A query named Premium Query to generate a list of premium products, having the fields; Product ID, Product Description, Package Quantity. Order the list in ascending order of ProdID. (6mks)
   3. A query name Date Query to generate sales made between 23/08/2020 and 09/09/2020, having the fields ProductID, Product Description, SalesID, Sales Date and Sales Quantity. (4mks)
7. Generate the following reports.
   1. Sales report named Sales Report, having the fields ProductID, Product Description, Package Quantity, SalesID, SalesDate, SalesRate and SalesQuantity, grouped by ProductID. (3mks)
   2. A report named VAT Report displaying ProductID, SalesQuantity, SalesRate and SalesAmount from (f) (i); add field named “VAT 16%” and compute VAT as 16% of the SalesAmount. (4mks)
8.                
   1. Print the tables, Products and Sales (1mk)
   2. Print the queries, Sales Query and Premium Query (1mk)
   3. Print the reports, Sales Report and VAT Report (1mk)

MARKING SCHEME

QUESTION 1: WORD PROCESSING

QUESTION 2: DATABASE