1
00:00:00 --> 00:00:03
Welcome to the Spoken tutorial on LibreOffice Base.

2
00:00:04 --> 00:00:13
In this tutorial on Modifying a Form, we will learn how to Enter data in a form, Modify a form

3
00:00:14 --> 00:00:21
In the previous tutorial, we learnt to create a form using LibreOffice Base.

4
00:00:22 --> 00:00:28
We created a simple Books data entry form in our example Library database.

5
00:00:29 --> 00:00:38
Let us see how we can enter data into the Books table, using this form.

6
00:00:39 --> 00:00:47
Let us first invoke the LibreOffice Base program, if it's not already open.

7
00:00:48 --> 00:00:51
And open our Library database.

8
00:00:52 --> 00:01:02
If Base is already open, then we can open the Library database from here by clicking the Open inside the File menu

9
00:01:03 --> 00:01:07
or by clicking the Recent Documents inside the File menu

10
00:01:08 --> 00:01:11
Now we are in the Library Database.

11
00:01:12 --> 00:01:17
Let us click on the Forms icon in the Database list on the left panel.

12
00:01:18 --> 00:01:27
Notice that the 'Books Data entry form' under Forms is highlighted in the centre of this window.

13
00:01:28 --> 00:01:32
Let us right click on this form name and click on Open.

14
00:01:33 --> 00:01:44
Now, we see a new window with a blue background with labels and text boxes corresponding to the fields in the Books table.

15
00:01:45 --> 00:01:55
Let us click on the tab key to go to each field, and as we go to the last, Base opens the next record.

16
00:01:56 --> 00:01:59
This way we can traverse the records.

17
00:02:00 --> 00:02:09
Or we can also use the black triangle icons in the bottom toolbar to navigate among the records.

18
00:02:10 --> 00:02:22
Alternately, to simply go to a particular record, type in the record number in the bottom toolbar and press enter key or the tab key.

19
00:02:23 --> 00:02:28
Let us go to the last record which is the fifth.

20
00:02:29 --> 00:02:33
Now let us add a new record.

21
00:02:34 --> 00:02:45
To do this, click on the New Record icon, that is second right of the Last record icon in the bottom toolbar.

22
00:02:46 --> 00:02:54
Notice that we see empty text boxes and the record number at the bottom says 6.

23
00:02:55 --> 00:03:02
Now we are ready to add a new record, with information about a new book.

24
00:03:03 --> 00:03:16
Let us type in 'Paradise Lost' in the Title text box, and  let us use tab key to navigate to the next field,

25
00:03:17 --> 00:03:22
Let us type in 'John Milton' against author

26
00:03:23 --> 00:03:27
'1975' against PublishYear

27
00:03:28 --> 00:03:30
'Oxford' against Publisher

28
00:03:31 --> 00:03:35
and 200 against price.

29
00:03:36 --> 00:03:44
There, we have just entered a new record into the Books table by using the Books Data Entry Form.

30
00:03:45 --> 00:03:46
We will close this window.

31
00:03:47 --> 00:03:52
We can add more records or data in this way.

32
00:03:53 --> 00:04:01
Let us see if Base has updated the Books table with the last record we entered just now.

33
00:04:02 --> 00:04:11
For this, in the LibreOffice Base main window, let us double click on Books table on the right panel

34
00:04:12 --> 00:04:17
Notice the new record that we entered through the form here.

35
00:04:18 --> 00:04:22
Okay, we will close this window now.

36
00:04:23 --> 00:04:29
Next, let us learn how to make simple modifications to our form.

37
00:04:30 --> 00:04:36
We will click on the Forms icon in the database list on the left panel.

38
00:04:37 --> 00:04:46
And open the 'Books Data Entry form' for modifying, by right - clicking on it and then choosing 'edit'.

39
00:04:47 --> 00:04:50
A familiar window opens now,

40
00:04:51 --> 00:05:02
Except that if you click on the label 'title', you will see several small green boxes enclosing the label and the text box.

41
00:05:03 --> 00:05:07
This means that we are in the form design window

42
00:05:08 --> 00:05:16
And we can modify the look and feel of the form, and its elements as well as its functionalities.

43
00:05:17 --> 00:05:24
For example, we can change the placement and size of the labels and text boxes.

44
00:05:25 --> 00:05:27
These are also called properties.

45
00:05:28 --> 00:05:30
Double-click on the label title.

46
00:05:31 --> 00:05:37
This opens a smaller popup window called Properties.

47
00:05:38 --> 00:05:47
Notice the various elements here.

48
00:05:48 --> 00:06:00
Now let us click on the label 'author', notice that the Properties window refreshes and shows the properties of label Author.

49
00:06:01 --> 00:06:13
So as we click on various elements on the form, we see that the Properties window refreshes to show the selected element's properties.

50
00:06:14 --> 00:06:20
Now, the Properties window title reads as Properties MultiSelection.

51
00:06:21 --> 00:06:33
This is because we see that the author label and its textbox adjacent to it, are encased in one set of green boxes.

52
00:06:34 --> 00:06:43
Base automatically has grouped the labels and corresponding textboxes in the form.
We can ungroup them.

53
00:06:44 --> 00:06:53
Right click on the Title label and then click on 'Group' at the bottom then click on 'Ungroup'.

54
00:06:54 --> 00:07:01
Now we see that the label title and its text box have been ungrouped.

55
00:07:02 --> 00:07:09
In this way, we can modify the properties of individual elements on the form.

56
00:07:10 --> 00:07:15
Next, let us add a tool tip to the title text box.

57
00:07:16 --> 00:07:21
Now let us scroll to the bottom in the Properties window.

58
00:07:22 --> 00:07:31
Notice the label 'Help text' and here, let us type in 'Enter the title of the book here'

59
00:07:32 --> 00:07:45
Now, let us save the form by clicking on the Save icon below the File menu on the top. And we will close this window.

60
00:07:46 --> 00:07:53
Let us now see, how our form looks like after the modification that we made.

61
00:07:54 --> 00:08:02
For this, let us go to the Base main window, click on the Forms icon on the left panel,

62
00:08:03 --> 00:08:09
And double-click on 'Books Data Entry Form' on the right panel.

63
00:08:10 --> 00:08:16
Let us point the mouse over the title label or the text box.

64
00:08:17 --> 00:08:23
Notice that a tooltip appears saying 'Enter the title of the book here'.

65
00:08:24 --> 00:08:30
So now, we have learnt how to make a simple modification to our form.

66
00:08:31 --> 00:08:38
We will see how to make more modifications to a form in the next part of the Base tutorial.

67
00:08:39 --> 00:08:40
Here is an assignment.

68
00:08:41 --> 00:08:45
Create a simple form for the Members table.

69
00:08:46 --> 00:08:51
This brings us to the end of this tutorial on Modifying a Form in LibreOffice Base.

70
00:08:52 --> 00:08:59
To summarize, we learned: how to enter data in a form,how to Modify a form

71
00:09:00 --> 00:09:11
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.

72
00:09:12 --> 00:09:16
This project is co-ordinated by http://spoken-tutorial.org.

73
00:09:17 --> 00:09:21
More information on the same is available at the following link.

74
00:09:22 --> 00:09:27
This Script has been contributed by Priya Suresh, DesuCrew solutions.
And this is Soundharya, desi crew solutions, signing off.
Thanks for joining