IGNOU CITL 1 2026 2027 - Create a Hospital Database using MS-Access. The database should includ

Question

Create a Hospital Database using MS-Access. The database should include fields such as
Doctor ID, Doctor Name, Specialization, Consultation Fee, Patient ID, Patient Name,
Age, Gender, Patient Type, and Doctor’s Recommendations. Add at least five records,
create a data entry form, and generate a report showing patient details doctor-wise

31 Jul 2026

Answer :

Word Count : 421

A Hospital Database in MS-Access can be created to maintain doctor and patient information efficiently. First, open MS-Access and create a new blank database named HospitalDB.accdb. Create a table named HospitalRecords with the following fields: * Doctor ID (Short Text, Primary Key) * Doctor Name (Short Text) * Specialization (Short Text) * Consultation Fee (Currency) * Patient ID (Short Text) * Patient Name (Short Text) * Age (Number) * Gender (Short Text) * Patient Type (Short Text) * Doctor’s Recommendations (Long Text) Enter at least five records as shown below: | Doctor ID | Doctor Name | Specialization | Consultation Fee | Patient ID | Patient Name | Age | Gender | Patient Type | Doctor’s Recommendations | | --------- | --------------- | -------------- | ---------------- | ---------- | ------------ | --- | ------ |

____ _____ __________ ________ __________ ______ ________ ________ _____ _______ _______ ______.
______ ______ ____ ______ ________ ______.
______ _______ ___ __________ __________ ___ _____ ______.
________ ________ _______ __________ __________ ___ ___ __________.
_________ _________ ___ ______ ________ _____ _________ _________ _________ _________ _______ _______.
_______ _________ _____ __________ _________ __________ ______ __________ _________ _______ ______ _________.
_____ ______ ____ _____ _______ ___ _________ ______ _______ ___ ___.
______ _______ _____ ___ ___ ___ _______ _____ _________ _________.
____ __________ ____ ________ ____ __________ _____ ______ __________ ______.
_________ _________ _____ _______ _________ ____ ___ ________ ___ ________.
_________ ______ _______ ___ _________ __________ ____ _______ ______ ______.
____ ______ ________ _____ ____ _____ _____ _______ ____ _______.
_______ ________ ____ ___ ________ __________.
_________ ______ _____ ___ __________.
_______ _____ _____ _______ ___.
_____ ___ ____ __________ _________ ________ __________ ____ __________ _______ _____.
___ ________ _____ _______ ___ _____ _______.
____ _________ ______ ________ _______ __________ ________ _____ ________.
_________ _______ _______ _____ _____ _________ ______ ______ __________ ___ ______.
______ __________ ___ __________ ___ _______ ________.
________ __________ ____ ________ _______ __________ __________ _____ _________ __________.
__________ ___ _____ _______ _________ __________ ___.
____ ___ _______ _____ ________ ________ _____ _______ ________.
__________ ____ ___ _________ _____.
______ ___ ______ _______ ____ _________ _____ _______.
__________ ____ ______ ____ _______.
__________ _________ ______ _________ _________ ______.
_____ ______ ________ ____ __________ _____ ____ _______ ___ _________.
_______ ___ _______ ________ _______ ______ ___ _________ ____ ___ ___ ________.
________ ________ ______ ______ ________.
___ __________ _________ ________ _______ _______ _______ _____ _____ _____ ____.
____ _______ ___ ___ ________ ________ ______ ____ ______ ___ ____ ______.
________ ______ _______ _____ _________ _______.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10