Forms and Reports in Microsoft Access is an important chapter that teaches students how to enter, manage, and present data easily using forms and reports.
In this chapter, students learn how to add records using forms, use List and Combo Boxes, create Subforms, and apply the Drag-and-Drop method to design forms quickly. It also explains how to create Reports to display and print data in a clear and organized format.
This chapter helps students understand practical database skills and prepare effectively for exams.
📥 Download Class 12 Computer Science Chapter 7 Notes
Skip to PDF contentThis PDF includes complete explanations of forms, adding records, list and combo boxes, subforms, drag-and-drop method, and reports, along with important exam questions and examples.
📥 Click here to download full Chapter 7 notes
⭐ MCQs – Microsoft Access Forms and Reports
Q1: The main purpose of a form in Microsoft Access is to:
a) Store data permanently
b) Enter, edit, and view data in an easy way
c) Print reports
d) Delete tables
Answer: b) Enter, edit, and view data in an easy way
Q2: Which object in MS Access is mainly used for printing organized data?
a) Table
b) Query
c) Report
d) Form
Answer: c) Report
Q3: Which tool allows users to select a value from a drop-down list?
a) Text Box
b) Combo Box
c) Label
d) Form Header
Answer: b) Combo Box
Q4: A Subform is used to display:
a) Unrelated data
b) Related data from linked tables
c) Only text data
d) Only numbers
Answer: b) Related data from linked tables
Q5: The Drag-and-Drop method is used for:
a) Designing forms quickly
b) Deleting records
c) Running queries
d) Printing reports
Answer: a) Designing forms quickly
Q6: Which of the following is NOT a feature of a form?
a) Data entry
b) Data editing
c) Data printing
d) Data viewing
Answer: c) Data printing
Q7: Reports in MS Access are mainly used to:
a) Modify database structure
b) Present data in a formatted way
c) Enter data
d) Create tables
Answer: b) Present data in a formatted way
❓ Frequently Asked Questions (FAQs)
Q1: What is a Form in Microsoft Access?
A Form is a database object used to enter, edit, and view data in an easy and user-friendly way.
Q2: What is the use of Reports in MS Access?
Reports are used to display and print data in a well-organized format.
Q3: What is a Combo Box?
A Combo Box is a control that allows users to select a value from a drop-down list or type their own value.
Q4: What is a Subform?
A Subform is a form within a form that is used to show related data from another table.
Q5: Why is the Drag-and-Drop method used in MS Access?
It is used to quickly design forms by dragging fields onto a form layout.