Summary

• Description:

  The MS Word document comprises Mmalina Trial 2 Computer Studies Paper 2 2026 Mock Exam with Marking Scheme. The PDF version is also available upon your request. The marking scheme is in a different document.

  It was a KCSE Computer Studies 451/2 examination.

  This practical examination assesses hands-on competence in database management systems (DBMS) and desktop publishing (DTP). Candidates demonstrate practical skills in relational database construction, data manipulation queries, report generation, and professional publication design using Microsoft Access and Microsoft Publisher.

  • Month Administered: July 2026
  • Duration: 2 Hours 30 Minutes
  • Total Marks: 100
  • Number of Questions: 2 (Questions 1 and 2)
  • Structure: Two compulsory practical questions carrying 50 marks each, testing Database Management Systems and Desktop Publishing respectively.

  It covers the following topics:

  • Question 1: Database Management Systems (Microsoft Access)
    • Creation of relational database tables, setting primary keys, and data types
    • Establishing one-to-many relationships and referential integrity
    • Designing data entry forms and data population
    • Formulating calculated query fields (percentage fee increments) and criteria-based queries
    • Summary queries calculating total income
    • Generating grouped summary reports with header formatting and calculated totals
  • Question 2: Desktop Publishing (Microsoft Publisher)
    • Page setup: Margins, portrait A4 page configuration, and graphical borders
    • Typography and formatting: Font effects, loose character spacing, drop caps, and text formatting
    • Graphic layout: Inserting shapes, starburst banners, clip art, columns, and bulleted lists for promotional marketing flyers
• File Size:

  2.01 MB
• Category:

  Mock Past Papers
• Level:

  Form 4
• Subject:

  Computer Studies
• Posted By:

  Caleb_Peter

Enter your details below to initiate a payment using MPESA.