Seventh Chapter Solved Exercise MCQs Of ICS Second Year Computer Science

Seventh Chapter Solved Exercise MCQs Of ICS Second Year Computer Science. Each question includes the correct answer and a brief explanation. It’s designed to help you study, prepare for exams, and understand key concepts better. Boost your Computer Science knowledge with these practice exercises.

Seventh chapter solved MCQs with explanation

1. Forms are designed for.
a) Input Data
b) Manipulate Data
c) Accepting Change
d) All of them

Explanation: Forms are mainly used for inputting data into the database.

2. A form that contains the sub-form is called.
a) Form
b) Main Form
c) Report
d) None of them

Explanation: The Main Form holds the primary data and can contain one or more sub-forms.

3. You can drag the _ bar to move the property sheet window around on your screen.
a) Title bar
b) Status bar
c) Scroll bar
d) All of them

Explanation: The Title bar is used to move the property sheet window around the screen.

4. How many basic layouts of forms are there in Microsoft Access?
a) 2
b) 3
c) 4
d) 5

Explanation: Microsoft Access offers four basic form layouts. Columnar, Tabular, Datasheet, and Justified.

5. The forms are the _ end of our database in Microsoft Access.
a) Back end
b) Front end
c) both a and b
d) None of them

Explanation: Forms are considered the front end as they provide a user-friendly interface to interact with the database.

6. An AutoForm displays one record at a time in _ view.
a) Tabular
b) Columnar
c) Datasheet
d) Justified

Explanation: An AutoForm in Columnar view shows one record per screen in a vertical layout.

7. A report that provides a column for each field of the records in rows under the column header is known as.
a) Tabular
b) Columnar
c) Datasheet
d) Justified

Explanation: A Tabular report organizes data into columns under headers, similar to a spreadsheet.

8. _ can be previewed on the screen before printing.
a) Report
b) Form
c) Subform
d) None of them

Explanation: Reports can be previewed on the screen to check formatting before printing.

9. Which of the following is used to retrieve data from one or more tables of a database and present it to the user in a formatted way?
a) Report
b) Form
c) Query
d) Table

Explanation: Queries retrieve and format data from one or more tables for viewing.

10. How many are the layouts of a report?
a) 2
b) 3
c) 4
d) 5

Explanation: Reports in Microsoft Access can have four layout types. Report Design, Layout View, Print Preview, and Report View.