Today's Topic MS Access Form And Report Solved MCQs

Q01) Which of the following is the building block of the GUI?

1. Form
2. Text boxes
3. Methods
4. Command

Answer:Form

Explanation:In Microsoft Access, a form is a graphical user interface (GUI) that allows users to view, add, edit, and delete data in a database table.

Q02) A form that contains a sub form is called:

1. Form Report
2. Main Form
3. Main Report
4. Child Form

Answer: Main Form

Explanation: A form that contains a subform is called a "main form" or a "parent form". The subform is a separate form object that is embedded within the main form and is typically used to display related data from another table or query.

Q03) Which of the following is used to retrieve data form database and represent it to the user in a formatted way?

1. Form
2. Query
3. Table
4. Report

Answer:Report

Explanation:The option that is used to retrieve data from a database and represent it to the user in a formatted way is a "report".

Q04) Which shortcut key is used to open an existing database in MS-Access?

1. CTRL+N
2. CTRL+S
3. CTRL +O
4. CTRL +Z

Answer: CTRL +O

Explanation: To open an existing database in Microsoft Access, you can use the shortcut key "Ctrl + O".

Q05)The forms are designed to:

1. Data capturing
2. Data manipulation
3. Managing output result
4. Analysis

Answer:Data capturing

Explanation:Forms in Access are user-friendly interfaces that allow users to enter, edit, and view data in a database. Forms can be created using a variety of tools, including wizards and design tools. They can be customized to include different types of controls such as text boxes, combo boxes, and buttons.

Q06) How many form layouts are available in MS- Access?

1. 5
2. 2
3. 3
4. 4

Answer:4

Explanation:The number of available form layouts may vary depending on the version of Access that you are using.
Columnar Form Layout, Tabular Form Layout, Datasheet Form Layout, Justified Form Layou, PivotTable Form Layout, Split Form Layout

Q07) A form within another form is called:

1. Sub Form
2. Main Form
3. Multi Form
4. Form

Answer:Sub Form

Explanation:In Microsoft Access, a form within another form is called a subform. A subform is a form object that is embedded within another form, also known as the main form.

Q08) A sub form can be created by using:

1. The form wizard
2. Drag and drop method
3. Sub form wizard
4. All of these

Answer:All of these

Explanation:All of these. Using the Subform Wizard: Dragging and Dropping: Manually Creating a Subform Control

Q09) Auto form displays one record at a time

1. Columnar
2. Datasheet
3. Tabular
4. Justified

Answer:Columnar

Explanation:AutoForm in Microsoft Access typically displays data in a columnar format and shows one record at a time.

Q10) A report may be based on:

1. Table
2. Relationship
3. Form
4. Attribute

Answer:Table

Explanation:A report in Microsoft Access may be based on a table. In fact, reports in Access can be based on a variety of data sources, including tables, queries, and even other reports.

Q11)How many reports layout are?

1. 2
2. 3
3. 4

Answer:3

Explanation:3

Q12) Forms and controls are collectively recognized as:

1. Properties
2. Events
3. Methods
4. Objects

Answer:Objects

Explanation:Forms and controls are collectively recognized as objects in Microsoft Access. Objects are the building blocks of an Access database, and they can be used to interact with and manage data.

Q13)Which form property will put text in the title bar of the form?

1. Objects
2. Border
3. Caption
4. Title

Answer:Caption

Explanation:To put text in the title bar of a form in Microsoft Access, you can set the Caption property of the form.

Q14) A form is an object of:

1. Table
2. Database
3. Header
4. Report

Answer:Database

Explanation:In Microsoft Access, a form is an object of the database that provides a user interface for displaying and editing data. A form is a container for controls, such as text boxes, combo boxes, and buttons, that allow the user to interact with the data.

Q15) A subform is a form that is places in a parent form called

1. Main Form
2. Parent Form
3. Child form
4. Sub-Form

Answer:Child form

Explanation:A subform is a form that is placed within another form, called the parent form, in Microsoft Access. The subform is used to display related data from a one-to-many or a many-to-many relationship in a hierarchical manner.

Q16) It is used to make shortcut keys or form with buttons:

1. Switch Board
2. Linker
3. Border text
4. Justified

Answer: Switch Board

Explanation: Switch Board

Q17) It provides quick result from database.

1. Forms
2. Columnar
3. Objects
4. Report

Answer:Report

Explanation:Report

Q18) Which command is used to execute commands in MS-Access forms:

1. Execute
2. Open
3. Run
4. None of these

Answer:Run

Explanation:RunCommand method is commonly used in Microsoft Access forms to execute commands, such as saving records, opening new forms, or printing reports.