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

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