Create a database in MS-Access for a hospital, which is having the following database fields : • Doctor ID, Doctor Name, Consultation Fee, Specialization • Patient ID, Patient Name, Age, Gender

To create a database in MS-Access for a hospital with the specified fields, you can follow these steps:

1. Open Microsoft Access: Launch Microsoft Access on your computer.

2. Create a New Database: Click on the "Blank Database" option to create a new, empty database.

3. Name the Database: Enter a name for your database, such as "HospitalDatabase," and choose a location to save it. Click "Create" to proceed.

4. Design Doctor Table:

   • Click on the "Create" tab and select "Table Design" from the Tables group.
   • In the table design view, create the following fields for the Doctor table:
     • DoctorID (Primary Key, AutoNumber)
     • DoctorName (Text)
     • ConsultationFee (Currency)
     • Specialization (Text)
   • Save the table as "Doctor" when prompted.

5. Design Patient Table:

   • Repeat the process to create a new table design for the Patient table.
   • Define the following fields for the Patient table:
     • PatientID (Primary Key, AutoNumber)
     • PatientName (Text)
     • Age (Number)
     • Gender (Text or Yes/No for Male/Female)
   • Save the table as "Patient."

6. Establish Relationships:

   • After creating both tables, go to the Database Tools tab and select "Relationships."
   • Add both the Doctor and Patient tables to the Relationships window.
   • Create a relationship between DoctorID in the Doctor table and DoctorID in the Patient table. Ensure that the relationship type is one-to-many, as one doctor can have multiple patients.

7. Save and Close:

   • Save your database to preserve the changes.
   • Close Microsoft Access.

Now you have a basic database structure for a hospital in MS-Access, including tables for doctors and patients. You can further expand and customize the database by adding additional tables (e.g., appointments, medical records) and implementing queries, forms, and reports as needed to manage hospital data effectively.