Difference between revisions of "LibreOffice-Suite-Base/C4/Access-data-sources/English-timed"

||Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''.

||In this tutorial, we will learn how to:

||Register '.odb' databases

||And Use Data Sources in '''Writer'''.

||Let us see how we can access other '''Data Sources''' in '''Base'''.

||'''Libre Office''' allows other data sources to be accessed apart from '''Base Databases'''.  

||It also allows to '''link''' them into other '''Libre Office documents'''.  

||For example, we can access a '''spreadsheet''' or a simple text document from inside LibreOffice Base.

||And then link them into a '''LibreOffice Writer''' document.

||As an example, let us create an example spreadsheet using '''LibreOffice Calc.'''

||Click on '''Start Menu >> All Programs''' and open the '''LibreOffice Suite menu'''.  

||Or, if LibreOffice is already open then we can click on '''File, New''' and then '''Spreadsheet''' to open a new spreadsheet.

||Now, in the spreadsheet, let us type in some sample data as shown in the image. <pause>

||And '''save''' this spreadsheet as '''‘LibraryMembers’''' in a directory location.  

||Now, let us remember the location as we will need to use this file later in our example.

||And we will close the '''Calc''' window.

||Okay, now let us see how we can access this spreadsheet from 'LibreOffice Base'.

||To do this, open '''Base''' either from '''Windows''' '''Start''' menu   

||or if LibreOffice is already open then we will click on '''File, New''' and then '''Database'''.

||Now, this opens the '''Database Wizard'''.

||Here, we will click on the '''‘Connect to an existing database’'''

||then click on the drop-down.  

||Notice the various database sources in this list that '''Base''' can access.

||And we will click on '''Spreadsheet''' here.

||And the '''Next''' button.

||Now, using the browse button, let us locate the spreadsheet from where we saved it earlier.

||Let us click on the '''Next''' button.

||and open it for editing.

||And, click on the '''Finish''' button.

||Now, let us provide a database name here. Let us type in "LibraryMembers".

||Notice the '''Save as type''': It says '''ODF Database''' which is '.odb' in our case.

||And '''Save''' it in the same location as the spreadsheet.  

||There we have registered the spreadsheet as a data source in '''Base'''.

||Here, let us click on the '''Tables''' icon in the left panel.  

||Notice the tables ‘Sheet1’, Sheet2, and 'Sheet3'.

||Let us double-click on '''Sheet1''' to open it and here is the data from the spreadsheet.

||We can only view data or create queries and reports based on the existing data from here.

||So, changes have to be made directly to the Spreadsheet itself.

||Registering '.odb' databases.

||Now, there are other programs such as '''OpenOffice.org''' that can produce '.odb' databases.  

||To use these inside LibreOffice Base, we will first need to register them in '''Base'''.

||To register any '.odb' database, we will need to open Base and

||choose '''Tools, Options, LibreOffice Base''' and '''Databases'''.

||Under '''Registered Databases''', click '''New'''.

||Browse to where the database is located and ensure the registered name is correct

||and Click on the '''OK''' button.

||Now, we can use it in '''LibreOffice Writer''' or '''Calc'''.

||For example, let us see how we can view it inside 'LibreOffice Writer'.  

||First, let us open '''Writer''' from the 'Base' window.

||For this, let us click on '''File, New''' and then '''Text Document'''.

||Now we are in the '''Writer''' window.

||To view the available data sources, we will click on the '''View''' menu at the top and click on '''Data Sources'''.

||Alternately, we can press the '''F4''' key.

||Now we see a list of registered databases at the top left, including "LibraryMembers" which we created just now.

||To view the database, we will expand it by clicking on the plus symbol on the left of the database name

||and we will expand Tables.

||Let us click on '''Sheet 1'''.

||So, that’s our data at the top right of the Writer window.

||Now we will see how we can use this data in our example '''Writer document'''.

||Okay, here if we want to use all of the data from the table above then first we will select all the records there.

||For this, let us click on the gray cell to the left of the first column in the first record.

||Then, while pressing '''Shift''' key, we will click on the gray cell to the left of the first column in the last record.

||Notice that all the data gets highlighted.

||Next, we see a pop-up window titled '''Insert Database columns'''.

||So here, we will click on the '''Table''' option at the top

||and then click on the double-arrow button to move all the fields from the left to the right list.

||For now, we will simply click on the '''OK''' button.  

||Next, let us see how we can insert individual fields.

||Let us go to the top of the Writer document and press the '''Enter''' key twice. Again, go to the top left.

||Here, let us type in "Member Name" colon.

||And then click on the '''Name''' column in the data sources area at the top right.

||And we will press the '''Tab''' key and type in "Phone number" colon.

||We will click and drag the '''Phone''' column from the top and drop it next to our text.

||And then, we will click on the '''Data to Fields''' icon.

||This can be found in the '''Table Data''' toolbar at the top, below the '''Formatting toolbar'''.

||To bring in another record, we just have to highlight a different record and use the '''Data to Fields''' icon again.

||So, there we learnt how to use data sources inside LibreOffice documents.

||This brings us to the end of this tutorial on '''Accessing other Data Sources in LibreOffice Base'''.

||And Use Data Sources in Writer.

||'''Spoken Tutorial''' project is a part of the '''Talk to a Teacher''' project,  

||This project is coordinated by http://spoken-tutorial.org.  

||This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off.  

Thanks for joining.