THE NEW KCSE PROJECT GUIDELINES PART 9: SYSTEM CODING

​The SYSTEM CODING (the new kcse project guidelines)

This is where you turn your designs into real programs using any of the computer programming languages or database management systems.

1. Design your tables.
   1. Include correct field names, set correct data types and format the field widths correctly.
   2. Set primary keys for your tables.
   3. Set validation rules and test whether the rules are able to work as required.
   4. Create relationships where possible.
2. From the tables, create their respective data entry forms.
   1. The forms should be created in Design view.
   2. The form should have command buttons which when clicked will be able to execute the task, e.g., Add Record, Save Record, Delere Record. Close form .
   3. Include Textboxes where possible.
   4. Test to see whether any change made on the form is able to affect the respective table.
3. Create queries where possible (e.g., to calculate totals).
4. Generate reports.
5. Create a main switchboard.

<<< previously

THE NEW KCSE PROJECT GUIDELINES PART 10: SYSTEM TESTING >>