Ms Access Database Practical Exam: Episode 31 | DICT November 2019 Task 1 Exam

In this video, we go step-by-step through KCSE 2019 Computer Studies Paper 2 – Question 1, focusing on the MS Access Database Practical. You'll learn how to design and implement a school performance management database as outlined in the exam.
https://drive.google.com/file/d/18YDO...
📌 What’s Included in This Tutorial:
2:10 How to create a database using Ms Access
3:45 How to create tables using Table design
4:30 How to set data types and field size in tables
4:56 How to identify and set primary key in a table
6:45 How to apply Lookup Wizard in Ms Access Table
11:00 How to create a Form with SubForm in Ms Access
14:30 How to enter data using the form and subform
19:30 How to create a filter query | SELECT* FROM WHERE Query
20:00 How to calculate Average using Queries
24:03 How to design a report in Ms Access
29:50 How to calculate Average using Ms Access Report
31:10 How to format a Report
33:30 How to print tables, queries and reports
#KCSE2019Paper2
#ComputerStudiesPractical
#MSAccessKCSE
#KCSEDatabase
#KCSEComputerStudies
#DICTExam
#MicrosoftAccessTutorial
#KCSEForm1Database
#StudDetailsTable
#StudMarksTable
#ClassTableAccess
#KCSEICT
#KNECComputerStudies
#KCSESubform
#AccessRelationships