Ch 12: Forms and Reports
Forms
A field control has two parts: a label (text describing the field) and a field value text box (linked to the actual table field). A form can be created in two ways.
Creating a Form using the Wizard
Forms > Use Wizard to Create Form, then follow the steps:
| Step | What you do |
|---|---|
| 1. Field selection | Select the fields from the table(s). |
| 2. Set up subform | Add a subform (optional). |
| 3. Arrange controls | Choose the layout of the controls. |
| 4. Data entry mode | Set how data is entered. |
| 5. Apply styles | Choose style and field borders. |
| 6. Name & finish | Give the form a name and click Finish. |
Modifying a Form (Design View)
- Background colour: right-click form > Page > Area tab.
- Edit label: Ctrl+Click the label > Control Properties.
- Move a control: Ctrl+Click and drag.
- Tool-tip: Control Properties > Help Text — text shown on mouse hover.
- Calendar for date: set Date Format = Standard (long) and DropDown = Yes.
- Add title text: use the Label tool on the Form Controls toolbar.
Reports
For multiple tables, create a query first, then base the report on it. Reports > Use Wizard to Create Report, then:
| Step | What you do |
|---|---|
| 1. Field selection | Choose the fields to include. |
| 2. Labelling | Set friendly labels for fields. |
| 3. Grouping | Group the records if needed. |
| 4. Sort options | Choose the sorting order. |
| 5. Layout | Choose layout and page orientation. |
| 6. Name & type | Name the report, choose Static or Dynamic, Finish. |
Enhance a report: right-click > Edit (Report Builder) to add titles/headings (Label tool) and Date/Time (Insert > Date and Time).
Summary
- A form is the front end for entering/modifying data; a field control = label + value text box.
- Forms & reports are created by Wizard or Design View.
- Forms can have tool-tips (Help Text) and a calendar for date fields.
- A report presents data from a table/query/both; it can be static or dynamic (dynamic updates automatically).
Quick check: 3 MCQs (tap an option)
Q1. A form is mainly used to:
Forms are the front end for data entry.
Q2. Text shown when the mouse hovers over a form control is set in:
Control Properties > Help Text.
Q3. A field control on a form has two parts:
The label describes; the text box holds the data.
Forms
Field control के दो हिस्से होते हैं: label (field का वर्णन करता text) और field value text box (असली table field से जुड़ा)। Form दो तरीक़ों से बनाया जाता है।
Wizard से Form बनाना
Forms > Use Wizard to Create Form, फिर steps:
| Step | क्या करते हैं |
|---|---|
| 1. Field selection | Table(s) से fields चुनिए। |
| 2. Subform | Subform जोड़िए (optional)। |
| 3. Controls arrange | Controls का layout चुनिए। |
| 4. Data entry mode | Data कैसे enter हो, set कीजिए। |
| 5. Styles | Style और field borders चुनिए। |
| 6. Name & finish | Form को नाम देकर Finish कीजिए। |
Form बदलना (Design View)
- Background colour: form पर right-click > Page > Area tab।
- Label edit: Ctrl+Click label > Control Properties।
- Control move: Ctrl+Click करके drag कीजिए।
- Tool-tip: Control Properties > Help Text — hover पर दिखता text।
- Date के लिए Calendar: Date Format = Standard (long), DropDown = Yes।
- Title text जोड़ना: Form Controls toolbar का Label tool इस्तेमाल कीजिए।
Reports
कई tables के लिए पहले query बनाइए, फिर उस पर report आधारित कीजिए। Reports > Use Wizard to Create Report, फिर:
| Step | क्या करते हैं |
|---|---|
| 1. Field selection | शामिल करने वाले fields चुनिए। |
| 2. Labelling | Fields के friendly labels set कीजिए। |
| 3. Grouping | ज़रूरत हो तो records group कीजिए। |
| 4. Sort options | Sorting order चुनिए। |
| 5. Layout | Layout और page orientation चुनिए। |
| 6. Name & type | Report को नाम दीजिए, Static या Dynamic चुनकर Finish। |
Report enhance करना: right-click > Edit (Report Builder) से titles/headings (Label tool) और Date/Time (Insert > Date and Time) जोड़िए।
सारांश
- Form data enter/modify करने का front end है; field control = label + value text box।
- Forms और reports Wizard या Design View से बनते हैं।
- Forms में tool-tips (Help Text) और date fields के लिए calendar हो सकता है।
- Report table/query/दोनों से data दिखाता है; यह static या dynamic हो सकता है (dynamic अपने आप update)।
झटपट जाँच: 3 MCQs (option पर tap करें)
Q1. Form मुख्य रूप से किसलिए होता है?
Forms data entry का front end हैं।
Q2. Mouse hover पर form control पर दिखने वाला text कहाँ सेट होता है?
Control Properties > Help Text।
Q3. Form पर field control के दो भाग होते हैं:
Label बताता है; text box data रखता है।
Frequently Asked Questions
What is the difference between a form and a report in LibreOffice Base?
A form is the user-friendly front end used to enter and modify data in a table, while a report presents the retrieved data in an attractive, formatted layout based on a table, a query, or both.
What are the two ways to create a form?
A form can be created using the Form Wizard (step by step) or using Design View, where you place and arrange the controls yourself.
What is the difference between a static and a dynamic report?
A dynamic report updates automatically whenever the underlying table or query changes, while a static report keeps its data fixed and does not update automatically.
What is a tool-tip in a form and how is it added?
A tool-tip is helpful text shown when the mouse hovers over a control. It is added through Control Properties by filling in the Help Text field.
