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

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

Latest revision as of 12:11, 23 March 2017

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

http://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.

Contributors and Content Editors

Gaurav, Minal, PoojaMoolya, Sandhya.np14