Section A: Multiple Choice Questions (MCQs)

Section B: Short Answer Questions

• 6. Define a foreign key and explain its purpose in MS Access.
  A foreign key is a field that links one table to the primary key of another. It ensures referential integrity between related tables.
• 7. What is the difference between a form and a report?
  Forms are used for entering and editing data, while reports are for formatting and printing data in a presentable way.
• 8. List and explain any three query types available in MS Access.
  Select Query (retrieves data), Update Query (modifies data), Append Query (adds records to another table).
• 9. What is referential integrity? Why is it important?
  It ensures consistency between related tables by preventing orphan records. Important to maintain accurate data relationships.
• 10. Explain the difference between Datasheet View and Design View of a table.
  Datasheet View shows and edits data directly, Design View defines the structure and data types of fields.

Section C: Practical Task Questions

• 11. Create a database named SchoolDB with tables: Students and Results. Establish a relationship.
  Create Students(StudentID PK, Name, Class, Age). Create Results(ResultID PK, StudentID FK, Subject, Marks). Relationship: Students.StudentID → Results.StudentID.
• 12. Design a form that allows teachers to enter marks.
  Use Form Wizard → Select Results table → Choose fields → Create a simple data entry form.
• 13. Write and run a query to display all students scoring more than 75 in Mathematics.
  Query in SQL: SELECT Students.Name, Results.Subject, Results.Marks FROM Students INNER JOIN Results ON Students.StudentID=Results.StudentID WHERE Results.Subject='Mathematics' AND Results.Marks > 75;
• 14. Create a report that summarizes average marks per subject.
  Use Report Wizard → Select Results → Group by Subject → Apply Avg function on Marks.
• 15. Import data from Excel.
  Go to External Data → New Data Source → From File → Excel → Browse and select file → Import into table.

Section D: Case Study / Scenario Questions

Case Study: You are hired to develop a hospital database.

• 16. Identify at least three tables.
  Patients(PatientID, Name, Age, Gender), Doctors(DoctorID, Name, Specialty), Appointments(AppointmentID, PatientID, DoctorID, Date, Time).
• 17. Define the relationships.
  Patients.PatientID → Appointments.PatientID; Doctors.DoctorID → Appointments.DoctorID.
• 18. Query for appointments by doctor and date.
  SQL: SELECT Patients.Name, Appointments.Date, Appointments.Time FROM Patients INNER JOIN Appointments ON Patients.PatientID=Appointments.PatientID WHERE Appointments.DoctorID = X AND Appointments.Date = #MM/DD/YYYY#;
• 19. Report for patients treated by each doctor.
  Create Report → Group by DoctorID → Count PatientID in Appointments.
• 20. Enforce data validation.
  In Patients table, set Age field validation rule: >=0, validation text: "Age cannot be negative."