Difference between revisions of "LibreOffice-Suite-Base/C2/Modify-a-simple-form/English"

Spoken tutorial on LibreOffice Base: Modifying a Form Learning Objectives

• Enter data in a form
• Modifying a form

In this tutorial on Modifying a Form, we will learn how to

• Enter data in a form
• Modify a form

Enter data in a form.

We created a simple Books data entry form in our example Library database.

Let us see how we can enter data into the Books table, using this form.

Click on the 'open an existing database file' option.

In the 'Recently Used' drop down box, Library should be visible, now click on the Finish button.

And open our Library database.

If Base is already open, then we can open the Library database from here by clicking the Open inside the File menu

or by clicking the Recent Documents inside the File menu

Right click on 'Books Data entry form' and browse through list slowly. Click on open.

Show cursor movement on the window, as narration goes forward.

Click on tab keys slowly

Click on the black triangle icons in the bottom toolbar slowly.

Type in 4 in the textbox in the bottom toolbar and press enter/tab.

Click on last record icon in the bottom toolbar.

Click on New record icon right of the Last Record icon in the bottom toolbar.

Show cursor over the empty text boxes.

Type in 'Paradise Lost' in the text box right of the label 'Title', tab key once, Type in 'John Milton' against author, tab key once, Type in '1975' against PublishYear, tab key once, Type in 'Oxford' against Publisher, tab key once, Type in 200 against price.

Go to File menu>>Close.

Go to the LibreOffice Base main window, double click on Books table on the right.

Point on the last record here. Show cursor movement. Close window.

Let us click on the Forms icon in the Database list on the left panel.

Notice that the 'Books Data entry form' under Forms is highlighted in the centre of this window.

Let us right click on this form name and click on Open.

Now, we see a new window with a blue background with labels Now we are in the Library Database.

Let us click on the Forms icon in the Database list on the left panel.

Notice that the 'Books Data entry form' under Forms is highlighted in the centre of this window.

Let us right click on this form name and click on Open.

Now, we see a new window with a blue background with labels and text boxes corresponding to the fields in the Books table.

Let us click on the tab key to go to each field, and as we go to the last, Base opens the next record.

This way we can traverse the records.

Or we can also use the black triangle icons in the bottom toolbar to navigate among the records.

Alternately, to simply go to a particular record, type in the record number in the bottom toolbar and press enter key or the tab key.

Let us go to the last record which is the fifth.

Now let us add a new record.

To do this, click on the New Record icon, that is second right of the Last record icon in the bottom toolbar.

Notice that we see empty text boxes and the record number at the bottom says 6.

Now we are ready to add a new record, with information about a new book.

Let us type in 'Paradise Lost' in the Title text box, and let us use tab key to navigate to the next field,

Let us type in 'John Milton' against author

'1975' against PublishYear

'Oxford' against Publisher

and 200 against price.

There, we have just entered a new record into the Books table by using the Books Data Entry Form.

We will close this window.

We can add more records or data in this way.

Let us see if Base has updated the Books table with the last record we entered just now.

For this, in the LibreOffice Base main window, let us double click on Books table on the right panel

Notice the new record that we entered through the form here. Okay, we will close this window now.

In the main window, click on the Forms icon in the database list on the left panel.

Right click on 'Books Data Entry form', click on edit.

We will click on the Forms icon in the database list on the left panel.

And open the 'Books Data Entry form' for modifying, by right - clicking on it and then choosing 'edit'.

Show cursor over labels and text boxes.

Double-click on the label title to open small popupwindow.

Scroll by using down arrow slowly till the end.

Click on the label 'author' in the form.

Except that if you click on the label 'title', you will see several small green boxes enclosing the label and the text box.

This means that we are in the form design window

And we can modify the look and feel of the form, and its elements as well as its functionalities.

For example, we can change the placement and size of the labels and text boxes.

These are also called properties.

Double-click on the label title. This opens a smaller popup window called Properties.

Notice the various elements here.<pause>

Now let us click on the label 'author', notice that the Properties window refreshes and shows the properties of label Author.

So as we click on various elements on the form, we see that the Properties window refreshes to show the selected element's properties.

Right click on Title label, and click on 'Group' toward the bottom and click on 'Ungroup'. Click on price label.

Click on title label.

This is because we see that the author label and its textbox adjacent to it, are encased in one set of green boxes.

Base automatically has grouped the labels and corresponding textboxes in the form. We can ungroup them.

Right click on the Title label, then click on 'Group' at the bottom and then click on 'Ungroup'.

Now we see that the label title and its text box have been ungrouped.

In this way, we can modify the properties of individual elements on the form.

Scroll to the bottom

and against 'Help text' type in 'Enter the title of the book here'

Save the form by using Save icon below the File menu. Close this window.

Now let us scroll to the bottom in the Properties window.

Notice the label 'Help text' and here, let us type in 'Enter the title of the book here'

Now, let us save the form by clicking on the Save icon below the File menu on the top. And we will close this window.

Click on the Forms icon on the left,

Double-click on 'Books Data Entry Form'.

Point mouse over title label to show the tool tip.

For this, let us go to the Base main window, click on the Forms icon on the left panel,

And double-click on 'Books Data Entry Form' on the right panel.

Let us point the mouse over the title label or the text box.

Notice that a tooltip appears saying 'Enter the title of the book here'.

So now, we have learnt how to make a simple modification to our form.

We will see how to make more modifications to a form in the next part of the Base tutorial.

Assignment: Create a simple form for Members table.

Create a simple form for the Members table.

Summary

• Enter data in a form
• Modifying a form

To summarize, we learned:

• how to enter data in a form
• how to Modify a form