Difference between revisions of "LibreOffice-Suite-Base/C2/Add-List-Box-form-control-to-a-form/English-timed"
From Script | Spoken-Tutorial
Sandhya.np14 (Talk | contribs) |
|||
Line 4: | Line 4: | ||
|- | |- | ||
||00:03 | ||00:03 | ||
− | ||Welcome to the Spoken tutorial on LibreOffice Base. | + | ||Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''. |
|- | |- | ||
||00:06 | ||00:06 | ||
− | ||In this tutorial, we will learn how to Add a List Box form control to a form | + | ||In this tutorial, we will learn how to Add a '''List Box form control''' to a '''form'''. |
|- | |- | ||
||00:14 | ||00:14 | ||
− | ||In the last tutorial, we learnt how to modify a form using LibreOffice Base. | + | ||In the last tutorial, we learnt how to modify a form using '''LibreOffice Base'''. |
|- | |- | ||
Line 20: | Line 20: | ||
|- | |- | ||
||00:34 | ||00:34 | ||
− | ||And once we are done with our design, this is how our form will look like. | + | ||And once we are done with our design, this is how our '''form''' will look like. |
|- | |- | ||
||00:45 | ||00:45 | ||
− | ||Notice here | + | ||Notice here that we are seeing the first '''record''' in the '''Books Issued''' '''Table'''. |
|- | |- | ||
||00:52 | ||00:52 | ||
− | ||And, we are also seeing list boxes with real book titles and member names, instead of book | + | ||And, we are also seeing list boxes with real book titles and member names, instead of 'book Id's and 'member Id's. |
|- | |- | ||
||01:01 | ||01:01 | ||
− | ||Here are some push buttons at the bottom for performing actions like saving a record, undoing the changes etc. | + | ||Here are some push-buttons at the bottom for performing actions like saving a record, undoing the changes etc. |
|- | |- | ||
||01:11 | ||01:11 | ||
− | ||So in this tutorial, we will learn how to add a List box form control to our form. | + | ||So, in this tutorial, we will learn how to add a '''List box form control''' to our form. |
|- | |- | ||
||01:20 | ||01:20 | ||
− | ||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 |
|- | |- | ||
||01:32 | ||01:32 | ||
− | || | + | ||and open our '''Library''' database. |
|- | |- | ||
||01:35 | ||01:35 | ||
− | ||If Base is already open | + | ||If '''Base''' is already open then we can open the 'Library database' from here by clicking '''Open''' under the '''File''' menu |
|- | |- | ||
||01:45 | ||01:45 | ||
− | ||or by clicking the Recent Documents under the File menu | + | ||or by clicking the '''Recent Documents''' under the '''File''' menu. |
|- | |- | ||
||01:50 | ||01:50 | ||
− | ||Now we are in the Library database. | + | ||Now we are in the 'Library database'. |
|- | |- | ||
||01:54 | ||01:54 | ||
− | ||Let us open 'Books Issued to Members' form that we created in the last tutorial. | + | ||Let us open 'Books Issued to Members' '''form''' that we created in the last tutorial. |
|- | |- | ||
||02:01 | ||02:01 | ||
− | ||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. |
|- | |- | ||
||02:07 | ||02:07 | ||
− | ||And right click on the 'Books Issued to Members' form on the right panel | + | ||And right-click on the 'Books Issued to Members' form on the right panel and then click on '''edit'''. |
|- | |- | ||
||02:17 | ||02:17 | ||
− | ||We are now in the | + | ||We are now in the '''Form Design''' window. |
|- | |- | ||
Line 80: | Line 80: | ||
|- | |- | ||
||02:25 | ||02:25 | ||
− | ||Notice that the text box here will only display BookId numbers which are not friendly on our eyes. | + | ||Notice that the text-box here, will only display 'BookId 'numbers which are not friendly on our eyes. |
|- | |- | ||
Line 88: | Line 88: | ||
|- | |- | ||
||02:37 | ||02:37 | ||
− | ||And so, to display these titles, Base provides some ways | + | ||And so, to display these titles, '''Base''' provides some ways and one of the ways is by using a '''List box form control'''. |
|- | |- | ||
Line 96: | Line 96: | ||
|- | |- | ||
||02:51 | ||02:51 | ||
− | ||For this, let us first remove the text box adjacent to the Book Title label. | + | ||For this, let us first remove the text-box adjacent to the '''Book Title''' label. |
|- | |- | ||
||02:59 | ||02:59 | ||
− | ||We can do this by clicking on the text box which selects it with the familiar set of green boxes | + | ||We can do this by clicking on the text-box which selects it with the familiar set of green boxes |
|- | |- | ||
||03:09 | ||03:09 | ||
− | || | + | ||and then by right-clicking and clicking on '''Cut''' at the bottom. |
|- | |- | ||
||03:16 | ||03:16 | ||
− | ||There, we have removed the text box. | + | ||There, we have removed the text-box. |
|- | |- | ||
||03:20 | ||03:20 | ||
− | ||Now, we will place a List box form control here. | + | ||Now, we will place a 'List box form control' here. |
|- | |- | ||
||03:26 | ||03:26 | ||
− | ||This can be accessed in the Form Controls toolbar. | + | ||This can be accessed in the '''Form Controls''' toolbar. |
|- | |- | ||
||03:31 | ||03:31 | ||
− | ||We can bring it up by using the View menu and clicking on the Form Controls. | + | ||We can bring it up by using the '''View''' menu and clicking on the '''Form Controls'''. |
|- | |- | ||
||03:39 | ||03:39 | ||
− | ||Notice that Base provides us a lot of form controls; let us point our cursor over these icons to read the tool tips. | + | ||Notice that '''Base''' provides us a lot of 'form controls'; let us point our cursor over these icons to read the tool tips. |
|- | |- | ||
Line 136: | Line 136: | ||
|- | |- | ||
||04:11 | ||04:11 | ||
− | ||And let us move the mouse pointer into the form; notice that it has changed to a thin plus symbol. | + | ||And let us move the '''mouse''' pointer into the '''form'''; notice that it has changed to a thin plus symbol. |
|- | |- | ||
||04:21 | ||04:21 | ||
− | ||Now we can draw the | + | ||Now we can draw the 'listbox form control' on our form. |
|- | |- | ||
||04:26 | ||04:26 | ||
− | ||For this, we will simply click, drag and drop it on our form | + | ||For this, we will simply click, drag and drop it on our form. |
|- | |- | ||
||04:34 | ||04:34 | ||
− | ||Let us place it where we removed the text box earlier. | + | ||Let us place it where we removed the text-box earlier. |
|- | |- | ||
||04:39 | ||04:39 | ||
− | ||Notice that a new wizard called 'List Box Wizard' has opened up over the Form design window. | + | ||Notice that a new wizard called 'List Box Wizard' has opened up over the '''Form design''' window. |
|- | |- | ||
||04:48 | ||04:48 | ||
− | ||Now, this wizard will help us connect the list box to the Book title label. | + | ||Now, this wizard will help us connect the list box to the 'Book title' label. |
|- | |- | ||
Line 164: | Line 164: | ||
|- | |- | ||
||04:58 | ||04:58 | ||
− | ||In this wizard, let us first | + | ||In this wizard, let us first choose the table from where we can get the book titles. |
|- | |- | ||
||05:07 | ||05:07 | ||
− | ||We will choose the Books table from the list and click on the Next button. | + | ||We will choose the '''Books''' table from the list and click on the '''Next''' button. |
|- | |- | ||
||05:15 | ||05:15 | ||
− | ||Now, in this window, we need to choose the field that will be displayed in the List box. | + | ||Now, in this window, we need to choose the '''field''' that will be displayed in the List box. |
|- | |- | ||
||05:24 | ||05:24 | ||
− | ||And we know that the | + | ||And we know that the '''Title''' field stores the book titles. |
|- | |- | ||
||05:29 | ||05:29 | ||
− | ||So let us go to the next step. | + | ||So, let us go to the next step. |
|- | |- | ||
Line 188: | Line 188: | ||
|- | |- | ||
||05:37 | ||05:37 | ||
− | ||We will connect the related | + | ||We will connect the related '''table'''s and '''field'''s. |
|- | |- | ||
||05:41 | ||05:41 | ||
− | ||Look at the field names. The 'Fields in the Value table' on the left are the fields in the Books Issued table | + | ||Look at the field names. The 'Fields in the Value table' on the left are the fields in the 'Books Issued' table. |
|- | |- | ||
||05:52 | ||05:52 | ||
− | ||And the 'Fields in the list table' on the right are the fields in the Books table. | + | ||And the 'Fields in the list table' on the right are the fields in the 'Books' table. |
|- | |- | ||
||05:59 | ||05:59 | ||
− | ||We also know that book id is the key field in the books table and is represented in the Books Issued table. | + | ||We also know that 'book id' is the key field in the 'books table' and is represented in the 'Books Issued' table. |
|- | |- | ||
||06:10 | ||06:10 | ||
− | ||So we will click on | + | ||So, we will click on '''Book id''' on the left side list that says 'Field from the value table'. |
|- | |- | ||
||06:19 | ||06:19 | ||
− | ||Next we will click on | + | ||Next, we will click on '''Book id''' on the right side list that says 'Field from the list table'. |
|- | |- | ||
||06:29 | ||06:29 | ||
− | ||Click on the Finish button to close this wizard. | + | ||Click on the '''Finish''' button to close this wizard. |
|- | |- | ||
Line 220: | Line 220: | ||
|- | |- | ||
||06:40 | ||06:40 | ||
− | ||Now Base will automatically display all the Book titles in this List box. | + | ||Now, '''Base''' will automatically display all the Book titles in this '''List box'''. |
|- | |- | ||
||06:46 | ||06:46 | ||
− | ||Let us now save the form | + | ||Let us now '''save''' the '''form''' |
|- | |- | ||
||06:49 | ||06:49 | ||
− | || | + | ||and close this window. |
|- | |- | ||
||06:52 | ||06:52 | ||
− | ||In the next part of the Base tutorial, we will continue adding the rest of the form controls to our form. | + | ||In the next part of the '''Base''' tutorial, we will continue adding the rest of the '''form controls''' to our form. |
|- | |- | ||
||07:00 | ||07:00 | ||
− | ||And this is how our form will look like, when we are done. | + | ||And this is how our '''form''' will look like, when we are done. |
|- | |- | ||
Line 244: | Line 244: | ||
|- | |- | ||
||07:08 | ||07:08 | ||
− | ||Add a second list box for listing member names instead of unfriendly member Ids. | + | ||Add a second list box for listing 'member names' instead of unfriendly 'member Ids'. |
|- | |- | ||
||07:17 | ||07:17 | ||
− | ||Do not worry about the placement of the list box now. Just draw it to the left of the Member name label. | + | ||Do not worry about the placement of the list box now. Just draw it to the left of the '''Member name''' label. |
|- | |- | ||
||07:27 | ||07:27 | ||
− | ||We will relocate it appropriately across the Member Name label in our next tutorial. | + | ||We will relocate it appropriately across the 'Member Name' label in our next tutorial. |
|- | |- | ||
||07:34 | ||07:34 | ||
− | ||This brings us to the end of this tutorial on List Box Control in LibreOffice Base | + | ||This brings us to the end of this tutorial on '''List Box Control''' in '''LibreOffice Base'''. |
|- | |- | ||
||07:40 | ||07:40 | ||
− | ||To summarize, we learned how to: Add a List Box form control to a form. | + | ||To summarize, we learned how to: Add a 'List Box form control' to a form. |
|- | |- | ||
||07:47 | ||07:47 | ||
− | ||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. |
|- | |- | ||
||07:58 | ||07:58 | ||
− | ||This project is | + | ||This project is coordinated by http://spoken-tutorial.org. |
|- | |- | ||
Line 276: | Line 276: | ||
|- | |- | ||
||08:08 | ||08:08 | ||
− | ||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. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- |
Latest revision as of 11:17, 28 September 2015
Time | Narration |
00:03 | Welcome to the Spoken tutorial on LibreOffice Base. |
00:06 | In this tutorial, we will learn how to Add a List Box form control to a form. |
00:14 | In the last tutorial, we learnt how to modify a form using LibreOffice Base. |
00:20 | We also saw this image of the form that we started creating and modifying in the last tutorial. |
00:34 | And once we are done with our design, this is how our form will look like. |
00:45 | Notice here that we are seeing the first record in the Books Issued Table. |
00:52 | And, we are also seeing list boxes with real book titles and member names, instead of 'book Id's and 'member Id's. |
01:01 | Here are some push-buttons at the bottom for performing actions like saving a record, undoing the changes etc. |
01:11 | So, in this tutorial, we will learn how to add a List box form control to our form. |
01:20 | Let us first invoke the LibreOffice Base program, if it's not already open |
01:32 | and open our Library database. |
01:35 | If Base is already open then we can open the 'Library database' from here by clicking Open under the File menu |
01:45 | or by clicking the Recent Documents under the File menu. |
01:50 | Now we are in the 'Library database'. |
01:54 | Let us open 'Books Issued to Members' form that we created in the last tutorial. |
02:01 | To do this, let us click on the Forms icon on the left panel. |
02:07 | And right-click on the 'Books Issued to Members' form on the right panel and then click on edit. |
02:17 | We are now in the Form Design window. |
02:21 | Let us first consider the 'Book Title' label. |
02:25 | Notice that the text-box here, will only display 'BookId 'numbers which are not friendly on our eyes. |
02:33 | For us, book titles are friendlier. |
02:37 | And so, to display these titles, Base provides some ways and one of the ways is by using a List box form control. |
02:48 | Let us see how. |
02:51 | For this, let us first remove the text-box adjacent to the Book Title label. |
02:59 | We can do this by clicking on the text-box which selects it with the familiar set of green boxes |
03:09 | and then by right-clicking and clicking on Cut at the bottom. |
03:16 | There, we have removed the text-box. |
03:20 | Now, we will place a 'List box form control' here. |
03:26 | This can be accessed in the Form Controls toolbar. |
03:31 | We can bring it up by using the View menu and clicking on the Form Controls. |
03:39 | Notice that Base provides us a lot of 'form controls'; let us point our cursor over these icons to read the tool tips. |
04:01 | Let us find our list box icon. |
04:04 | There it is, let us click just once on this icon. |
04:11 | And let us move the mouse pointer into the form; notice that it has changed to a thin plus symbol. |
04:21 | Now we can draw the 'listbox form control' on our form. |
04:26 | For this, we will simply click, drag and drop it on our form. |
04:34 | Let us place it where we removed the text-box earlier. |
04:39 | Notice that a new wizard called 'List Box Wizard' has opened up over the Form design window. |
04:48 | Now, this wizard will help us connect the list box to the 'Book title' label. |
04:56 | Let us see how. |
04:58 | In this wizard, let us first choose the table from where we can get the book titles. |
05:07 | We will choose the Books table from the list and click on the Next button. |
05:15 | Now, in this window, we need to choose the field that will be displayed in the List box. |
05:24 | And we know that the Title field stores the book titles. |
05:29 | So, let us go to the next step. |
05:32 | This final window is where we will do the magic. |
05:37 | We will connect the related tables and fields. |
05:41 | Look at the field names. The 'Fields in the Value table' on the left are the fields in the 'Books Issued' table. |
05:52 | And the 'Fields in the list table' on the right are the fields in the 'Books' table. |
05:59 | We also know that 'book id' is the key field in the 'books table' and is represented in the 'Books Issued' table. |
06:10 | So, we will click on Book id on the left side list that says 'Field from the value table'. |
06:19 | Next, we will click on Book id on the right side list that says 'Field from the list table'. |
06:29 | Click on the Finish button to close this wizard. |
06:34 | There, we have connected the related tables and fields. |
06:40 | Now, Base will automatically display all the Book titles in this List box. |
06:46 | Let us now save the form |
06:49 | and close this window. |
06:52 | In the next part of the Base tutorial, we will continue adding the rest of the form controls to our form. |
07:00 | And this is how our form will look like, when we are done. |
07:06 | Here is an assignment. |
07:08 | Add a second list box for listing 'member names' instead of unfriendly 'member Ids'. |
07:17 | Do not worry about the placement of the list box now. Just draw it to the left of the Member name label. |
07:27 | We will relocate it appropriately across the 'Member Name' label in our next tutorial. |
07:34 | This brings us to the end of this tutorial on List Box Control in LibreOffice Base. |
07:40 | To summarize, we learned how to: Add a 'List Box form control' to a form. |
07:47 | 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. |
07:58 | This project is coordinated by http://spoken-tutorial.org. |
08:04 | More information on the same is available at the following link. |
08:08 | This script has been contributed by Priya Suresh, DesiCrew solutions. And this is Soundharya, DesiCrew solutions, signing off.
Thanks for joining. |