Scribd
Upload
7 views2 pages

Hospital Records System Guide

The document provides a practical guide for creating a Hospital Records Management System using Microsoft Access. It outlines steps to create a database, design tables, establish relationships, enter sample data, create queries and forms, generate reports, and ensure database security. Additionally, it includes sample SQL commands for managing patient records.

Uploaded by

aseunaruth
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Hospital Records System Guide

The document provides a practical guide for creating a Hospital Records Management System using Microsoft Access. It outlines steps to create a database, design tables, establish relationships, enter sample data, create queries and forms, generate reports, and ensure database security. Additionally, it includes sample SQL commands for managing patient records.

Uploaded by

aseunaruth
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Hospital Records System Practical Guide

Microsoft Access Beginner to Intermediate Project

Project Title
HOSPITAL RECORDS MANAGEMENT SYSTEM

Objectives
Create databases, design tables, create relationships, build forms, generate reports, and
manage patient records.

Step 1: Create Database


Open Microsoft Access, create a blank database, and save it as HospitalDB.

Step 2: Create Tables


Create Patients, Doctors, Appointments, and Payments tables with appropriate fields and
data types.

Step 3: Create Relationships


Link Patients and Doctors tables to Appointments and Payments using primary and foreign
keys.

Step 4: Enter Sample Data


Add sample patient and doctor records for testing.

Step 5: Create Queries


Create queries for female patients, searching patients, and today's appointments.

Step 6: Create Forms


Create PatientForm, DoctorForm, and AppointmentForm for easier data entry.

Step 7: Add Form Controls


Add buttons such as Save, Close, and Search to forms.

Step 8: Create Reports


Generate PatientReport, PaymentReport, and AppointmentReport.

Step 9: Navigation Form


Create a menu for navigating between forms and reports.

Step 10: Database Security


Encrypt the database with a password and create backups.
Step 11: Basic SQL
Practice SELECT, UPDATE, DELETE, and ORDER BY SQL commands.

Final Challenge
Build a complete hospital records management system including tables, forms, reports,
queries, and navigation.

Sample SQL Commands


 SELECT * FROM Patients;
 SELECT * FROM Patients WHERE Gender="Female";
 SELECT * FROM Patients ORDER BY FullName ASC;
 UPDATE Patients SET Phone="0700000000" WHERE PatientID=1;
 DELETE FROM Patients WHERE PatientID=5;

You might also like