Project Overview

This project focuses on transforming manual logbook records into a structured Database ****Management System (DBMS) for a small computer sales and training business to ensure data safety, accuracy and long-term usability for analysis and decision-making.

The primary goal was to convert messy, unstructured manual records into well-organized relational databases using Microsoft Excel with automation applied where necessary to improve efficiency and reliability.

Data Overview

The data used in this project includes:

• Messy sales records recorded in logbooks
• Student registration forms (manual)
• Student payment records for information management and engineering training

These data were incomplete, inconsistent and difficult to analyze in their original manual format.

Tool Used: Excel

Objective

The objectives of this project were:

• To design and create databases for:
  • Student information
  • Student payments
  • Sales records
  • Laptop and accessory inventory
  • Certificates
  • Expenses
• To migrate all records from manual logbooks into the structured database system
• To apply Excel automation (formulas and VBA) to improve data entry, tracking and analysis

Key Insights and Findings

1. Student Information Records

Manual student forms contained incomplete and inaccurate information.

Some students refused to provide key details such as date of admission, Phone number, which is essential for tracking training duration, completion dates and students. Others filled forms incorrectly due to lack of understanding of the form content.

2. Student Payment Records