Laboratory Management System Database for Microsoft Access, features:
1. Patients:
Patient ID (Auto Increment),
First & Last Name,
Date of Birth,
Email Address,
Phone Number,
Address,
Payment Method (Cash/Card/Check).
2. Lab Tests:
Test ID (Auto Increment),
Test Short Title (Name of Lab Test Conducted),
Summary of Test Conducted.
3. Test Results:
Sample ID (Auto Increment),
Patient ID (Drop Down, Choose Name of Patient that Was Added in Patients Menu),
Samples Date Taken,
Test ID (Drop Down, Choose Name of Patient that Was Added in Lab Tests Menu),
Sample ID,
Date of Analysis,
Notes,
Parameter,
Result.
4. Reports: Generate Detailed Printable Lab Test Report for Each Patient.