Comprehensive Guide NCERT Solutions Chapter 12 Forms and Reports

NCERT Solutions chapter 12 Forms and Reports contains NCERT questions from the chapter. Let’s begin!

NCERT Solutions Chapter 12 Forms and Reports

As usual, I will start with MCQ type questions. Lets go!

A. Multiple choice questions

[1] Which of the following toolbars contains the Label tool?
(a) Standard Toolbar
(b) Forms Controls Toolbar
(c) Records toolbar
(d) Formatting toolbar

[2] The Record toolbar has the buttons to move to the
(a) first record
(b) second record
(c) last record
(d) all records

[3] Which of the following is NOT true about forms?
(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records

[4] Which of the following keys is pressed to select only textbox on the form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab

[5] Which of the following properties in the Properties: Label, Field, text box is used to insert a tool-tip on the form?
(a) Tool Text
(b) Help Text
(c) Tool Tip
(d) Help Tip

[6] Which of the following objects of LibreOffice Base is used to display data retrieved from one or more tables in a presentable manner?
(a) Query
(b) Form
(c) Report
(d) Panel

[7] Which of the following values of Date Format property is selected to view a calendar on the form?
(a) Standard (short)
(b) Standard (long)
(c) Default
(d) Standard (Medium)

[8] Which of the following commands on the Forms Control toolbar is used to toggle between Design View and Form view?
(a) Design Mode
(b) Toggle Mode
(c) View Mode
(d) Print mode

[9] Using which of the following objects in a database, can a report be generated?
(a) Tables
(b) Queries
(c) Both a and b
(d) Neither a nor b

[10] Which of the following components open along with the Report Wizard?
(a) Report Builder
(b) Add Fields dialog box
(c) Both (a) and (b)
(d) Neither (a) nor (b)

B. State whether the following statements are True or False

[1] Report is an object of a database but form is not.

[2] We can choose the layout of the form.

[3] We have to add all fields of the table on the form.

[4] There are two ways n which a form can be created.

[5] A report is generated in a separate window.

[6] Once a control is added on to the form, it cannot be repositioned.

[7] The Record toolbar has the button to add a new record.

[8] We can create a report only using a table.

[9] By default, the records in a report are sorted in descending order.

[10] We can group data based on a particular field in a report.

[11] A report can have data only in row and column format.

[12] We can insert both date and time of generation of report.

[13] A report once created cannot be edited.

C. Fill in the blanks

[1] A form can be used for ____________ and _________.

[2] Each field control consists of a ____________and _____________.

[3] A __________ is a piece of text that specifies the data that should be entered in the field value text box.

[4] By default the border of the field text value is displayed in ___________.

[5] A __ is a small piece of text that is displayed when the mouse pointer is placed on a particular control
on the form.

[6] The default orientation option for a report is ___________,

[7] A ______________ is the manner in which the labels, field values, titles etc. will be displayed in the report.

[8] The option to insert date and time in the report is present in _______________ menu.

[9] A Report Wizard contains _____________ steps.

[10] A _______________ type of report changes automatically as the field values in the base table or query change.

D. Answer the following questions

[1] Give one difference between a form and a report.

Answer:

Form	Report
Form is used to enter and view data.	Report is used to display data in formatted manner.
Forms can be used for input and output both.	Reports can be used only as output.
Forms can have a single record each.	Report can have multiple records on each page.
Forms mostly used for soft copy only display and data entry.	Reports are mostly used for hard copy (printed)

[2] What is a field control with respect to forms?

[3] Which tool on the Forms Record toolbar is used to insert text on the form?

[4] Name the two ways to create a form in LibreOffice Base.

[5] What is the difference between a static and a dynamic report?

Answer:

Static Report	Dynamic Report
Display the same data from when they are created.	Updates automatically as data changes in the source.
They are text centric and no interactive features.	They allows users to interact with data and identify the insights.
Used for daily, monthly or weekly reporting	Used for data analysis such as financial analysis, sales funnel etc.

[6] Write the function of Forms Controls toolbar and Records toolbar.

Answer:

Form Controls	Records Toolbar
The Form Controls toolbar or sub-menu contains tools that you need to create an interactive form. You can use the toolbar or sub-menu to add controls to a form in a text, drawing, spreadsheet, presentation, or HTML document, for example a button that runs a macro.	The Records toolbar contains the navigation control buttons in the extreme left. With the help of these buttons, we can traverse and view the records in the file. As we move from one record to another, the record number in the record text boxes changes. It also contains command buttons such as add a new record, save a record, delete a record etc.