Difference between revisions of "LibreOffice-Suite-Base/C2/Introduction/English-timed"

||Welcome to the Spoken tutorial on LibreOffice Base.

||In this tutorial, we will learn about What is LibreOffice Base?

||LibreOffice Base is the database front-end of the LibreOffice suite.  

||Base is the equivalent of Microsoft Access.  

||Base is free and open source software, free of cost and free to use and distribute.  

||Let us look at the Prerequisites for using Base.

||Following are the System requirements for Microsoft Windows

||Microsoft Windows 2000 (Service Pack 4 or higher), XP, Vista, or Windows 7;Pentium-compatible PC Up to 1.5 Gb available hard disk space;

||For Ubuntu Linux, here are the System requirements

||Linux kernel version 2.6.18 or higher;Pentium-compatible PC  

||For both Windows and Linux installation we require 256 Mb RAM (recommended 512 Mb)

||For complete system requirements, visit the libreoffice website.

||You will also need to install Java Runtime Environment which you can download at the following link.

||Click on the Red button in the centre that says 'Free Java Download'.

||Once the file is downloaded, double click on it and follow the instructions to install.

||Let us now look at LibreOffice Base installation:

||If you have already installed LibreOffice Suite with the complete installation option,

||Then, you can access LibreOffice Base, by clicking on the Start menu at the bottom left of your screen.  

||Click on All Programs, and then click on LibreOffice Suite.

||you can install Base by visiting the official website and clicking on the green area that says  'Download LibreOffice'.  

||Detailed instructions are available in the first tutorial of LibreOffice Suite.

||Remember, when installing, use the 'Complete' option to install 'Base'.

||What can you do with LibreOffice Base?

||With Base,you can store organized data

||perform data entries and view data using forms

||03:08

||retrieve information using queries and

||design and generate nice, printer-ready reports.  

||Base helps you to manage databases.  

||As you may know, a database is a group of data, forms, queries and reports.

||For example, Base can be used to manage Customer Information databases,  

||track sales orders and invoices, maintain student grade databases or build a library database.

||A database has data stored and organized into tables.  

||Tables have individual pieces of data stored in rows and columns.  

||Such a database is also called a relational database where the tables have relationships with each other using the columns.

||Let us consider a simple database for a Library.  

||A library can be a collection of Books.

||And books can be issued to members of the library.  

||A book can have a title, an author, a publisher, year of publication and a price.  

||These are called characteristics or attributes.  

||Similarly, a Library member has a Name, phone number and an address.  

||And the library issues books to its members only.  

||Now let us see, how we can store this data as individual tables of rows and columns.  

|Information about each book can be stored in a Books table,  

||with its attributes becoming the columns: book title, author, publisher, year of publication and price.  

||To distinguish each book, let us also add a unique identifier column called BookId.  

||Similarly, a Members table can have columns like Name and Phone,

||And a Member Id to uniquely identify or distinguish each member. <pause>

||And we can track the books issued to members in a third table called BooksIssued.  

||This table will track the book issued, the member, date of issue, date of return, actual date of return, whether checked in or not.  

||We can establish relationships among these tables, to interlink the data in them.  

||Now this helps us to manage 'relational databases'.

||For advanced topics on relational databases, refer to our other tutorials by visiting the website Spoken tutorial.org  

||Okay, let us now get started with our first Base database called “Library”!

||To create a new Database, let us first open the Base program.  

||Then, click on the Windows Start menu at the bottom left of the screen, then click on All Programs, then LibreOffice Suite,and LibreOffice Base.

|A pop-up window titled Database Wizard opens.  

||Click on the Next button to create a new database.

||Click on the Finish button in the following window.  

||This opens a Save As window.  

||Since we are building a Library database, we will type "Library" in the File Name text box.

||And then click on the Save button.

||Now we are in.  

||To create a new table, click the Tables icon in the Database list on the left.  

||Click on the 'Create Table in Design View' in the Tasks list on the right.This opens another window.

||Here, type 'BookId' as the first column under Field Name.  

||Use the Tab key to move to the Field Type column.

||Since the BookId will be a different number for each book, select Integer as the Field Type from the dropdown list.

||Change the Field Properties in the bottom section.

||Change AutoValue from No to Yes.  

||In other words this field is also called the Primary Key.  

||Notice the yellow key symbol to the left of the BookId field.

||Let us see how we can choose Field Types for field names.  

||Field types can be text, integer, numeric, decimal or date.  

||Use text, for fields that have general information, for example, name, title, address.  

||Use Integer, numeric, decimal for fields that may contain only numbers,

|For example use numeric for a field with price information, Integer for years.

||Let us create the rest of the fields now.

|Title, Field type Text, Author  

||Field type Text, Published Year  

||Field type Integer

||Publisher  

||Field type Text

||Price  

||Field type Numeric

||Change the Length to 5 and Decimal places to 2.  

||Click the Format example button.  

||This opens the Field Format window.  

||Select Currency from the Category List and  INR from the Format List.  

|Click on the OK button. Now we have created all the columns for the Books table.

||Let us now save the table.  

||Click on the Save icon that is below the File menu.   

||Type 'Books' in the table name text box  

||Note that it is saved in the same location as the database ‘Library’ as tables are a part of a database.

||and click on the ok button.  

||In the next tutorial, we will add data to the Books table and create the Members and BooksIssued tables.

||This brings us to the end of this tutorial  

||What can you do with Base? Relational Database basics

||Create a new database, Create a table

||The next tutorial in this series is tables and relationships.

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

||This project is co-ordinated by Spoken Tutorial.org http://spoken-tutorial.org.  

||This tutorial has been contributed by ...............................(Name of the translator and narrator)

 

And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching.   

 

Thanks for joining