Manual management of clinic appointments and patient records can cause delays, misplaced files, duplicate

entries, inaccurate information, and difficulty in retrieving patient data. To address these problems, this study

developed MediTrack, a GUI-based Clinic Appointment and Patient Record Management System designed to

help clinic staff manage patient information and appointment records in a faster, more organized, and more

reliable manner. The system was developed using Python as the main programming language, Tkinter for the

graphical user interface, MySQL for permanent database storage, and OpenPyXL for automatic Excel backup.

MediTrack includes important features such as secure login, adding patient records, viewing records, searching

patient information, updating appointment status, deleting records, clearing input fields, and safely exiting the

Keywords: MediTrack, Clinic Management System, Patient Record System, Appointment System, Python,

Tkinter, MySQL, Excel Backup

Medical clinics handle different types of patient information every day, including patient names, ages, contact

numbers, symptoms, assigned doctors, appointment dates, and appointment status. In many clinics, these records

are still managed manually using paper forms, logbooks, or separate files. Although manual recording may be

useful for small-scale record keeping, it can become difficult to manage as the number of patients increases.

Manual clinic record management often leads to problems such as lost documents, unreadable handwriting,

duplicate entries, slow record retrieval, and inaccurate patient information. Clinic staff may also find it difficult

interface, clinic staff

can interact with the system using buttons, forms, tables, and input fields, making the system easier to operate

compared to manual record keeping or command-based programs.

This study focuses on the development of MediTrack: A GUI-Based Clinic Appointment and Patient Record

Management System with MySQL Storage and Excel Backup. The system was designed to help clinic staff

manage patient records and appointments through a desktop-based application. It allows users to add new patient

records, view existing records, search patient information, update appointment status, delete records, clear input

fields, and exit the system safely.

MediTrack uses MySQL as its database management system to store patient records permanently. This allows

records to remain saved even after the program is closed. The system also uses OpenPyXL to automatically

This study aims to develop MediTrack, a GUI-based Clinic Appointment and Patient Record Management

System that can efficiently manage and organize patient records and appointment information.

Specifically, this study seeks to answer the following questions:

1. How can MediTrack automate the process of patient appointment and record management?

2. How can the system efficiently save and retrieve patient records using a MySQL database?

3. How can the system reduce human errors commonly found in manual clinic logbooks?

4. How can a graphical user interface improve user interaction and usability for clinic staff?

5. How can Excel backup support record safety and reporting in the system?

2. Develop the system backend using Python programming language.

3. Create a user-friendly graphical user interface using Tkinter.

4. Integrate MySQL database for permanent and organized storage of patient records.

5. Implement automatic Excel backup using OpenPyXL for reporting and data duplication.

6. Provide essential clinic record management functions such as add, view, search, update status, delete,

7. Apply input validation to prevent incomplete, duplicate, and invalid patient records.

8. Test the functionality of the system to ensure that it performs according to its intended purpose.

This study is significant because it provides a computerized solution for improving clinic appointment and

patient record management. MediTrack can help reduce paperwork, improve accuracy, and make patient records

easier to organize, retrieve, and update.

Patients. Patients may benefit from faster and more organized clinic services. Since records can be retrieved

quickly and accurately, clinic staff can provide better assistance and reduce delays during appointment

processing.

Students and Developers. This study can serve as a reference for students and future developers who want to

create similar systems using Python, Tkinter, MySQL, and Excel integration. It demonstrates the practical

application of object-oriented programming, database management, graphical user interface design, input

validation, and system testing.

This study focuses on the development of MediTrack, a desktop-based Clinic Appointment and Patient Record

Management System using Python, Tkinter, MySQL, and OpenPyXL. The system includes basic clinic

management functions such as adding patient records, viewing records, searching patient information, updating

appointment status, deleting records, clearing input fields, and exiting the system. It also includes login, input

2. Read - Displays patient information in a structured table, allowing consistent and reliable access

to records.

3. Update - Allows you to change the status or details of the patient so the database always has the

latest information.

4. Delete - Safely removes data, to keep the system accurate and to avoid build-up of outdated

records.

However, the system is limited to local desktop use only. The database runs on one computer and does not yet

support online access, cloud storage, multi-user network access, SMS reminders, advanced user roles, or

automatic report printing. The system is also mainly developed for academic and learning purposes. Future

improvements may include separate account levels for doctors and receptionists, network connectivity, patient

oriented programming, input validation, and Excel backup. These concepts provide the foundation for

understanding the importance of developing a computerized system for managing patient records and clinic

appointments.

As information technology continues to improve, healthcare institutions are gradually shifting from manual

record-keeping to electronic medical records. Electronic medical records, or EMRs, are digital versions of patient

information that allow healthcare workers to store, update, retrieve, and manage medical data more efficiently.

In clinic settings, EMRs help reduce paper-based work and improve the organization of patient information.

Manual clinic records are often prone to errors, misplaced files, unreadable handwriting, duplicated entries, and

delayed record retrieval. These problems can affect the quality of service given to patients because clinic staff

improves the accuracy, speed, and organization of clinic record management.

A medical database system is a structured digital storage system used to manage patient health information. It

allows medical and administrative staff to store patient records in organized tables and retrieve information

whenever needed. Unlike manual records, a database system can keep data more secure, searchable, and

permanent.

The uploaded Group 3 research journal explains that a Medical Database System provides a structured way of

storing digital patient health information and helps healthcare providers access the information they need

conveniently. It also states that medical database systems can improve the quality of patient care while reducing

operational costs in the healthcare system.

Appointment management is important because it affects both clinic productivity and patient experience. When

appointments are organized properly, clinic staff can serve patients faster and reduce waiting time. Patients also

benefit because their records can be retrieved quickly and their appointment status can be monitored more

accurately.

The GUI improves usability because clinic staff can manage records through a simple and organized screen.

They can add records, view patient data, search information, update status, delete records, clear fields, and log

These OOP concepts support the development of MediTrack by making the code more organized, reusable, and

contain exactly eleven digits helps ensure that the phone number is complete. Preventing duplicate patient IDs

Through validation, MediTrack reduces human errors commonly found in manual logbooks and improves the

accuracy of patient record management.

Several existing systems are related to MediTrack. Examples include electronic medical record systems, clinic

management systems, appointment scheduling systems, and hospital information systems. These systems help

healthcare providers manage patient information, appointments, medical history, and clinic workflows.

modern healthcare systems that support secure, standardized, and shareable patient records. These systems show

Compared with larger professional healthcare systems, MediTrack focuses on basic clinic record and

appointment management. It is designed for academic and learning purposes, but it applies important concepts

The literature also supports the use of Python, Tkinter, MySQL, and OpenPyXL in system development. Python

Overall, the reviewed materials support the development of MediTrack as a practical solution for managing clinic

appointments and patient records. The system improves record accuracy, reduces manual work, prevents

common input errors, and provides safer storage through both MySQL and Excel backup.

The conceptual framework of this study follows the Input-Process-Output model.

The input includes patient information such as patient ID, name, age, contact number, symptoms, assigned

The process includes user login, input validation, database connection, record creation, record viewing,

searching, appointment status updating, record deletion, field clearing, and Excel backup. The system checks

whether the entered data are valid before saving them into the MySQL database and Excel file.

The output includes organized patient records, updated appointment status, search results, deleted or cleared

records, database-stored patient information, and Excel backup files. These outputs help clinic staff manage

This chapter presents the research design, system development process, system design, database design, tools

and technologies used, system features, testing procedure, and evaluation method used in the development of

Storage and Excel Backup. It explains how the system was planned, designed, developed, tested, and

implemented to provide a more organized and efficient way of managing clinic appointments and patient records.

monitoring appointment status. Through the development of MediTrack, the researchers aimed to provide clinic

staff with a computerized system that can improve the accuracy, speed, and organization of patient record

handling.

MediTrack was developed using Python as the main programming language, Tkinter for the graphical user

interface, MySQL for database storage, and OpenPyXL for automatic Excel backup. These tools were selected

because they support desktop application development, data validation, database management, and spreadsheet

generation.

The development of MediTrack followed several phases to ensure that the system would meet its intended

purpose and function correctly.

features were selected to make the system more useful and practical for basic clinic record management.

The system design stage involved creating the flow of the application and planning how users would interact

with the system. A flowchart was used to show how the system works from start to finish. The system begins

with a login or registration process before allowing the user to access the main dashboard.

After logging in, the user is directed to the dashboard, where the main functions of the system are available.

These functions include adding a patient record, viewing saved records, searching for patient information,

updating appointment status, deleting records, clearing input fields, and logging out of the system. After

completing a task, the system returns to the main dashboard so the user can perform another action.

fields, connecting to the database, and saving backup records to Excel.

The system also applied important programming concepts such as functions, loops, and conditional statements.

Functions were used to organize the code into separate tasks. Conditional statements were used to check user

inputs and determine what action should be performed. Validation checks were also included to prevent incorrect

or incomplete data from being saved.

MySQL was integrated into the system to provide permanent storage for patient records. The system connects

to the MySQL database using a Python connector. Once connected, the system can send SQL commands to

insert, retrieve, update, and delete patient records.

The database allows patient information to remain saved even after the system is closed. This makes the system

The Excel backup helps improve data safety because the records are stored not only in the MySQL database but

also in a spreadsheet file. This feature can also help clinic staff review or print records more easily when needed.

After development, the system was tested to check whether all features worked correctly. The researchers tested

valid and invalid inputs to determine if the system could properly handle different situations.

Testing included checking blank inputs, duplicate patient IDs, numbers entered in the name field, invalid age

input, and incorrect contact numbers. The system was also tested to confirm whether it could successfully add,

view, search, update, delete, and back up patient records.

Errors found during testing were corrected through debugging. The researchers reviewed the code, fixed logical

errors, improved validation, and ensured that the system worked properly with the MySQL database and Excel

a record is incorrect, duplicated, or no longer needed.

The result showed that the Delete Record feature successfully removed selected patient records from the

database. Since deletion affects stored data, the system should be used carefully to avoid removing important

patient information.

The Clear Fields feature empties all input boxes in the form. This allows the user to prepare the form for a new

input forms, buttons, and data table. Through this dashboard, the user can add, view, search, update, delete, and

clear patient records

Add Record: Automatically parses and tests raw input data fields, running execution scripts that write to active

SQL tables and append rows to an Excel workbook.

The Add Record interface allows users to encode new patient details. It includes input fields for patient ID, name,

age, contact number, symptoms, doctor, appointment date, and status. Once the user submits valid data, the

system saves the record into MySQL and automatically creates an Excel backup.

View Records: Loads records into an interactive layout, complete with clear data columns.

The View Records interface displays all stored patient rows in a table. This helps clinic staff review patient

helps the clinic monitor whether a patient is scheduled, checked in, or completed

The graphical user interface improved the usability of the system because users can perform tasks through

buttons, fields, and tables instead of using command-line instructions. This makes the system easier to understand

and operate, especially for clinic staff who may not be familiar with programming commands.

The system was tested to determine whether its main functions worked correctly. Functional testing was

conducted using both valid and invalid inputs. The purpose of the testing was to check if MediTrack could

process correct information, block incorrect entries, save records to the database, and maintain accurate patient

information.

The results show that MediTrack successfully addressed the problems commonly found in manual clinic record

management. Manual recording can lead to lost records, duplicate entries, inaccurate information, and slow

retrieval of patient files. Through MediTrack, patient records are stored digitally and can be accessed more

efficiently.

The use of MySQL improved the reliability of the system because patient data are saved permanently in a

structured database. This ensures that records remain available even after the program is closed. The Excel

backup also provides additional safety because every new record is duplicated into a spreadsheet file.

The system also improved accuracy through input validation. By checking blank fields, duplicate IDs, invalid

names, incorrect age input, and invalid contact numbers, the system prevents common user errors before they

programs.

Overall, the findings show that MediTrack is functional, organized, and useful for basic clinic appointment and

patient record management.

MediTrack has several strengths based on the results of development and testing. First, it provides a user-friendly

dashboard for managing patient records. Second, it uses MySQL for permanent record storage. Third, it

automatically creates an Excel backup for additional data safety. Fourth, it includes input validation that prevents

invalid or incomplete records. Fifth, it supports basic clinic management functions such as add, view, search,

update, delete, clear fields, and exit.

These strengths show that the system can help clinic staff work faster, reduce paperwork, and manage patient

information more accurately.

The system also has limited update functionality because it mainly allows users to update appointment status

The results showed that MediTrack successfully performed its major functions, including login, adding patient

records, viewing records, searching patient information, updating appointment status, deleting records, clearing

fields, saving data to MySQL, and creating Excel backups. The system also passed important validation tests,

including blank inputs, duplicate patient IDs, invalid names, invalid age input, and incorrect contact numbers.

The discussion showed that the system improved the accuracy, organization, and efficiency of clinic record

management. Through its graphical interface, database storage, and Excel backup feature, MediTrack provides

a practical and reliable solution for managing clinic appointments and patient records within the scope of the

study.

clinic staff manage patient records and appointments in a more organized, accurate, and efficient manner.

The system effectively addressed common problems encountered in manual clinic record management, such as

misplaced files, duplicate records, slow retrieval of patient information, inaccurate entries, and difficulty in

monitoring appointment status. Through the use of a computerized system, clinic staff can add, view, search,

update, and delete patient records faster compared to paper-based methods.

MediTrack also proved useful in improving data storage and record safety. The integration of MySQL allowed

patient records to be stored permanently in a structured database. This ensured that patient information remained

available even after the program was closed. In addition, the use of OpenPyXL provided an automatic Excel

backup, allowing every new patient entry to be duplicated into a spreadsheet file for reporting and backup

purposes.

relying on manual logbooks or command-based instructions. The dashboard provided a simple and organized

workspace for managing clinic records.

The results of functional testing showed that the system performed its intended functions successfully. It was

system properly blocked invalid inputs and displayed warning messages when necessary.

Overall, MediTrack can be considered a functional and reliable system within the scope of the study. It provides

a practical solution for basic clinic appointment and patient record management while demonstrating the

application of Python programming, graphical user interface development, MySQL database integration, Excel

backup, input validation, and object-oriented programming concepts.

storage. This would prevent newly registered accounts from being deleted when the program restarts.

clinic staff correct or update information such as contact number, symptoms, doctor, or appointment date

when needed.

rooms can access the same patient records. This would make the system more useful for clinics with multiple

date, status, or symptoms. This would make record retrieval faster and more specific.

system.

In conclusion, MediTrack already performs its intended functions effectively, but it can still be enhanced through

stronger security, permanent user account storage, full record editing, network access, patient alerts, improved

The researchers would like to extend their deepest appreciation to Engr. Meshelle N. Fabro, PCpE, for her

invaluable guidance, patient mentorship, and profound expertise throughout the development of this study. Her

The researchers also express their profound gratitude to the Eulogio “Amang” Rodriguez Institute of Science

and Technology (EARIST), specifically the Department of Computer Engineering, along with its dedicated