LibreOffice-Suite-Base/C2/Add-Push-Button-to-a-form/English-timed

From Script | Spoken-Tutorial
Jump to: navigation, search
Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Base.
00:03 In this tutorial, we will learn how to add a Push Button to a form.
00:10 In the last tutorial, we learnt how to add a list box form control to a form.
00:17 Now in this tutorial, we will learn how to add push buttons to a form.
00:24 Let us first invoke the LibreOffice Base program, if it's not already open
00:36 and open our 'Library' database. You probably know how to open an existing database by now.
00:45 Click Open under the File menu and choose Library database.
00:52 Now we are in the Library database.
00:56 Let us open the 'Books Issued to Members' form that we were working with, in the last tutorial.
01:04 To do this, let us click on the Forms icon on the left panel
01:09 and then right-click on the 'Books Issued to Members' form on the right panel.
01:16 Now click on Edit.
01:19 We are now in the Form Design window.
01:23 Before we talk about adding Push buttons to our form, let us make some way for the second list box for Member names.
01:34 Remember, we had an assignment of creating the second list box in the previous tutorial.
01:41 First, let us remove the text-box that is on the right of the Member Name label
01:50 by right-clicking on this text-box and then clicking on Cut.
01:57 The text-box is deleted.
02:00 Next, let us arrange the form elements.
02:04 Since list-boxes need more space than text-boxes, we will push the form elements further down on the form.
02:15 Here is how we will do it.
02:17 First let us select all the form elements that are below the Book title label.
02:26 For this, we will use the click, drag and drop method.
02:32 Next, let us click on the selected area and drag it vertically down
02:39 so that there is enough room for the first list-box that is adjacent to the Book Title label.
02:48 Now, let us repeat the same step for the Member Name label as well.
03:05 Now, let us click, drag and drop the second list box, that is to the left of the Member Name label
03:14 and move to its right so that it is aligned with the rest of the form controls nicely.
03:22 Okay, let us save our work on the form so far by using the keyboard shortcut Control, S.
03:32 Now, we are ready to add 'Push buttons' to our form.
03:39 A push button is another example of a form control.
03:44 We are familiar with OK, Cancel, Next and Finish buttons; these are some examples of Push buttons.
03:56 With Base, we can add these Push buttons to our form and instruct Base, to perform specific actions when clicked.
04:07 Again, Save or Undo or Delete are some examples.
04:14 Let us see how.
04:17 Let us now add four push buttons to our form, below all the other form elements, just as in the image shown here.
04:30 To do this, let us go back to our Form Design window.
04:35 And, click once on the Push button icon in the Form Controls toolbar.
04:43 This icon looks like a button with the word OK on it.
04:50 Notice that the mouse pointer looks like a plus symbol.
04:57 Now, let us draw our first button on the bottom left, by clicking, dragging and dropping on the form, below all the other elements.
05:10 And, we will resize it accordingly.
05:14 Now let us repeat the above step three more times.
05:27 And now, we have three more buttons, all aligned in one horizontal line.
05:35 We are done drawing the push buttons on the form; now let us change their labels.
05:43 To do this, double-click on the first button.
05:49 We now see the Properties window. Here, let us type 'Save Record' against the 'Label'.
05:59 Now, let us click on the second button on the form.
06:06 And in the 'Properties window', we will type 'Undo Changes' against the Label.
06:15 For the third and the fourth buttons, let us type 'Delete Record'
06:25 and 'New Record' respectively.
06:31 Now, let us define their actions.
06:37 To do this, let us click on 'Save Record' button
06:43 and in the 'Properties window', let us scroll down until we spot the 'Action' label.
06:51 Here, we will click on the drop-down list box and click on the Save record.
06:59 Let us follow the same steps for the other three buttons.
07:05 For the Undo Changes button, we will choose the Undo data entry Action.
07:12 For the Delete Record button, we will choose the Delete Record Action.
07:18 And for the New Record button, we will choose the New record Action.
07:25 So, now we have added the push buttons.
07:29 Okay, let us save our form by using the keyboard shortcut Control, S and close this window.
07:40 In the next tutorial, we will go through just three more simple modifications to our form
07:47 and then we can use the form for data entry and data updates.
07:54 For example, when a Library member returns a book, we can update this information in the database using this form.
08:06 Here is an assignment:
08:08 Add a fifth push button to the form beside the fourth and when used, it should refresh the form.
08:18 And add 4 narrow push buttons in the next line below. These buttons should help us navigate through the records.
08:30 This brings us to the end of this tutorial on 'LibreOffice Base'.
08:35 To summarize, we learned how to: Add a Push Button to a form.
08:40 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.
08:52 This project is coordinated by http://spoken-tutorial.org.
08:57 More information on the same is available at the following link.
09:02 This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off.

Thanks for joining.

Contributors and Content Editors

Gaurav, Minal, Sandhya.np14