Difference between revisions of "LibreOffice-Suite-Base/C2/Add-Push-Button-to-a-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:03 ||In this tutorial, we will learn how to Add a Push Button to a f…') |
Sandhya.np14 (Talk | contribs) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{| border=1 | {| border=1 | ||
− | + | |'''Time''' | |
− | + | |'''Narration''' | |
|- | |- | ||
||00:00 | ||00:00 | ||
− | ||Welcome to the Spoken tutorial on LibreOffice Base. | + | ||Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''. |
|- | |- | ||
||00:03 | ||00:03 | ||
− | ||In this tutorial, we will learn how to | + | ||In this tutorial, we will learn how to add a '''Push Button''' to a '''form'''. |
|- | |- | ||
||00:10 | ||00:10 | ||
− | ||In the last tutorial, we learnt how to add a list box form control to a form. | + | ||In the last tutorial, we learnt how to add a '''list box form control''' to a form. |
|- | |- | ||
||00:17 | ||00:17 | ||
− | ||Now in this tutorial, we will learn how to add push | + | ||Now in this tutorial, we will learn how to add '''push button'''s to a '''form'''. |
|- | |- | ||
||00:24 | ||00:24 | ||
− | ||Let us first invoke the LibreOffice Base program, if it's not already open | + | ||Let us first invoke the '''LibreOffice Base''' program, if it's not already open |
|- | |- | ||
||00:36 | ||00:36 | ||
− | | | + | |and open our 'Library' database. You probably know how to open an existing database by now. |
|- | |- | ||
||00:45 | ||00:45 | ||
− | ||Click Open under the File menu and choose Library database. | + | ||Click '''Open''' under the '''File''' menu and choose '''Library''' database. |
|- | |- | ||
||00:52 | ||00:52 | ||
− | ||Now we are in the Library database. | + | ||Now we are in the '''Library''' database. |
|- | |- | ||
||00:56 | ||00:56 | ||
− | ||Let us open the 'Books Issued to Members' form that we were working with in the last tutorial. | + | ||Let us open the 'Books Issued to Members' '''form''' that we were working with, in the last tutorial. |
|- | |- | ||
||01:04 | ||01:04 | ||
− | ||To do this, let us click on the Forms icon on the left panel | + | ||To do this, let us click on the '''Forms''' icon on the left panel |
|- | |- | ||
||01:09 | ||01:09 | ||
− | || | + | ||and then right-click on the 'Books Issued to Members' form on the right panel. |
|- | |- | ||
||01:16 | ||01:16 | ||
− | ||Now click on Edit. | + | ||Now click on '''Edit'''. |
|- | |- | ||
||01:19 | ||01:19 | ||
− | ||We are now in the | + | ||We are now in the '''Form Design''' window. |
|- | |- | ||
||01:23 | ||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. | + | ||Before we talk about adding '''Push buttons''' to our '''form''', let us make some way for the second list box for Member names. |
|- | |- | ||
Line 64: | Line 64: | ||
|- | |- | ||
||01:41 | ||01:41 | ||
− | ||First, let us remove the text box that is on the right of the Member Name label | + | ||First, let us remove the text-box that is on the right of the '''Member Name''' label |
|- | |- | ||
||01:50 | ||01:50 | ||
− | ||by right-clicking on this text box and then clicking on Cut. | + | ||by right-clicking on this text-box and then clicking on '''Cut'''. |
|- | |- | ||
||01:57 | ||01:57 | ||
− | ||The text box is deleted. | + | ||The text-box is deleted. |
|- | |- | ||
||02:00 | ||02:00 | ||
− | ||Next, let us arrange the form | + | ||Next, let us arrange the '''form element'''s. |
|- | |- | ||
||02:04 | ||02:04 | ||
− | ||Since list boxes need more space than text boxes, we will push the form elements further down on the form. | + | ||Since list-boxes need more space than text-boxes, we will push the form elements further down on the form. |
|- | |- | ||
Line 88: | Line 88: | ||
|- | |- | ||
||02:17 | ||02:17 | ||
− | ||First let us select all the form elements that are below the Book title label. | + | ||First let us select all the form elements that are below the '''Book title''' label. |
|- | |- | ||
Line 96: | Line 96: | ||
|- | |- | ||
||02:32 | ||02:32 | ||
− | ||Next, let us click on the selected area and drag it vertically down | + | ||Next, let us click on the selected area and drag it vertically down |
|- | |- | ||
||02:39 | ||02:39 | ||
− | ||so that there is enough room for the first list box that is adjacent to the Book Title label. | + | ||so that there is enough room for the first list-box that is adjacent to the '''Book Title''' label. |
|- | |- | ||
||02:48 | ||02:48 | ||
− | ||Now, let us repeat the same step for the Member Name label as well. | + | ||Now, let us repeat the same step for the '''Member Name''' label as well. |
|- | |- | ||
||03:05 | ||03:05 | ||
− | ||Now, let us click, drag and drop the second list box, that is to the left of the Member Name label | + | ||Now, let us click, drag and drop the second list box, that is to the left of the '''Member Name''' label |
|- | |- | ||
||03:14 | ||03:14 | ||
− | || | + | ||and move to its right so that it is aligned with the rest of the form controls nicely. |
|- | |- | ||
||03:22 | ||03:22 | ||
− | ||Okay, let us save our work on the form so far | + | ||Okay, let us '''save''' our work on the '''form''' so far by using the keyboard shortcut '''Control, S'''. |
|- | |- | ||
||03:32 | ||03:32 | ||
− | ||Now, we are ready to add Push buttons to our form. | + | ||Now, we are ready to add 'Push buttons' to our form. |
|- | |- | ||
Line 128: | Line 128: | ||
|- | |- | ||
||03:44 | ||03:44 | ||
− | ||We are familiar with OK, Cancel, Next | + | ||We are familiar with '''OK, Cancel, Next''' and '''Finish''' buttons; these are some examples of Push buttons. |
|- | |- | ||
||03:56 | ||03:56 | ||
− | ||With Base, we can add these Push buttons to our form and instruct Base, to perform specific actions when clicked. | + | ||With '''Base''', we can add these Push buttons to our form and instruct Base, to perform specific actions when clicked. |
|- | |- | ||
||04:07 | ||04:07 | ||
− | ||Again, Save or Undo | + | ||Again, '''Save''' or '''Undo''' or '''Delete''' are some examples. |
|- | |- | ||
Line 148: | Line 148: | ||
|- | |- | ||
||04:30 | ||04:30 | ||
− | ||To do this, let us go back to our | + | ||To do this, let us go back to our '''Form Design''' window. |
|- | |- | ||
||04:35 | ||04:35 | ||
− | ||And, click once on the Push button icon in the Form Controls toolbar. | + | ||And, click once on the '''Push button''' icon in the '''Form Controls''' toolbar. |
|- | |- | ||
||04:43 | ||04:43 | ||
− | ||This icon looks like a button with the word | + | ||This icon looks like a button with the word '''OK''' on it. |
|- | |- | ||
||04:50 | ||04:50 | ||
− | ||Notice that the mouse pointer looks like a plus symbol. | + | ||Notice that the '''mouse''' pointer looks like a plus symbol. |
|- | |- | ||
||04:57 | ||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. | + | ||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 | ||05:10 | ||
− | ||And, we will resize it accordingly. | + | ||And, we will '''resize''' it accordingly. |
|- | |- | ||
||05:14 | ||05:14 | ||
− | ||Now let us repeat the above step three more times | + | ||Now let us repeat the above step three more times. |
|- | |- | ||
||05:27 | ||05:27 | ||
− | || | + | ||And now, we have three more buttons, all aligned in one horizontal line. |
|- | |- | ||
||05:35 | ||05:35 | ||
− | ||We are done drawing the push buttons on the form; now let us change their labels. | + | ||We are done drawing the push buttons on the '''form'''; now let us change their labels. |
|- | |- | ||
Line 188: | Line 188: | ||
|- | |- | ||
||05:49 | ||05:49 | ||
− | ||We now see the Properties window. Here let us type 'Save Record' against the 'Label'. | + | ||We now see the '''Properties''' window. Here, let us type 'Save Record' against the 'Label'. |
|- | |- | ||
Line 196: | Line 196: | ||
|- | |- | ||
||06:06 | ||06:06 | ||
− | ||And in the | + | ||And in the 'Properties window', we will type 'Undo Changes' against the '''Label'''. |
|- | |- | ||
Line 208: | Line 208: | ||
|- | |- | ||
||06:31 | ||06:31 | ||
− | ||Now let us define their actions. | + | ||Now, let us define their actions. |
|- | |- | ||
||06:37 | ||06:37 | ||
− | ||To do this, let us click on 'Save Record' button | + | ||To do this, let us click on 'Save Record' button |
|- | |- | ||
||06:43 | ||06:43 | ||
− | || | + | ||and in the 'Properties window', let us scroll down until we spot the 'Action' label. |
|- | |- | ||
||06:51 | ||06:51 | ||
− | ||Here, we will click on the drop down list box and click on the 'Save record'. | + | ||Here, we will click on the drop-down list box and click on the '''Save record'''. |
|- | |- | ||
Line 228: | Line 228: | ||
|- | |- | ||
||07:05 | ||07:05 | ||
− | ||For the 'Undo Changes' button, we will choose the 'Undo | + | ||For the '''Undo Changes''' button, we will choose the '''Undo data entry''' '''Action'''. |
|- | |- | ||
||07:12 | ||07:12 | ||
− | ||For the 'Delete Record' button, we will choose the 'Delete Record' | + | ||For the '''Delete Record''' button, we will choose the '''Delete Record''' Action. |
|- | |- | ||
||07:18 | ||07:18 | ||
− | ||And for the 'New Record' button, we will choose the 'New | + | ||And for the '''New Record''' button, we will choose the '''New record''' Action. |
|- | |- | ||
||07:25 | ||07:25 | ||
− | ||So, now we have added the push buttons. | + | ||So, now we have added the '''push buttons'''. |
|- | |- | ||
||07:29 | ||07:29 | ||
− | ||Okay, let us save our form by using the keyboard shortcut Control | + | ||Okay, let us '''save''' our '''form''' by using the keyboard shortcut '''Control, S''' and close this '''window'''. |
|- | |- | ||
Line 256: | Line 256: | ||
|- | |- | ||
||07:54 | ||07:54 | ||
− | ||For example, when a Library member returns a book, we can update this information in the database using this form. | + | ||For example, when a Library member returns a book, we can update this information in the database using this '''form'''. |
|- | |- | ||
Line 264: | Line 264: | ||
|- | |- | ||
||08:08 | ||08:08 | ||
− | ||Add a fifth push button to the form beside the fourth | + | ||Add a fifth push button to the form beside the fourth and when used, it should '''refresh''' the form. |
|- | |- | ||
Line 272: | Line 272: | ||
|- | |- | ||
||08:30 | ||08:30 | ||
− | ||This brings us to the end of this tutorial on LibreOffice Base | + | ||This brings us to the end of this tutorial on 'LibreOffice Base'. |
|- | |- | ||
||08:35 | ||08:35 | ||
− | ||To summarize, we learned how to:Add a Push Button to a form. | + | ||To summarize, we learned how to: Add a Push Button to a form. |
|- | |- | ||
||08:40 | ||08:40 | ||
− | |Spoken Tutorial | + | |'''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 | ||08:52 | ||
− | ||This project is | + | ||This project is coordinated by http://spoken-tutorial.org. |
|- | |- | ||
Line 292: | Line 292: | ||
|- | |- | ||
||09:02 | ||09:02 | ||
− | ||This script has been contributed by Priya Suresh, DesiCrew Solutions. | + | ||This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off. |
− | + | Thanks for joining. | |
− | And this is Soundharya, DesiCrew Solutions, signing off. | + | |
− | + | ||
− | Thanks for joining | + | |
|- | |- |
Latest revision as of 20:15, 13 January 2016
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. |