CBSE 10th class Unit 3: Chapter 5 FORMS AND REPORTS

 

Unit 3 

Chapter 5
FORMS AND REPORTS

A. Multiple Choice Questions

1.      (b) Forms Controls Toolbar

The Label tool is used to create labels in forms and reports, and it's located on the Forms Controls Toolbar.

2.      (d) all records

The Record toolbar provides buttons to navigate through all the records in a table or query.

3.      (b) It can contain only text fields

This statement is not true. Forms can contain various types of controls, including text fields, checkboxes, option buttons, combo boxes, list boxes, and more. They can also incorporate graphics and images to enhance the user interface.

4. (c) Ctrl

Pressing the Ctrl key allows you to select only textboxes on a form.

5. (c) Tool Tip

The Tool Tip property in the Properties: Label Field text box is used to insert a tool-tip on the form.

6. (c) Report

Reports are used to display data retrieved from one or more tables in a presentable manner.

7. (d) Standard (Medium)

Selecting the Standard (Medium) value for the Date Format property displays a calendar on the form.

8. (b) Toggle Mode

The Toggle Mode command on the Forms Control toolbar toggles between Design View and Form view.

9. (c) Both a and b

Reports can be generated based on data from tables or queries, or a combination of both.

10. (c) Both (a) and (b)

The Report Builder and Add Fields dialog box open along with the Report Wizard.

3. State whether the following statements are True or False

1. False Reports and forms are both objects of a database.
2. True You can choose the layout of a form to customize its appearance and functionality.

C. Fill in the blanks

1. A form can be used for data entry and data display.
2. Each field control consists of a label and field value text box.
3. A label 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 value text box is displayed in black.
5. A tool tip 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 portrait.
7. A layout 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 the Insert menu.
9. A Report Wizard contains five steps.
10. A dynamic 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.
• Form: Designed for data entry and modification.
• Report: Designed to display and print data in a structured format.
2. What is a field control with respect to forms?

A field control is an object on a form that allows users to input or display data. It typically consists of a label and a text box.

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

The Text tool is used to insert text on a form.

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

1. Form Wizard: A step-by-step guided process.
2. Form Design: A more flexible approach where you manually design the form.
4. What is the difference between a static and a dynamic report?

• Static Report: Displays fixed data based on the data present at the time of report generation.
• Dynamic Report: Updates automatically as the underlying data changes.
5. Write the function of Forms Controls toolbar and Records toolbar.
• Forms Controls Toolbar: Contains tools for adding and modifying controls on a form, such as text boxes, labels, buttons, etc.
• Records Toolbar: Provides tools for navigating through records, adding new records, deleting records, and saving changes.