Chapter 12 Forms and Reports Tables IT Code 402 Book Solution Class 10
Unit 3. Database Management System using LibreOffice Base
A. Multiple-choice questions.
Question 1:
Which of the following toolbars contains the Label tool?
(a) Standard Toolbar
(b) Forms Controls Toolbar
(c) Records toolbar
(d) Formatting toolbar
Answer: (b)
Question 2:
The Record toolbar has the buttons to move to the
(a) first record
(b) second record
(c) last record
(d) all records
Answer: (d)
Question 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
Answer: (b)
Question 4:
Which of the following keys is pressed to select only textbox on the form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab
Answer: (c)
Question 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
Answer: (b)
Question 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
Answer: (c)
Question 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)
Answer: (b)
Question 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
Answer: (a)
Question 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
Answer: (c)
Question 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)
Answer: (c)
Chapter 12 Forms and Reports Tables IT Code 402 Book Solution Class 10
B. State whether the following statements are True or False.
Question 1:
Report is an object of a database but form is not.
Answer: False
Question 2:
We can choose the layout of the form.
Answer: True
Question 3:
We have to add all fields of the table on the form.
Answer: False
Question 4:
There are two ways in which a form can be created.
Answer: True
Question 5:
A report is generated in a separate window.
Answer: True
Question 6:
Once a control is added on to the form, it cannot be re-positioned.
Answer: False
Question 7:
The Record toolbar has the button to add a new record.
Answer: True
Question 8:
We can create a report only using a table.
Answer: False
Question 9:
By default, the records in a report are sorted in descending order.
Answer: False
Question 10:
We can group data based on a particular field in a report.
Answer: True
Question 11:
A report can have data only in row and column format.
Answer: False
Question 12:
We can insert both date and time of generation of report.
Answer: True
Question 13:
A report once created cannot be edited.
Answer: False
Chapter 12 Forms and Reports Tables IT Code 402 Book Solution Class 10
C. Fill in the blanks.
Question 1:
A form can be used for _____ and ________.
Answer: Enter, view data
Question 2:
Each field control consists of a ____________ and ________.
Answer: label, field value
Question 3:
A _________ is a piece of text that specifies the data that should be entered in the field value text box.
Answer: label
Question 4:
By default, the border of the field text value is displayed in ________.
Answer: 3D
Question 5:
A _________ is a small piece of text that is displayed when the mouse pointer is placed on a particular control on the form.
Answer: tool tip
Question 6:
The default orientation option for a report is ___________.
Answer: landscape
Question 7:
A ________ is the manner in which the labels, field values, titles etc. will be displayed in the report.
Answer: Layout
Question 8:
The option to insert date and time in the report is present in ________ menu.
Answer: Insert
Question 9:
A Report Wizard contains __________ steps.
Answer: Six
Question 10:
A _________ type of report changes automatically as the field values in the base table or query change.
Answer: dynamic
Chapter 12 Forms and Reports Tables IT Code 402 Book Solution Class 10
D. Answer the given questions.
Question 1:
Give one difference between a form and a report.
Answer: Form vs Report
| Form | Report |
|---|---|
| A form is an object of the database that has a user friendly interface where data can be entered and seen in an attractive and easy-to-read format. | Using a report we can present the retrieved data in an attractive and customized manner. |
| For any database, it is the front end for data entry and data modification. | We can create a report based on a table or a query or both. |
| It displays the data in a layout design by us and not just in a simple row and column format. |
Question 2:
What is a field control with respect to forms?
Answer: a form contains field controls arranged in a presentable and user friendly manner. Field control consists of a label and the field value text box.
- A label is a piece of text that specifies the data that should be entered in the field value text box.
- A field value text box is linked to the respective field in the table.
Question 3:
Which tool on the Forms Record toolbar is used to insert text on the form?
Answer: Text box
Question 4:
Name the two ways to create a form in LibreOffice Base.
Answer: There are two ways to create a form:
- Using the Design View
- Using a wizard
Question 5:
What is the difference between a static and a dynamic report?
Answer: Static vs Dynamic Report
| Statics Report | Dynamic Report |
|---|---|
| Dynamic Report means as the field values in the base table or query change, the report will also change automatically. | Static Report means as the field values in the base table or query change, the report will does not change automatically. |
| By default the type of report is Dynamic. | By default the type of report is not Static. |
Question 6:
Write the function of Forms Controls toolbar and Records toolbar.
Answer: Forms Control Toolbar: This toolbar contains various controls that can be added to the form. For example, Label, Text box, Check Box, List Box, Combo Box, etc.
Records Toolbar: 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.
| <<< Chapter 11. Queries in Base | Chapter 13. Health, Safety, and Security at Workplace >>> |
