Difference between revisions of "LibreOffice-Suite-Base/C2/Modify-a-simple-form/English-timed"
From Script | Spoken-Tutorial
(Created page with '{| border=1 !Visual Cues !Narration |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Base. |- ||00:04 ||In this tutorial on Modifying a Form, we will learn how to Ent…') |
|||
| Line 1: | Line 1: | ||
{| border=1 | {| border=1 | ||
| − | + | |'''Time''' | |
| − | + | |'''Narration''' | |
|- | |- | ||
||00:00 | ||00:00 | ||
Revision as of 14:52, 9 July 2014
| Time | Narration |
| 00:00 | Welcome to the Spoken tutorial on LibreOffice Base. |
| 00:04 | In this tutorial on Modifying a Form, we will learn how to Enter data in a form, Modify a form |
| 00:14 | In the previous tutorial, we learnt to create a form using LibreOffice Base. |
| 00:22 | We created a simple Books data entry form in our example Library database. |
| 00:29 | Let us see how we can enter data into the Books table, using this form. |
| 00:39 | Let us first invoke the LibreOffice Base program, if it's not already open. |
| 00:48 | And open our Library database. |
| 00:52 | If Base is already open, then we can open the Library database from here by clicking the Open inside the File menu |
| 01:03 | or by clicking the Recent Documents inside the File menu |
| 01:08 | Now we are in the Library Database. |
| 01:12 | Let us click on the Forms icon in the Database list on the left panel. |
| 01:18 | Notice that the 'Books Data entry form' under Forms is highlighted in the centre of this window. |
| 01:28 | Let us right click on this form name and click on Open. |
| 01:33 | Now, we see a new window with a blue background with labels and text boxes corresponding to the fields in the Books table. |
| 01:45 | Let us click on the tab key to go to each field, and as we go to the last, Base opens the next record. |
| 01:56 | This way we can traverse the records. |
| 02:00 | Or we can also use the black triangle icons in the bottom toolbar to navigate among the records. |
| 02:10 | 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. |
| 02:23 | Let us go to the last record which is the fifth. |
| 02:29 | Now let us add a new record. |
| 02:34 | To do this, click on the New Record icon, that is second right of the Last record icon in the bottom toolbar. |
| 02:46 | Notice that we see empty text boxes and the record number at the bottom says 6. |
| 02:55 | Now we are ready to add a new record, with information about a new book. |
| 03:03 | Let us type in 'Paradise Lost' in the Title text box, and let us use tab key to navigate to the next field, |
| 03:17 | Let us type in 'John Milton' against author |
| 03:23 | '1975' against PublishYear |
| 03:28 | 'Oxford' against Publisher |
| 03:31 | and 200 against price. |
| 03:36 | There, we have just entered a new record into the Books table by using the Books Data Entry Form. |
| 03:45 | We will close this window. |
| 03:47 | We can add more records or data in this way. |
| 03:53 | Let us see if Base has updated the Books table with the last record we entered just now. |
| 04:02 | For this, in the LibreOffice Base main window, let us double click on Books table on the right panel |
| 04:12 | Notice the new record that we entered through the form here. |
| 04:18 | Okay, we will close this window now. |
| 04:23 | Next, let us learn how to make simple modifications to our form. |
| 04:30 | We will click on the Forms icon in the database list on the left panel. |
| 04:37 | And open the 'Books Data Entry form' for modifying, by right - clicking on it and then choosing 'edit'. |
| 04:47 | A familiar window opens now, |
| 04:51 | Except that if you click on the label 'title', you will see several small green boxes enclosing the label and the text box. |
| 05:03 | This means that we are in the form design window |
| 05:08 | And we can modify the look and feel of the form, and its elements as well as its functionalities. |
| 05:17 | For example, we can change the placement and size of the labels and text boxes. |
| 05:25 | These are also called properties. |
| 05:28 | Double-click on the label title. |
| 05:31 | This opens a smaller popup window called Properties. |
| 05:38 | Notice the various elements here. |
| 05:48 | Now let us click on the label 'author', notice that the Properties window refreshes and shows the properties of label Author. |
| 06:01 | So as we click on various elements on the form, we see that the Properties window refreshes to show the selected element's properties. |
| 06:14 | Now, the Properties window title reads as Properties MultiSelection. |
| 06:21 | This is because we see that the author label and its textbox adjacent to it, are encased in one set of green boxes. |
| 06:34 | Base automatically has grouped the labels and corresponding textboxes in the form.
We can ungroup them. |
| 06:44 | Right click on the Title label and then click on 'Group' at the bottom then click on 'Ungroup'. |
| 06:54 | Now we see that the label title and its text box have been ungrouped. |
| 07:02 | In this way, we can modify the properties of individual elements on the form. |
| 07:10 | Next, let us add a tool tip to the title text box. |
| 07:16 | Now let us scroll to the bottom in the Properties window. |
| 07:22 | Notice the label 'Help text' and here, let us type in 'Enter the title of the book here' |
| 07:32 | 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. |
| 07:46 | Let us now see, how our form looks like after the modification that we made. |
| 07:54 | For this, let us go to the Base main window, click on the Forms icon on the left panel, |
| 08:03 | And double-click on 'Books Data Entry Form' on the right panel. |
| 08:10 | Let us point the mouse over the title label or the text box. |
| 08:17 | Notice that a tooltip appears saying 'Enter the title of the book here'. |
| 08:24 | So now, we have learnt how to make a simple modification to our form. |
| 08:31 | We will see how to make more modifications to a form in the next part of the Base tutorial. |
| 08:39 | Here is an assignment. |
| 08:41 | Create a simple form for the Members table. |
| 08:46 | This brings us to the end of this tutorial on Modifying a Form in LibreOffice Base. |
| 08:52 | To summarize, we learned: how to enter data in a form,how to Modify a form |
| 09:00 | Spoken Tutorial Project is a part of the Talk to a Teacher project, supported by the National Mission on Education through ICT, MHRD, Government of India. |
| 09:12 | This project is co-ordinated by http://spoken-tutorial.org. |
| 09:17 | More information on the same is available at the following link. |
| 09:22 | This Script has been contributed by Priya Suresh, DesuCrew solutions.
And this is Soundharya, desi crew solutions, signing off. Thanks for joining |
