LibreOffice-Suite-Base/C2/Enter-and-update-data-in-a-form/English-timed

From Script | Spoken-Tutorial
Revision as of 12:48, 23 March 2017 by PoojaMoolya (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Time Narration
00:02 Welcome to the Spoken tutorial on LibreOffice Base.
00:06 In this tutorial, we will learn how to
00:09 enter and update data in a form.
00:12 In the last tutorial, we learnt how to add form controls to a form.
00:19 In this tutorial, let us learn how to enter data and update data using a form.
00:27 Before doing this, let us make just three more modifications to our form design.
00:36 Let us first invoke the LibreOffice Base program, if it's not already open
00:51 and open our 'Library database'
00:54 by clicking Open under File menu.
00:58 Now we are in the Library database.
01:02 And, we will open the 'Books Issued to Members' form.
01:07 To do this, let us click on the Forms icon on the left panel and then right-click on the 'Books Issued to Members' form on the right panel
01:20 and then click on Edit.
01:24 We are now in the Form Design window.
01:28 Here, let us first resize the form, so it looks compact and less imposing.
01:36 To do this, we will decrease the height and length of our form window.
01:43 We will do this by clicking, dragging and dropping on the top and sides of the form window.
01:51 Next, let us change the font of the heading on our form.
01:57 Let us change the font to Arial Black and Size 12 from the Formatting toolbar at the top.
02:12 Finally, let us look at the Tab Order of the form controls.
02:19 This helps us to use keyboard tab keys to navigate across the form controls in a particular order.
02:29 Say, for example, from the top to the bottom.
02:33 This is called the tab order.
02:37 Now, Base automatically sets the tab order of the form controls from top to bottom in a form.
02:47 But since we removed a couple of text boxes and added two new list boxes and four buttons, we may have mixed up the tab order.
03:00 So, we will set it right now.
03:05 In the Form Design toolbar, usually found at the bottom of the window, we will browse through the icons
03:16 and find the icon with the tool tip that says 'Activation order'.
03:25 Let us click on this icon.
03:29 Now, we see a small pop-up window with 'Tab Order' as its title.
03:38 To order these form controls, we can either click, drag and drop the items.
03:46 Or we can use the 'Move up' or 'Move down' buttons.
03:52 So, let us set the tab order as shown in the image here. <pause>
04:04 We are done. So, let us click on the OK button to save these changes.
04:12 Okay, now let us save our form by pressing Control S
04:19 and then we will close the form window.
04:24 And finally, we are done with our Form design.
04:29 Now, let us test our form.
04:33 In the main Base window, let us open the 'Books Issued to Members' form by double-clicking on it.
04:42 Now, the form is open in data entry mode.
04:47 Notice the heading that says 'Form to track Books issued to Members'.
04:54 And here, we see book titles and member names instead of 'bookIds' and 'memberIds'.
05:03 Also, this is the first record of the BooksIssued table; we see that 'An Autobiography' is highlighted against the Book title.
05:15 And 'Nisha Sharma' highlighted against the Member name.
05:21 And we also see the rest of the fields.
05:25 Now we can traverse through all the records by using the Form Navigation toolbar icons at the bottom.
05:45 Let us go to the second record now.
05:49 Here we see that the member Jacob Robin has borrowed the book 'Macbeth' and let us assume now that he is returning the book.
06:01 So, let us update this information into this record.
06:07 For this, we will type in the actual return date, for example- 7/7/11
06:17 and check the Checked In field.
06:21 To save this information, we will press the Save Record button that we put there.
06:30 Notice that the button is greyed out, meaning now it is disabled from use.
06:38 But if we edit this record again then the button gets enabled again.
06:45 Okay, now let us test the Undo changes button.
06:50 For this, let us edit the record by clicking on the book title 'Conquest of Self' and then typing in 5/7/11 in the Actual Return Date field.
07:06 Notice that both the Save record button and the Undo changes button are enabled for use.
07:15 Now, let us click on the Undo Changes button and see what happens.
07:22 The changes we did last, have been undone. Notice that 'Macbeth' is highlighted instead of 'Conquest of Self' and the Actual return date is 7/7/11.
07:37 Good, let us now click on the Delete Record button, meaning- we are trying to delete this second record.
07:47 Base is cautious about deletes, so it asks for a confirmation by alerting us.
07:55 For now, let us go ahead and click on the Yes button.
08:02 We can see that the record is indeed deleted; gone from the screen and in its place we see the next record.
08:13 Finally, let us add a new record by clicking on the last button on the form which is New record.
08:22 Let us type some values.
08:26 Since the IssueId is an auto generating field, we will skip it.
08:33 And here, let us add data as shown in the image.
08:42 To save the entries, click on the Save Record button.
08:47 There we go. We have tested the form by entering and updating data.
08:54 Here is an assignment- Design a form to show the member's information.
09:00 Make the form look compact.
09:03 Make the font bold.
09:07 Add Save and New record buttons.
09:10 This brings us to the end of this tutorial on Form Data in LibreOffice Base.
09:17 To summarize, we learned how to:
09:20 enter and update data in a form.
09: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.
09:34 This project is coordinated by http://spoken-tutorial.org. More information on the same is available at the following link.
09: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