LibreOffice-Suite-Base/C2/Build-a-complex-form-with-form-controls/English-timed

Time	Narration
00:00	Welcome to the Spoken tutorial on LibreOffice Base.
00:04	In this tutorial on Complex Forms, we will learn about:
00:08	Building a complex form. And modifying the form.
00:13	In the previous tutorial, we learnt how to enter data using forms and how to modify a form using LibreOffice Base.
00:22	In this tutorial, let us learn about building a complex form.
00:28	Let us first invoke the LibreOffice Base program, if it's not already open
00:44	and open our Library database.
00:47	If Base is already open, then we can open the "Library" database from here by clicking Open under File menu
00:57	or by clicking Recent Documents under File menu.
01:03	Let us design a new form that will help us track the books, issued to the Library members.
01:12	Let us see how we can design this form as shown in the screen image.
01:18	Let us go to the LibreOffice Base main window and click on the Forms icon in the Database list on the left panel
01:29	and then click on 'Use Wizard to create form'.
01:34	This opens the Forms window and the now familiar wizard on top.
01:41	We have already gone through this wizard in detail, so we will proceed quickly with it now.
01:49	In Step 1. Field Selection, let us choose 'Tables:BooksIssued' from the drop-down box, beneath the label that says 'Tables or queries'.
02:02	Let us move all the fields from the left to the right by using the double-arrow button. <pause>
02:10	Let's click on Next.
02:12	This is Step 2, but we will skip this step for now and click on the Next button at the bottom.
02:20	We are in step 5 now. Let us choose the first arrangement 'Columnar – Labels Left' and click on the Next button.
02:30	Let us skip 'Step 6' also by clicking on the Next button.
02:36	'Step 7.' Let us choose Ice blue and click on the Next button.
02:42	In 'Step 8', let's name the form as 'Books Issued to Members' <pause>
02:53	and click on the 'Modify the form' option.
02:57	Next, click on the Finish button.
03:00	Notice that the wizard pop-up window is gone and we are looking at the Form Design window.
03:07	Here, we are going to make some modifications before we use the form for data entry.
03:15	Let us first Ungroup all the elements we see on the form.
03:22	We are doing this so that we can edit the properties of individual elements on the form easily.
03:31	To ungroup all the form elements in one shot, we need to first select all the form elements.
03:40	To do this, let us first open up the Form Design toolbar
03:46	by clicking on the View menu at the top, then click on Toolbars and then click on Form Design.
03:56	In this toolbar, let us click once on the mouse pointer icon which is the first and the leftmost icon.
04:05	We will call this as the Select icon from now on.
04:11	This is used for selecting form elements by clicking and dragging.
04:18	Now, let us click on the top left of the form and drag it diagonally to the bottom right.
04:26	You will now see a rectangle with alternating black and white lines.
04:32	Let’s make sure, all the form elements are inside this rectangle.
04:38	We will use this way repeatedly to select groups of form elements.
04:46	Now we see that all these elements are encased in small green boxes.
04:53	Now, whatever action we do here, will affect all the elements inside this area uniformly.
05:02	Now, let us move the mouse pointer on any label here.
05:08	Notice that the mouse pointer looks like a plus sign over labels and text-boxes.
05:18	So, let us right-click over a label and click on Group at the bottom and click on 'Ungroup'.
05:28	Let us now type a heading that will sit above all the form elements.
05:35	For this, let us push down the form elements and then centre them within the form.
05:43	So, first let us press the down-arrow key about seven times.
05:50	Then press the right-arrow key about 14 times.
05:57	Notice that this moves all the selected form elements towards the right and the centre of the form.
06:07	Now, let us bring the cursor to where we need to type the heading.
06:14	To do this, let us click on the top left of the form window area
06:21	and press the Enter key twice.
06:26	Then press the Tab key four times and then type 'Form to track Books Issued to Members'.
06:38	Now, as we click on the individual labels and text-boxes, we see that these elements are selected or highlighted individually.
06:52	Okay, next, let us rename the BookId and MemberId labels on the form.
07:00	We can do this by double-clicking on BookId label which opens up the now familiar Properties window.
07:12	Against label, type in "Book Title".
07:18	Now, let us click on the MemberId label on the form.
07:25	Notice that the 'Properties window' has refreshed and again here, we will type in 'Member Name' against 'Label'.
07:34	As we press the Tab key, we will notice the new label changes on the form.
07:43	Next, let us change the font sizes of these elements now.
07:49	Again, let us select all the elements.
07:54	We will use the click, drag and drop method.
07:59	And now, we will double-click on any label which in turn will open the 'Properties' window.
08:08	Let us scroll-down to find Font and click on the square button on its right.
08:18	In the new pop-up window, let us click on Bold and click on size 8,
08:26	and let us click on the OK button.
08:29	Notice that the font has changed to Bold and size 8 across the form now.
08:38	Next, let us move all the form elements to the centre of the window.
08:45	For this, we will select all the elements.
08:49	Now let us click and drag on any label, toward the centre of the Form Design window.
09:00	Now let us save the form
09:03	and close this window. To see how our form looks like now,
09:10	let us go to the Base main window and double-click on the 'Books Issued to Members' form on the right panel.
09:20	This opens the form which is ready for data entry use.
09:26	Now, in this form, we see some sample data.
09:31	And against Book Title and Member Name, we see some numbers
09:37	which are really primary numbers in the Books and Members table, but not very friendly values.
09:46	Would you like to see real names and book titles?
09:50	And, how do we do this?
09:53	One way is to add a form control called List box.
09:59	We will see how to add and use a list box and other form controls in the next tutorial.
10:08	This brings us to the end of this tutorial on Complex Forms in LibreOffice Base.
10:13	To summarize, we learned about: Building a complex form and Modifying the form.
10:20	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.
10:40	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