Difference between revisions of "LibreOffice-Suite-Base/C3/Create-Subforms/English-timed"
From Script | Spoken-Tutorial
Sandhya.np14 (Talk | contribs) |
|||
Line 4: | Line 4: | ||
|- | |- | ||
|00:00 | |00:00 | ||
− | |Welcome to the Spoken tutorial on LibreOffice Base. | + | |Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''. |
|- | |- | ||
Line 12: | Line 12: | ||
|- | |- | ||
|00:07 | |00:07 | ||
− | | | + | |create a '''Subform'''. |
|- | |- | ||
|00:09 | |00:09 | ||
− | |For this, let us continue with our familiar Library database example. | + | |For this, let us continue with our familiar '''Library''' database example. |
|- | |- | ||
Line 24: | Line 24: | ||
|- | |- | ||
|00:18 | |00:18 | ||
− | |How can we list all the members of the library? | + | |* How can we list all the members of the library? |
|- | |- | ||
|00:22 | |00:22 | ||
− | |And for each member, how can we see only those books that have not yet been returned by that member? | + | |* And for each member, how can we see only those books that have not yet been returned by that member? |
|- | |- | ||
|00:31 | |00:31 | ||
− | |One way is to create a form listing all the members in the library | + | |One way is to create a '''form''' listing all the members in the library. |
|- | |- | ||
|00:36 | |00:36 | ||
− | |And then creating a subform below it, to list those books that have not yet been returned by the member. | + | |And then creating a '''subform''' below it, to list those books that have not yet been returned by the member. |
|- | |- | ||
|00:44 | |00:44 | ||
− | |Once we design this form, we will be able to update the form. | + | |Once we design this form, we will be able to update the '''form'''. |
|- | |- | ||
Line 52: | Line 52: | ||
|- | |- | ||
|01:01 | |01:01 | ||
− | |Notice it also shows a subform at the bottom. | + | |Notice, it also shows a '''subform''' at the bottom. |
|- | |- | ||
|01:06 | |01:06 | ||
− | | | + | |Let's open our '''Library''' database. |
|- | |- | ||
Line 64: | Line 64: | ||
|- | |- | ||
|01:17 | |01:17 | ||
− | |Now we will use this query and the | + | |Now we will use this '''query''' and the '''Members''' table as the base for creating our new form. |
|- | |- | ||
|01:25 | |01:25 | ||
− | |Let us first copy this query | + | |Let us first copy this query by right-clicking on the query name and then let us click on '''Paste'''. |
|- | |- | ||
|01:34 | |01:34 | ||
− | |In the | + | |In the pop-up window for query name, let us type in a new name: ‘Books Not Returned’ |
|- | |- | ||
|01:42 | |01:42 | ||
− | |Let us now open the ‘Books Not Returned’ query in edit mode. | + | |Let us now open the ‘Books Not Returned’ query in '''edit''' mode. |
|- | |- | ||
|01:48 | |01:48 | ||
− | |In the Query Design window, let us add a criterion to show only those books that are not checked in. | + | |In the '''Query Design''' window, let us add a criterion to show only those books that are not checked-in. |
|- | |- | ||
|01:58 | |01:58 | ||
− | |For this, let us type ‘equals 0’ in the Criterion column under CheckedIn | + | |For this, let us type ‘equals 0’ in the '''Criterion''' column under '''CheckedIn'''. |
|- | |- | ||
|02:06 | |02:06 | ||
− | |And press Enter. | + | |And press '''Enter'''. |
|- | |- | ||
|02:09 | |02:09 | ||
− | |Let us now save the query and close the window. | + | |Let us now '''save''' the query and close the window. |
|- | |- | ||
|02:13 | |02:13 | ||
− | |In the main Base window, let us click on the Forms icon on the left panel | + | |In the main '''Base''' window, let us click on the '''Forms''' icon on the left panel. |
|- | |- | ||
Line 104: | Line 104: | ||
|- | |- | ||
|02:25 | |02:25 | ||
− | |Now we see the familiar Form wizard. | + | |Now we see the familiar '''Form''' wizard. |
|- | |- | ||
|02:28 | |02:28 | ||
− | |Let us go through the 8 steps on the left to create our form. | + | |Let us go through the 8 steps on the left to create our '''form'''. |
|- | |- | ||
|02:34 | |02:34 | ||
− | |In step 1 | + | |In '''step 1. field selection''', let us choose '''Table: Members'''. |
|- | |- | ||
Line 120: | Line 120: | ||
|- | |- | ||
|02:46 | |02:46 | ||
− | |And let us click on the Next button. | + | |And let us click on the '''Next''' button. |
|- | |- | ||
|02:49 | |02:49 | ||
− | |We are in Step 2. Setup a subform. | + | |We are in '''Step 2. Setup a subform.''' |
|- | |- | ||
|02:54 | |02:54 | ||
− | |So here, let us check the ‘Add subform’ | + | |So here, let us check the ‘Add subform’ check-box |
|- | |- | ||
|02:59 | |02:59 | ||
− | | | + | |and click on the option: ‘Subform based on manual selection of fields’. |
|- | |- | ||
|03:07 | |03:07 | ||
− | |Let us go to Step 3. Add subform fields. | + | |Let us go to '''Step 3. Add subform fields'''. |
|- | |- | ||
|03:11 | |03:11 | ||
− | |Here we will call our new query which we designed a few minutes ago. | + | |Here we will call our new '''query''' which we designed a few minutes ago. |
|- | |- | ||
|03:18 | |03:18 | ||
− | |So let us choose ‘Query: Books Not Returned’ from the Tables or Queries | + | |So, let us choose ‘Query: Books Not Returned’ from the '''Tables or Queries''' drop-down. |
|- | |- | ||
Line 152: | Line 152: | ||
|- | |- | ||
|03:37 | |03:37 | ||
− | |Click on Next. | + | |Click on '''Next'''. |
|- | |- | ||
|03:39 | |03:39 | ||
− | |Step 4. Get joined fields. | + | |'''Step 4. Get joined fields'''. |
|- | |- | ||
|03:43 | |03:43 | ||
− | |Here we will choose the MemberId field from the top two drop downs, as this is the only relating field. | + | |Here we will choose the '''MemberId''' field from the top two drop-downs, as this is the only relating field. |
|- | |- | ||
|03:53 | |03:53 | ||
− | |And click on the Next button. | + | |And click on the '''Next''' button. |
|- | |- | ||
|03:57 | |03:57 | ||
− | |Step 5. Arrange Controls | + | |'''Step 5. Arrange Controls'''. |
|- | |- | ||
|04:00 | |04:00 | ||
− | |Here we will choose the third option | + | |Here, we will choose the third option- '''Data sheet''', for both the '''form''' and the '''subform'''. |
|- | |- | ||
|04:08 | |04:08 | ||
− | |And click on the Next button. | + | |And click on the '''Next''' button. |
|- | |- | ||
|04:11 | |04:11 | ||
− | |Step 6. Set data entry. | + | |'''Step 6. Set data entry'''. |
|- | |- | ||
|04:15 | |04:15 | ||
− | |Here, we will leave the options as they are and click on Next. | + | |Here, we will leave the options as they are and click on '''Next'''. |
|- | |- | ||
|04:22 | |04:22 | ||
− | |Step 7. Apply Styles. | + | |'''Step 7. Apply Styles'''. |
|- | |- | ||
Line 200: | Line 200: | ||
|- | |- | ||
|04:32 | |04:32 | ||
− | |Step 8. Set Name. | + | |'''Step 8. Set Name'''. |
|- | |- | ||
|04:36 | |04:36 | ||
− | |Here let us give a descriptive name to our form: ‘Members Who Need to Return Books’ | + | |Here, let us give a descriptive name to our form: ‘Members Who Need to Return Books’. |
|- | |- | ||
|04:45 | |04:45 | ||
− | |And let us click on the Modify form option, as we are going to do some more changes. | + | |And let us click on the '''Modify form''' option, as we are going to do some more changes. |
|- | |- | ||
|04:53 | |04:53 | ||
− | |Now | + | |Now let's click on the '''Finish''' button. |
|- | |- | ||
|04:56 | |04:56 | ||
− | |In the | + | |In the '''Form Design''' window, notice that there are two tabular data sheet areas. |
|- | |- | ||
|05:04 | |05:04 | ||
− | |The one above is called the form and the one below is called the subform. | + | |The one above is called the '''form''' and the one below is called the '''subform'''. |
|- | |- | ||
Line 228: | Line 228: | ||
|- | |- | ||
|05:15 | |05:15 | ||
− | |We will click on the Label icon in the Form Controls toolbar at the top | + | |We will click on the '''Label''' icon in the '''Form Controls''' toolbar at the top and draw it on the form. |
|- | |- | ||
Line 240: | Line 240: | ||
|- | |- | ||
|05:37 | |05:37 | ||
− | | | + | |and change the font style to '''Arial, Bold''' and '''Size 12'''. <pause> |
|- | |- | ||
|05:47 | |05:47 | ||
− | |Similarly, let us add a second label above the subform as shown on the screen | + | |Similarly, let us add a second label above the '''subform''' as shown on the screen |
|- | |- | ||
|05:55 | |05:55 | ||
− | | | + | |and call it ‘List of Books to be returned by the member’. <pause> |
|- | |- | ||
|06:00 | |06:00 | ||
− | |Next let us shorten the form’s length as shown on the screen | + | |Next, let us shorten the form’s length as shown on the screen. |
|- | |- | ||
|06:07 | |06:07 | ||
− | |And then let us increase the length of the Name field in the form. <pause> | + | |And then let us increase the length of the '''Name''' field in the '''form'''. <pause> |
|- | |- | ||
|06:13 | |06:13 | ||
− | |Similarly, let us lengthen the | + | |Similarly, let us lengthen the '''Book title''' field in the '''subform'''. |
<pause> | <pause> | ||
|- | |- | ||
|06:21 | |06:21 | ||
− | |Let us change the fonts here to Arial, Bold and Size 8. | + | |Let us change the fonts here to '''Arial, Bold''' and '''Size 8'''. |
|- | |- | ||
|06:28 | |06:28 | ||
− | |And change the background color to white for the form and Blue 8 for the subform. <pause> | + | |And change the background color to white for the '''form''' and Blue 8 for the '''subform'''. <pause> |
|- | |- | ||
|06:37 | |06:37 | ||
− | |Next, let us hide the MemberId column by right clicking on it and choosing the Hide column option. | + | |Next, let us hide the '''MemberId''' column by right-clicking on it and choosing the '''Hide''' column option. |
|- | |- | ||
|06:47 | |06:47 | ||
− | |Okay, we are done. So let us save the form design and test it. | + | |Okay, we are done. So, let us '''save''' the form design and test it. |
|- | |- | ||
|06:54 | |06:54 | ||
− | |In the main Base window, let us open the ‘Members Who Need to Return Books’ form by double clicking on it. | + | |In the main '''Base''' window, let us open the ‘Members Who Need to Return Books’ form by double-clicking on it. |
|- | |- | ||
|07:03 | |07:03 | ||
− | |There is the form. | + | |There is the '''form'''. |
|- | |- | ||
|07:05 | |07:05 | ||
− | |Let us browse through the members | + | |Let us browse through the members by either using the up or down arrow keys, |
|- | |- | ||
|07:12 | |07:12 | ||
− | | | + | |or by simply clicking on the various member names. |
|- | |- | ||
Line 304: | Line 304: | ||
|- | |- | ||
|07:27 | |07:27 | ||
− | |and let us type in ‘12/7/11’ in the actual return date field and check the CheckedIn field | + | |and let us type in ‘12/7/11’ in the actual return date field and check the '''CheckedIn''' field |
|- | |- | ||
|07:41 | |07:41 | ||
− | |and press Enter. | + | |and press '''Enter'''. |
|- | |- | ||
|07:45 | |07:45 | ||
− | |Let us now refresh the form by clicking on the Refresh icon in the Form Navigation toolbar at the bottom. | + | |Let us now refresh the form by clicking on the '''Refresh''' icon in the '''Form Navigation''' toolbar at the bottom. |
|- | |- | ||
|07:56 | |07:56 | ||
− | |Notice that the record we just edited is no longer listed here | + | |Notice that the '''record''' we just edited is no longer listed here |
|- | |- | ||
|08:02 | |08:02 | ||
− | |which means the book has been returned or checked in. | + | |which means the book has been returned or checked-in. |
|- | |- | ||
|08:07 | |08:07 | ||
− | |So there is our form with a subform. | + | |So, there is our form with a subform. |
|- | |- | ||
|08:11 | |08:11 | ||
− | |This brings us to the end of this tutorial on Subforms in LibreOffice Base | + | |This brings us to the end of this tutorial on '''Subforms in LibreOffice Base'''. |
|- | |- | ||
Line 336: | Line 336: | ||
|- | |- | ||
|08:20 | |08:20 | ||
− | | | + | |create a Subform. |
|- | |- | ||
|08:23 | |08:23 | ||
− | |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. This project is coordinated by http://spoken-tutorial.org. More information on the same is available at the following link. |
|- | |- | ||
|08:44 | |08:44 | ||
− | |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 | + | |
|- | |- |
Revision as of 22:19, 29 September 2015
Time | Narration |
00:00 | Welcome to the Spoken tutorial on LibreOffice Base. |
00:04 | In this tutorial, we will learn how to |
00:07 | create a Subform. |
00:09 | For this, let us continue with our familiar Library database example. |
00:15 | And we will consider the following case: |
00:18 | * How can we list all the members of the library? |
00:22 | * And for each member, how can we see only those books that have not yet been returned by that member? |
00:31 | One way is to create a form listing all the members in the library. |
00:36 | And then creating a subform below it, to list those books that have not yet been returned by the member. |
00:44 | Once we design this form, we will be able to update the form. |
00:49 | For example, when a member returns a book, we can update this information. |
00:55 | And, here is a sample screenshot of the form we will design. |
01:01 | Notice, it also shows a subform at the bottom. |
01:06 | Let's open our Library database. |
01:09 | In our previous tutorials, we created the ‘History of Books Issued to Members’ query. |
01:17 | Now we will use this query and the Members table as the base for creating our new form. |
01:25 | Let us first copy this query by right-clicking on the query name and then let us click on Paste. |
01:34 | In the pop-up window for query name, let us type in a new name: ‘Books Not Returned’ |
01:42 | Let us now open the ‘Books Not Returned’ query in edit mode. |
01:48 | In the Query Design window, let us add a criterion to show only those books that are not checked-in. |
01:58 | For this, let us type ‘equals 0’ in the Criterion column under CheckedIn. |
02:06 | And press Enter. |
02:09 | Let us now save the query and close the window. |
02:13 | In the main Base window, let us click on the Forms icon on the left panel. |
02:20 | And then click on the ‘Use Wizard to create Form’ option. |
02:25 | Now we see the familiar Form wizard. |
02:28 | Let us go through the 8 steps on the left to create our form. |
02:34 | In step 1. field selection, let us choose Table: Members. |
02:40 | Then let us move all the fields to the right side. |
02:46 | And let us click on the Next button. |
02:49 | We are in Step 2. Setup a subform. |
02:54 | So here, let us check the ‘Add subform’ check-box |
02:59 | and click on the option: ‘Subform based on manual selection of fields’. |
03:07 | Let us go to Step 3. Add subform fields. |
03:11 | Here we will call our new query which we designed a few minutes ago. |
03:18 | So, let us choose ‘Query: Books Not Returned’ from the Tables or Queries drop-down. |
03:26 | And we will move selected fields from the available list to the right side as shown on the screen. <pause> |
03:37 | Click on Next. |
03:39 | Step 4. Get joined fields. |
03:43 | Here we will choose the MemberId field from the top two drop-downs, as this is the only relating field. |
03:53 | And click on the Next button. |
03:57 | Step 5. Arrange Controls. |
04:00 | Here, we will choose the third option- Data sheet, for both the form and the subform. |
04:08 | And click on the Next button. |
04:11 | Step 6. Set data entry. |
04:15 | Here, we will leave the options as they are and click on Next. |
04:22 | Step 7. Apply Styles. |
04:26 | Let us choose Grey as the form background. |
04:29 | And go to the final step. |
04:32 | Step 8. Set Name. |
04:36 | Here, let us give a descriptive name to our form: ‘Members Who Need to Return Books’. |
04:45 | And let us click on the Modify form option, as we are going to do some more changes. |
04:53 | Now let's click on the Finish button. |
04:56 | In the Form Design window, notice that there are two tabular data sheet areas. |
05:04 | The one above is called the form and the one below is called the subform. |
05:11 | Now, let us add a label above the form. |
05:15 | We will click on the Label icon in the Form Controls toolbar at the top and draw it on the form. |
05:25 | Double clicking on the label, brings up its properties. |
05:31 | Here we will type ‘Members of the Library’ against label |
05:37 | and change the font style to Arial, Bold and Size 12. <pause> |
05:47 | Similarly, let us add a second label above the subform as shown on the screen |
05:55 | and call it ‘List of Books to be returned by the member’. <pause> |
06:00 | Next, let us shorten the form’s length as shown on the screen. |
06:07 | And then let us increase the length of the Name field in the form. <pause> |
06:13 | Similarly, let us lengthen the Book title field in the subform.
<pause> |
06:21 | Let us change the fonts here to Arial, Bold and Size 8. |
06:28 | And change the background color to white for the form and Blue 8 for the subform. <pause> |
06:37 | Next, let us hide the MemberId column by right-clicking on it and choosing the Hide column option. |
06:47 | Okay, we are done. So, let us save the form design and test it. |
06:54 | In the main Base window, let us open the ‘Members Who Need to Return Books’ form by double-clicking on it. |
07:03 | There is the form. |
07:05 | Let us browse through the members by either using the up or down arrow keys, |
07:12 | or by simply clicking on the various member names. |
07:16 | Notice that the subform below refreshes and shows books to be returned. |
07:23 | In the subform, let us choose any record |
07:27 | and let us type in ‘12/7/11’ in the actual return date field and check the CheckedIn field |
07:41 | and press Enter. |
07:45 | Let us now refresh the form by clicking on the Refresh icon in the Form Navigation toolbar at the bottom. |
07:56 | Notice that the record we just edited is no longer listed here |
08:02 | which means the book has been returned or checked-in. |
08:07 | So, there is our form with a subform. |
08:11 | This brings us to the end of this tutorial on Subforms in LibreOffice Base. |
08:17 | To summarize, we learned how to: |
08:20 | create a Subform. |
08:23 | 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. This project is coordinated by http://spoken-tutorial.org. More information on the same is available at the following link. |
08:44 | This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off.
Thanks for joining. |