Difference between revisions of "LibreOffice-Suite-Base/C3/Create-Subforms/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
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
+
|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
|Lets open our Library database.
+
|Let's open our '''Library''' database.
  
 
|-
 
|-
Line 64: Line 64:
 
|-
 
|-
 
|01:17
 
|01:17
|Now we will use this query and the members table as the base for creating our new form.
+
|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, by right clicking on the query name, and then let us click on paste.
+
|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 popup window for query name, let us type in a new name: ‘Books Not Returned’
+
|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, field selection, let us choose ‘Table: Members’
+
|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’ checkbox,
+
|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’.  
+
|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 dropdown.
+
|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, Data sheet for both the form and the subform.
+
|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 lets click on the Finish button.
+
|Now let's click on the '''Finish''' button.
  
 
|-
 
|-
 
|04:56
 
|04:56
|In the form design window, notice that there are two tabular data sheet areas.  
+
|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, and draw it on the form.  
+
|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>
+
|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>  
+
|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 book title field in the subform.
+
|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, by either using the up or down arrow keys,  
+
|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.  
+
|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
+
|create a Subform.
  
 
|-
 
|-
 
|08:23
 
|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.
+
|'''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.

Contributors and Content Editors

Gaurav, Minal, PoojaMoolya, Sandhya.np14