Difference between revisions of "LibreOffice-Suite-Base/C3/Create-Subforms/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:04 |In this tutorial, we will learn how to |- |00:07 |Create a Subform…') |
|||
Line 1: | Line 1: | ||
{| border=1 | {| border=1 | ||
− | + | |'''Time''' | |
− | + | |'''Narration''' | |
|- | |- | ||
|00:00 | |00:00 |
Revision as of 15:06, 9 July 2014
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 | Lets 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 popup 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’ checkbox, |
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 dropdown. |
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 lets 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 co-ordinated 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.
|