Microsoft Access Comprehensive Question Bank

Objectives: Microsoft Access Comprehensive Question Bank

Microsoft Access Comprehensive Question Bank

Microsoft Access Comprehensive Question Bank

This collection of questions covers theory, practical skills, and case studies in Microsoft Access. Learners who practice these will be competent for any exam globally.

Section A: Multiple Choice Questions (MCQs)

1. Which of the following is not a valid data type in MS Access?
a) Text
b) Number
c) AutoNumber
d) Character
2. The primary key in a table must be:
a) Unique and not null
b) Numeric only
c) Always AutoNumber
d) Linked to another table
3. In Access, which view allows you to design queries visually?
a) Design View
b) Datasheet View
c) SQL View
d) Layout View
4. A relationship between tables is defined to:
a) Reduce redundancy
b) Enforce referential integrity
c) Link related records
d) All of the above
5. Which object is used to present data in a printable format?
a) Tables
b) Queries
c) Reports
d) Forms

Section B: Short Answer Questions

  • 6. Define a foreign key and explain its purpose in MS Access.
  • 7. What is the difference between a form and a report?
  • 8. List and explain any three query types available in MS Access.
  • 9. What is referential integrity? Why is it important?
  • 10. Explain the difference between Datasheet View and Design View of a table.

Section C: Practical Task Questions

  • 11. Create a database named SchoolDB with tables: Students (StudentID, Name, Class, Age), and Results (ResultID, StudentID, Subject, Marks). Establish a relationship between the tables.
  • 12. Design a form that allows teachers to enter marks for students.
  • 13. Write and run a query to display all students scoring more than 75 marks in Mathematics.
  • 14. Create a report that summarizes average marks per subject.
  • 15. Import data from an Excel sheet into MS Access and explain the steps.

Section D: Case Study / Scenario Questions

Case Study: You are hired to develop a database system for a hospital. The system should keep records of Patients, Doctors, and Appointments.

  • 16. Identify at least three tables you would create for this database and their fields.
  • 17. Define the relationships between these tables.
  • 18. Create a query that lists all appointments for a given doctor on a specific date.
  • 19. Create a report that shows the total number of patients treated by each doctor.
  • 20. Explain how you would enforce data validation (e.g., a patient’s age cannot be less than 0).

End of Question Bank – Learners who practice all sections will be exam-ready for any MS Access test worldwide.

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡