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 | _____ ____ ________ ______ _______ __________.
________ _________ _____ _____ ___ __________ _________ ___ __________.
_____ _____ ________ __________ _____ ____ ____ _______.
___ ______ ____ ___ _____ ____.
________ ___ _____ ___ _______ ___ __________ ____ _________ ___.
___ ________ __________ ________ ____ ________ _______ ____ __________ __________ _________ _______.
___ _____ ______ ___ _____ _______ _________ __________.
________ _______ ___ ________ _____ ________ ________ ______ ____.
________ _________ _________ __________ ____ _______ ______ ______.
_______ ________ __________ ______ ______ ________ ______ ____ ______ ________.
______ ______ ______ __________ ________ ____ ______ __________ __________ ____ ____ _________.
_______ ___ _________ _____ ______ ____ _________.
____ ___ _____ ________ _______.
___ ___ __________ _______ _______ ________ _________ ____ _______ ________ ______.
____ _____ ___ ________ _____ _________ ____ ______ _______ ____.
_____ _________ ________ _______ _______ _____.
___ ______ ________ ___ __________ ________.
_________ ________ _____ ____ ________ __________ _________ _____ __________ _________.
____ ______ _________ __________ ______.
__________ ______ ______ ___ _______ ____ _____ _________ _____.
__________ _______ _____ ________ _________ ______ ______ ______ __________ ___.
______ __________ ____ __________ __________ _______ ______ ___ ______.
_________ _________ ____ _______ ____ ______ ________ ___ ________ ________ _______.
_____ _______ _______ _________ __________.
______ _____ ________ ___ ___ ____.
_________ _____ ___ _________ _________ _________ ______ ______.
____ ________ _____ _________ _________.
___ ____ _________ _______ ____ _____ _________ ___ ________ _______.
_____ _______ ____ _______ ________.
______ ________ ______ ____ ________ __________ ________.
__________ _______ __________ ______ _____ ___ ____ _____ _____ ____ _____ ____.
________ ________ __________ ________ _______ _________.
_____ ___ ________ _____ _______ __________.
____ _____ _______ ______ _____ ______ _______ ___.
_____ _____ ___ __________ __________ _______ _________ ____ ___ ______.
_______ ________ ______ ___ __________.
_________ ______ ____ __________ ____ __________ _____ _______.
__________ ________ ______ __________ ___ ____ ___ _______.
_______ ___ ________ _________ _____ ____ ________ _____ _____.
____.
Get Full Answer on WhatsApp