Page 346 - TP_IT_V1.0_C10_flipbpookl
P. 346
WHAT IS A FORM?
In a table the datasheet view is used to enter data. The row and column format of the data-sheet view is not a
user-friendly interface. The user may accidentally or intentionally alter the data in the table. Therefore, LibreOffice
Base provides the Form feature for data entry purposes.
Form is a database object which is used to create an interactive user interface by connecting it with a table.
Each field of a table is displayed in a text box with a Field label on one side so that the user can enter, edit and
view records in an efficient way. The data added, deleted, updated through a form will be reflected in the table
connected to the form.
For any database, it is the front end for data entry and data modification. It displays the data in a layout design by the
user and not just in a simple row and column format as seen in a table.
In a form layout the field controls are arranged in a presentable and user-friendly manner. Each field control
consists of:
• Label: A label is a piece of text that represents the field on the form.
• Field value text box: A field value text box is linked to the respective field in the table.
We may add all or selected fields from the table on the form. In addition to field controls, it may contain some additional
text like titles, headings and names, graphics like logos, list boxes and radio buttons.
A form in OpenOffice Base can be created by using any of the given methods:
• Use Wizard to Create Form
• Create Form in Design View
Creating Form Using Wizard
Creating a form using a wizard involves guiding the user through a step-by-step process to collect information or
complete a task. Each step typically focuses on gathering specific information that helps in making the form more
manageable. Follow the given steps to create a form using a wizard:
Step 1: Open the School.odb database.
Step 2: Select Forms option in the Database pane.
Step 3: Click on the Use Wizard to Create Form option from the Tasks pane.
344 Trackpad Information Technology (Ver. 1.0)-X

