LibreOffice-Suite-Base/C3/Create-Subforms/English-timed
From Script | Spoken-Tutorial
| 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. |
| 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 ActualReturnDate 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. |
