Ms Access Database Project Exam: Episode 29 | Chama Loan System

Описание: Are you a secondary school or college student in Kenya preparing for your ICT practical project or KNEC exam? In this complete 1-hour video, we guide you through building a fully functional Chama Loan Management System (LMS) using Microsoft Access – from tables to queries, reports, and dashboard!

This project is ideal for:

KCSE Computer Studies Projects

KNEC Diploma ICT Projects

Secondary and College-level MS Access coursework

Students learning database design, compound interest logic, and form creation

📚 What You’ll Learn in This Video:
✅ How to create well-structured tables (Members, Loans, Repayments)
✅ Setting up 1-to-many relationships and enforcing referential integrity
✅ Designing clean, functional data entry forms
✅ Writing queries for active loans, defaulters, repayments & loan summaries
✅ Applying the compound interest formula (1% per day) in Access
✅ Generating professional reports with formatting
✅ Building a dashboard navigation form with summary insights
✅ Tips to score maximum marks in your ICT project assessment

⏱️ Timestamps (Click to Skip Ahead):
0:00 – Intro & Project Overview
3:20 – Database Structure and Table Design
3:20 – Table Relationships & Field Properties
13:45 – Member Registration Form
31:00 – Loan Application & Repayment Forms
34:00 – Queries (Active Loans, Defaulters, Interest Calculation)
44:00 – Reports & Summary Queries
50:00 – Creating a Dashboard Form
1:14:00 - Testing
#MSAccessProject
#ICTProjectKenya
#KNEC2025
#KCSEComputerStudies
#ChamaLoanSystem
#StudentDatabaseProject
#AccessDatabaseTutorial
#LoanManagementSystem
#MicrosoftAccessKenya
#ICTPracticals
#CollegeICTProject
#HighSchoolICT
#AccessFormsQueriesReports
#KNECComputerStudies
#KCSEICTProject
Get PDF From https://drive.google.com/file/d/1K9Uq...