LibreOffice-Suite-Base/C2/Introduction/English-timed
From Script | Spoken-Tutorial
| Time | Narration |
| 00:00 | Welcome to the Spoken tutorial on LibreOffice Base. |
| 00:04 | In this tutorial, we will learn about * What is LibreOffice Base? |
| 00:09 | Prerequisites for using Base |
| 00:12 | What can you do with Base? |
| 00:14 | Relational Database basics, Create a new database, Create a table. |
| 00:20 | LibreOffice Base is the database front-end of the LibreOffice suite. |
| 00:26 | Base is the equivalent of Microsoft Access. |
| 00:30 | Base is free and open source software, free of cost and free to use and distribute. |
| 00:37 | Let us look at the prerequisites for using 'Base'. |
| 00:41 | Following are the System requirements for Microsoft Windows: |
| 00:45 | 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. |
| 01:02 | For Ubuntu Linux, here are the System requirements: |
| 01:06 | Linux kernel version 2.6.18 or higher, Pentium-compatible PC. |
| 01:13 | For both, Windows and Linux installation, we require 256 Mb RAM (recommended 512 Mb). |
| 01:24 | For complete system requirements, visit the Libreoffice website. |
| 01:30 | You will also need to install Java Runtime Environment which you can download at the following link. |
| 01:38 | Click on the red button in the centre that says 'Free Java Download'. |
| 01:44 | Once the file is downloaded, double-click on it and follow the instructions to install. |
| 01:52 | Let us now look at LibreOffice Base installation: |
| 01:56 | If you have already installed 'LibreOffice Suite' with the complete installation option |
| 02:03 | then you can access LibreOffice Base by clicking on the Start menu at the bottom left of your screen. |
| 02:12 | Click on All Programs and then click on LibreOffice Suite. |
| 02:21 | If you have not installed LibreOffice Suite, |
| 02:24 | you can install Base by visiting the official website and clicking on the green area that says 'Download LibreOffice'. |
| 02:37 | Detailed instructions are available in the first tutorial of LibreOffice Suite. |
| 02:43 | Remember, when installing, use the Complete option to install 'Base'. |
| 02:50 | Okay, let us go to the next topic now. |
| 02:54 | What can you do with LibreOffice Base? |
| 02:57 | With Base - you can store organized data |
| 03:02 | perform data entries and view data using forms |
| 03:08 | retrieve information using queries and |
| 03:12 | design and generate nice, printer-ready reports. |
| 03:17 | Base helps you to manage databases. |
| 03:21 | As you may know, a database is a group of data, forms, queries and reports. |
| 03:29 | For example, 'Base' can be used to manage Customer Information databases, |
| 03:36 | track sales orders and invoices, maintain student grade databases or build a library database. |
| 03:47 | Let us now learn about some basics of databases. |
| 03:51 | A database has data stored and organized into tables. |
| 03:56 | Tables have individual pieces of data, stored in rows and columns. |
| 04:03 | Such a database is also called a relational database where the tables have relationships with each other using the columns. |
| 04:15 | Let us consider a simple database for a Library. |
| 04:20 | A library can be a collection of Books. |
| 04:23 | And books can be issued to members of the library. |
| 04:28 | A book can have a Title, an Author, a Publisher, Year of publication and a Price. |
| 04:37 | These are called characteristics or attributes. |
| 04:42 | Similarly, a Library member has a Name, Phone number and an Address. |
| 04:48 | And the library issues books to its members only. |
| 04:54 | Now, let us see how we can store this data as individual tables of rows and columns. |
| 05:02 | Information about each book can be stored in a Books table, |
| 05:08 | with its attributes becoming the columns: book Title, Author, Publisher, Year of publication and Price. |
| 05:19 | To distinguish each book, let us also add a unique identifier column called BookId. |
| 05:27 | This way, we can have two completely different books with the same title. |
| 05:33 | Similarly, a Members table can have columns like Name and Phone |
| 05:40 | and a Member Id to uniquely identify or distinguish each member. <pause> |
| 05:47 | And we can track the books issued to members in a third table called BooksIssued. |
| 05:56 | This table will track the book issued, the member, date of issue, date of return, actual date of return, whether checked-in or not. |
| 06:09 | We can establish relationships among these tables, to interlink the data in them. |
| 06:16 | Now, this helps us to manage relational databases. |
| 06:22 | For advanced topics on relational databases, refer to our other tutorials by visiting the website Spoken tutorial.org. |
| 06:35 | Okay, let us now get started with our first Base database called “Library”! |
| 06:43 | To create a new database, let us first open the Base program. |
| 06:50 | 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. |
| 07:08 | A pop-up window titled Database Wizard opens. |
| 07:13 | Click on the Next button to create a new database. |
| 07:19 | Click on the Finish button in the following window. |
| 07:23 | This opens a Save As window. |
| 07:27 | Since we are building a Library database, we will type "Library" in the File Name text-box |
| 07:35 | and then click on the Save button. |
| 07:39 | Now, we are in.. |
| 07:42 | Next, let us create tables to store data. |
| 07:46 | To create a new table, click the Tables icon in the Database list on the left. |
| 07:54 | Click on the 'Create Table in Design View' in the Tasks list on the right. This opens another window. |
| 08:05 | Here, type "BookId" as the first column under Field Name. |
| 08:13 | Use the Tab key to move to the Field Type column. |
| 08:18 | Since the BookId will be a different number for each book, select Integer as the Field Type from the drop-down list. |
| 08:32 | Change the Field Properties in the bottom section. |
| 08:36 | Change AutoValue from "No" to "Yes". |
| 08:41 | This field now will uniquely identify each book. |
| 08:46 | In other words, this field is also called the Primary Key. |
| 08:52 | Notice the yellow key symbol to the left of the BookId field. |
| 08:58 | Let us see how we can choose Field Types for Field names. |
| 09:05 | Field types can be text, integer, numeric, decimal or date. |
| 09:13 | Use Text for fields that have general information, for example- name, title, address. |
| 09:22 | Use Integer, numeric, decimal for fields that may contain only numbers. |
| 09:30 | For example- use numeric for a field with price information, Integer for years. |
| 09:39 | Let us create the rest of the fields now. |
| 09:43 | Title- Field type: Text, Author- |
| 09:52 | Field type: Text, Published Year- |
| 09:59 | Field type: Integer, |
| 10:05 | Publisher- |
| 10:09 | Field type: Text, |
| 10:11 | Price- |
| 10:14 | Field type: Numeric. |
| 10:18 | Change the Length to 5 and Decimal places to 2. |
| 10:25 | Click the Format example button. |
| 10:29 | This opens the Field Format window. |
| 10:33 | Select Currency from the Category list and INR from the Format list. |
| 10:42 | Let us choose Rs. 1234.00 that has two decimal places. |
| 10:54 | Notice that the total length is five, inclusive of the two decimal places. |
| 11:02 | Click on the OK button. Now we have created all the columns for the Books table. |
| 11:11 | Let us now save the table. |
| 11:14 | Click on the Save icon that is below the File menu. |
| 11:20 | Type "Books" in the Table Name text-box. |
| 11:25 | Note that it is saved in the same location as the database ‘Library’, as tables are a part of a database. |
| 11:36 | And click on the OK button. |
| 11:39 | In the next tutorial, we will add data to the Books table and create the Members and BooksIssued tables. |
| 11:50 | This brings us to the end of this tutorial. |
| 11:54 | To summarize, we covered the following: |
| 11:58 | What is LibreOffice Base? |
| 12:01 | Prerequisites for using Base |
| 12:03 | What can you do with Base? 'Relational Database basics' |
| 12:08 | Create a new database, create a table. |
| 12:13 | The next tutorial in this series is Tables and Relationships. |
| 12:18 | Spoken Tutorial project is a part of the Talk to a Teacher project, |
| 12:24 | supported by the National Mission on Education through ICT, MHRD, Government of India. |
| 12:32 | This project is co-ordinated by Spoken Tutorial.org |
| 12:38 | More information on the same is available at the following link. |
| 12:44 | This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off.
Thanks for joining. |
