Exercise Answers — tap any question to reveal the answer and explanation.
1. Which of the following toolbars contains the Label tool?
Answer: (b) Forms Controls Toolbar
2. The Record toolbar has the buttons to move to the
Answer: (d) all records
Explanation: The Record/navigation toolbar has buttons to move to the first, previous, next, and last record — it lets you move to all the records in the table.
3. Which of the following is NOT true about forms?
Answer: (b) It can contain only text fields
Explanation: A form can also contain graphics/logos, list boxes and radio buttons, not just text fields.
4. Which of the following keys is pressed to select only textbox on the form?
Answer: (c) Ctrl
5. Which of the following properties in the Properties: Label Field text box is used to insert a tool-tip on the form?
Answer: (b) Help Text
6. Which of the following objects of LibreOffice Base is used to display data retrieved from one or more tables in a presentable manner?
Answer: (c) Report
7. Which of the following values of Date Format property is selected to view a calendar on the form?
Answer: (b) Standard (long)
8. Which of the following commands on the Forms Control toolbar is used to toggle between Design View and Form view?
Answer: (a) Design Mode
9. Using which of the following objects in a database, can a report be generated?
Answer: (c) Both a and b
10. Which of the following components open along with the Report Wizard?
Answer: (c) Both (a) and (b)
Answer: False
Explanation: Both forms and reports are objects of a database.
Answer: True
Answer: False
Explanation: We may add all or only selected fields from the table to the form.
Answer: True
Explanation: Using a Wizard and using the Design View.
Answer: True
Answer: False
Explanation: A control can be moved to another location by selecting and dragging it.
Answer: True
Answer: False
Explanation: A report can be created using a table or a query or both.
Answer: False
Explanation: Sorting is not applied by default; if set, Ascending is the default radio button selected.
Answer: True
Answer: False
Explanation: A report presents data in an attractive, customized layout, not just rows and columns.
Answer: True
Answer: False
Explanation: A report can be edited using the Report Builder window.
Answer: Entering data; Viewing data
Answer: Label; Field value text box
Answer: Label
Answer: 3D
Answer: Tool-tip
Answer: Landscape
Answer: Layout
Answer: Insert
Answer: Six
Answer: Dynamic
Answer: A form is an object of the database with a user-friendly interface used as the front end for entering and modifying data. A report, on the other hand, is used to present the data retrieved from one or more tables/queries in an attractive, customised, formatted manner for viewing/printing, not for data entry.
Answer: A field control is a component of a form consisting of two parts: a label (a piece of text specifying what data should be entered) and a field value text box (linked to the respective field in the table, where the data is entered/displayed).
Answer: The Label tool.
Answer:
Answer:
| Dynamic Report | Static Report |
|---|---|
| Changes automatically as the field values in the base table or query change. | Does not change automatically when the underlying data changes. |
| This is the default report type. | This option must be selected explicitly if required. |
Answer: