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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
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 32: Line 32:
 
|-
 
|-
 
|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>
+
  
 
|-
 
|-
 
|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 303:
 
|-
 
|-
 
|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 '''ActualReturnDate''' 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 335:
 
|-
 
|-
 
|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
+
  
 
|-
 
|-

Latest revision as of 05:41, 2 March 2020

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.

Contributors and Content Editors

Gaurav, Minal, PoojaMoolya, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Base/C3/Create-Subforms/English-timed&oldid=51218"