Difference between revisions of "LibreOffice-Suite-Base/C3/Create-tables/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
|-
 
|-
 
|00:00
 
|00:00
|Welcome to the Spoken tutorial on LibreOffice Base.
+
|Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''.
  
 
|-
 
|-
Line 12: Line 12:
 
|-
 
|-
 
|00:07
 
|00:07
|Create a Table by
+
| create a '''Table''' by-
  
 
|-
 
|-
 
|00:09
 
|00:09
|a) Creating Views and
+
|a) Creating '''Views''' and
  
 
|-
 
|-
 
|00:11
 
|00:11
|b) Using the Copy method
+
|b) Using the '''Copy''' method.
  
 
|-
 
|-
 
|00:13
 
|00:13
|Lets go to our Library database.  
+
|Let's go to our '''Library''' database.  
  
 
|-
 
|-
 
|00:16
 
|00:16
|Let us click on the Tables icon on the left panel.  
+
|Let us click on the '''Tables''' icon on the left panel.  
  
 
|-
 
|-
Line 36: Line 36:
 
|-
 
|-
 
|00:26
 
|00:26
|We will go through the ‘Create View’ option now.
+
|We will go through the '''Create View''' option now.
  
 
|-
 
|-
 
|00:30
 
|00:30
|Before that, let us learn about Views. What is a View?
+
|Before that, let us learn about '''View'''s. What is a View?
  
 
|-
 
|-
 
|00:36
 
|00:36
|A view is similar to a table, but it does not hold the data.  
+
|A '''view''' is similar to a '''table''' but it does not hold the data.  
  
 
|-
 
|-
Line 56: Line 56:
 
|-
 
|-
 
|01:00
 
|01:00
|Views can be used to allow limited access  
+
|'''View'''s can be used to allow limited access  
  
 
|-
 
|-
 
|01:06
 
|01:06
|Or hide the structure and names of the underlying table columns and table data.
+
|or hide the structure and names of the underlying table columns and table data.
  
 
|-
 
|-
 
|01:13
 
|01:13
|For example, we can create a simple view which will list all the members of the library,
+
|For example, we can create a simple view which will list all the members of the library  
  
 
|-
 
|-
 
|01:21
 
|01:21
|And we can leave out their phone numbers to maintain confidentiality.  
+
|and we can leave out their phone numbers to maintain confidentiality.  
  
 
|-
 
|-
 
|01:27
 
|01:27
|Here the underlying table would be Members.  
+
|Here the underlying table would be '''Members'''.  
  
 
|-
 
|-
 
|01:32
 
|01:32
|Other users of the Library database can be allowed to access this view but not the Members table.  
+
|Other users of the '''Library''' database can be allowed to access this view but not the '''Members''' table.  
  
 
|-
 
|-
Line 84: Line 84:
 
|-
 
|-
 
|01:46
 
|01:46
|Okay, let us go back to the main Base window, and create this view.
+
|Okay, let us go back to the main '''Base''' window and create this '''view'''.
  
 
|-
 
|-
 
|01:53
 
|01:53
|Let us click on ‘Create View’ on the right panel.
+
|Let us click on '''Create View''' on the right panel.
  
 
|-
 
|-
 
|01:58
 
|01:58
|We see a new window called the View Design and a popup window that says Add tables.
+
|We see a new window called the '''View Design''' and a pop-up window that says '''Add tables'''.
  
 
|-
 
|-
 
|02:06
 
|02:06
|Let us click on Members  
+
|Let us click on '''Members'''
  
 
|-
 
|-
 
|02:09
 
|02:09
|And close this popup window.
+
|and close this pop-up window.
  
 
|-
 
|-
 
|02:12
 
|02:12
|Now, we are in the View design window.  
+
|Now, we are in the '''View design''' window.  
  
 
|-
 
|-
 
|02:16
 
|02:16
|And we will double click on the MemberId and the Name fields.  
+
|And we will double-click on the '''MemberId''' and the '''Name''' fields.  
  
 
|-
 
|-
 
|02:21
 
|02:21
|Adding the Id field is always useful  
+
|Adding the 'Id' field is always useful  
  
 
|-
 
|-
 
|02:25
 
|02:25
|Because this helps us to join this view with any other related table, for example the BooksIssued Table.
+
|because this helps us to join this view with any other related table, for example- the '''BooksIssued''' Table.
  
 
|-
 
|-
Line 128: Line 128:
 
|-
 
|-
 
|02:45
 
|02:45
|For this, let us click on the empty cell in the Sort row under the Name column in the bottom section.  
+
|For this, let us click on the empty '''cell''' in the '''Sort''' row under the '''Name''' column in the bottom section.  
  
 
|-
 
|-
 
|02:54
 
|02:54
|And then click on ‘ascending’.
+
|And then click on '''‘ascending’'''.
  
 
|-
 
|-
 
|02:58
 
|02:58
|Let us save our first view.  
+
|Let us '''save''' our first view.  
  
 
|-
 
|-
 
|03:01
 
|03:01
|Here, let us type a descriptive name for this view: View: Members Name Only.  
+
|Here, let us type a descriptive name for this view- '''View: Members Name Only'''.  
  
 
|-
 
|-
 
|03:10
 
|03:10
|And let us click on the Ok button.  
+
|And let us click on the '''OK''' button.  
  
 
|-
 
|-
 
|03:14
 
|03:14
|To see the underlying data, let us click on the Edit menu at the top  
+
|To see the underlying data, let us click on the '''Edit''' menu at the top  
  
 
|-
 
|-
 
|03:22
 
|03:22
|And then click on Run Query at the bottom.
+
|and then click on '''Run Query''' at the bottom.
  
 
|-
 
|-
 
|03:27
 
|03:27
|And we see a new section at the top that lists all the members of the Library in ascending order.  
+
|And we see a new section at the top that lists all the members of the 'Library' in ascending order.  
  
 
|-
 
|-
Line 164: Line 164:
 
|-
 
|-
 
|03:40
 
|03:40
|And there is our simple view.  
+
|And there is our simple '''view'''.  
  
 
|-
 
|-
Line 176: Line 176:
 
|-
 
|-
 
|03:53
 
|03:53
|Create a View of Books Issued to Members and only those books that are not checked in.  
+
|Create a View of 'Books Issued' to Members and only those books that are not checked-in.  
  
 
|-
 
|-
 
|04:01
 
|04:01
|Include in the view, the following fields: Book Titles, Member Names, Issue Date, and Return Date.  
+
|Include in the view, the following fields: '''Book Titles, Member Names, Issue Date''' and '''Return Date'''.  
  
 
|-
 
|-
 
|04:12
 
|04:12
|Name the view as ‘View: List of Books not checked in’.
+
|Name the view as ''''View: List of Books not checked in''''.
  
 
|-
 
|-
 
|04:20
 
|04:20
|Okay, let us learn to create tables by using the copy method.
+
|Okay, let us learn to create '''table'''s by using the '''copy''' method.
  
 
|-
 
|-
Line 196: Line 196:
 
|-
 
|-
 
|04:33
 
|04:33
|For this, let us assume that our Library has DVDs and CDs.  
+
|For this, let us assume that our '''Library''' has DVDs and CDs.  
  
 
|-
 
|-
 
|04:39
 
|04:39
|And we can store this data in a new table called Media.  
+
|And we can store this data in a new table called '''Media'''.  
  
 
|-
 
|-
Line 208: Line 208:
 
|-
 
|-
 
|04:51
 
|04:51
|In order to distinguish between an audio and a video, we will introduce a MediaType field.  
+
|In order to distinguish between an audio and a video, we will introduce a '''MediaType''' field.  
  
 
|-
 
|-
 
|05:00
 
|05:00
|Now since the Books table has almost similar fields, we can copy-paste the Books table,
+
|Now, since the '''Books''' table has almost similar fields, we can copy-paste the '''Books''' table  
  
 
|-
 
|-
 
|05:08
 
|05:08
|And then we can rename the fields and the table name in the process.  
+
|and then we can '''rename''' the fields and the table name in the process.  
  
 
|-
 
|-
Line 224: Line 224:
 
|-
 
|-
 
|05:16
 
|05:16
|Let us go to the main Base window.
+
|Let us go to the main '''Base''' window.
  
 
|-
 
|-
 
|05:19
 
|05:19
|Here let us right click on the Books table,
+
|Here, let us right-click on the '''Books''' table  
  
 
|-
 
|-
 
|05:23
 
|05:23
|And we will see the copy option. Let us click on it;
+
|and we will see the '''Copy''' option. Let us click on it.
  
 
|-
 
|-
 
|05:28
 
|05:28
|And then right click on it.  
+
|And then right-click on it.  
  
 
|-
 
|-
 
|05:31  
 
|05:31  
|Notice the various options here. There is a paste and  also there is a Paste Special.
+
|Notice the various options here. There is a '''Paste''' and  also there is a '''Paste Special'''.
  
 
|-
 
|-
 
|05:39
 
|05:39
|We can use copy and paste in a specific format.
+
|We can use '''copy''' and '''paste''' in a specific format.
  
 
|-
 
|-
Line 252: Line 252:
 
|-
 
|-
 
|05:51
 
|05:51
|So we can choose the database table here,
+
|So, we can choose the database table here
  
 
|-
 
|-
 
|05:55
 
|05:55
|Or we can choose Paste from the right click menu.
+
|or we can choose '''Paste''' from the right-click menu.
  
 
|-
 
|-
Line 264: Line 264:
 
|-
 
|-
 
|06:03
 
|06:03
|We will first rename our table by typing in ‘Media’ against the table name.
+
|we will first rename our table by typing in '''‘Media’''' against the table name.
  
 
|-
 
|-
 
|06:11
 
|06:11
|In the options, we will click on Definition and Data.  
+
|In the options, we will click on ''''Definition and data''''.  
  
 
|-
 
|-
 
|06:16
 
|06:16
|Let us click on the Next button.
+
|Let us click on the '''Next''' button.
  
 
|-
 
|-
Line 280: Line 280:
 
|-
 
|-
 
|06:23
 
|06:23
|Let us choose BookId, title and publish-year for this demonstration.  
+
|Let us choose '''BookId, title''' and '''publish-year''' for this demonstration.  
  
 
|-
 
|-
 
|06:29
 
|06:29
|Now we will select these fields on the left and use the single arrow button to move them to the right side
+
|Now, we will select these fields on the left and use the single arrow button to move them to the right side
  
 
|-
 
|-
 
|06:39
 
|06:39
|and click on Next button.
+
|and click on '''Next''' button.
  
 
|-
 
|-
Line 296: Line 296:
 
|-
 
|-
 
|06:46
 
|06:46
|Here we can rename the fields and change their data types.  
+
|Here, we can rename the fields and change their data types.  
  
 
|-
 
|-
 
|06:51
 
|06:51
|We will rename the BookId to MediaId.
+
|We will rename the '''BookId''' to '''MediaId'''.
  
 
|-
 
|-
 
|06:55
 
|06:55
|And we will click on the Create button.
+
|And we will click on the '''Create''' button.
  
 
|-
 
|-
 
|06:59
 
|06:59
|In the main Base window, there is our new Media table.  
+
|In the main '''Base''' window, there is our new '''Media''' table.  
  
 
|-
 
|-
 
|07:05
 
|07:05
|Let us now edit the table to add a new field MediaType  which will hold the audio or the video type information.
+
|Let us now edit the table to add a new field '''MediaType''' which will hold the audio or the video type information.
  
 
|-
 
|-
 
|07:15
 
|07:15
|Now we are in the table design window.
+
|Now, we are in the '''Table Design''' window.
  
 
|-
 
|-
 
|07:19
 
|07:19
|Here let us introduce MediaType as the last column.  
+
|Here, let us introduce '''MediaType''' as the last column.  
  
 
|-
 
|-
 
|07:24
 
|07:24
|Let us click on the cell below Publishyear
+
|Let us click on the '''cell''' below '''publishyear'''
  
 
|-
 
|-
 
|07:27
 
|07:27
|And enter ‘MediaType’ as Field Name and then choose Text or Field Type.
+
|and enter ''''MediaType’''' as '''Field Name''' and then choose '''Text''' for '''Field Type'''.
  
 
|-
 
|-
 
|07:36
 
|07:36
|Now let us save the table design and we are done.  
+
|Now, let us '''save''' the table design and we are done.  
  
 
|-
 
|-
 
|07:41
 
|07:41
|There, we just created our Media table by using the Copy method.
+
|There, we just created our '''Media''' table by using the '''Copy''' method.
  
 
|-
 
|-
Line 348: Line 348:
 
|-
 
|-
 
|07:57
 
|07:57
|Here, use the ‘Assets’ sample table and rename it to ‘AssetsCopy’.
+
|Here, use the ‘Assets’ sample table and rename it to ‘AssetsCopy’  
  
 
|-
 
|-
 
|08:04
 
|08:04
|And explore the various options in this method.
+
|and explore the various options in this method.
  
 
|-
 
|-
 
|08:08
 
|08:08
|This brings us to the end of this tutorial on Creating Tables in LibreOffice Base
+
|This brings us to the end of this tutorial on '''Creating Tables in LibreOffice Base'''.
  
 
|-
 
|-
 
|08:14
 
|08:14
|To summarize, we learned how to   
+
|To summarize, we learned how to-  
  
 
|-
 
|-
Line 366: Line 366:
 
|Create a Table by
 
|Create a Table by
 
a) Creating Views and
 
a) Creating Views and
b) Using the Copy method
+
b) Using the Copy method.
  
 
|-
 
|-
 
|08:23
 
|08:23
|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 co-ordinated by http://spoken-tutorial.org. More information on the same is available at the following link.  
+
|'''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.  
  
 
|-
 
|-
 
|08:44
 
|08:44
|This script has been contributed by Priya Suresh, DesiCrew Solutions.
+
|This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off.  
 
+
Thanks for joining.
And this is Soundharya, DesiCrew Solutions, signing off.  
+
 
+
 
+
Thanks for joining
+
  
 
|-
 
|-

Latest revision as of 07:48, 28 February 2020

Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Base.
00:04 In this tutorial, we will learn how to
00:07 create a Table by-
00:09 a) Creating Views and
00:11 b) Using the Copy method.
00:13 Let's go to our Library database.
00:16 Let us click on the Tables icon on the left panel.
00:21 On the right panel, we see three ways of creating a table.
00:26 We will go through the Create View option now.
00:30 Before that, let us learn about Views. What is a View?
00:36 A view is similar to a table but it does not hold the data.
00:43 It is defined as a Query Expression, which is simply retrieval of data from tables or other views from the database.
00:54 So, when viewed, it has columns and rows of data just like a table.
01:00 Views can be used to allow limited access
01:06 or hide the structure and names of the underlying table columns and table data.
01:13 For example, we can create a simple view which will list all the members of the library
01:21 and we can leave out their phone numbers to maintain confidentiality.
01:27 Here the underlying table would be Members.
01:32 Other users of the Library database can be allowed to access this view but not the Members table.
01:40 In this way, we can only see the names of the members and not their phone numbers.
01:46 Okay, let us go back to the main Base window and create this view.
01:53 Let us click on Create View on the right panel.
01:58 We see a new window called the View Design and a pop-up window that says Add tables.
02:06 Let us click on Members
02:09 and close this pop-up window.
02:12 Now, we are in the View design window.
02:16 And we will double-click on the MemberId and the Name fields.
02:21 Adding the 'Id' field is always useful
02:25 because this helps us to join this view with any other related table, for example- the BooksIssued Table.
02:34 We can add functions, criteria and sort it any way we want.
02:40 But for now, we will sort the member names in ascending order.
02:45 For this, let us click on the empty cell in the Sort row under the Name column in the bottom section.
02:54 And then click on ‘ascending’.
02:58 Let us save our first view.
03:01 Here, let us type a descriptive name for this view- View: Members Name Only.
03:10 And let us click on the OK button.
03:14 To see the underlying data, let us click on the Edit menu at the top
03:22 and then click on Run Query at the bottom.
03:27 And we see a new section at the top that lists all the members of the 'Library' in ascending order.
03:36 Note that we don’t see any phone numbers.
03:40 And there is our simple view.
03:43 We can create and design views according to our requirements.
03:48 Before moving on to the next topic, here is an assignment.
03:53 Create a View of 'Books Issued' to Members and only those books that are not checked-in.
04:01 Include in the view, the following fields: Book Titles, Member Names, Issue Date and Return Date.
04:12 Name the view as 'View: List of Books not checked in'.
04:20 Okay, let us learn to create tables by using the copy method.
04:25 This is an easy way of creating tables, if we know that the table structures are going to be very similar.
04:33 For this, let us assume that our Library has DVDs and CDs.
04:39 And we can store this data in a new table called Media.
04:44 A CD or a DVD can have a title and a publish-year for example.
04:51 In order to distinguish between an audio and a video, we will introduce a MediaType field.
05:00 Now, since the Books table has almost similar fields, we can copy-paste the Books table
05:08 and then we can rename the fields and the table name in the process.
05:14 We’ll see how.
05:16 Let us go to the main Base window.
05:19 Here, let us right-click on the Books table
05:23 and we will see the Copy option. Let us click on it.
05:28 And then right-click on it.
05:31 Notice the various options here. There is a Paste and also there is a Paste Special.
05:39 We can use copy and paste in a specific format.
05:44 Possible formats are Formatted text, HTML or a Data Source Table.
05:51 So, we can choose the database table here
05:55 or we can choose Paste from the right-click menu.
05:59 This opens a wizard and in this window,
06:03 we will first rename our table by typing in ‘Media’ against the table name.
06:11 In the options, we will click on 'Definition and data'.
06:16 Let us click on the Next button.
06:19 In the next window, we will add the columns.
06:23 Let us choose BookId, title and publish-year for this demonstration.
06:29 Now, we will select these fields on the left and use the single arrow button to move them to the right side
06:39 and click on Next button.
06:42 In the next window, we see our columns.
06:46 Here, we can rename the fields and change their data types.
06:51 We will rename the BookId to MediaId.
06:55 And we will click on the Create button.
06:59 In the main Base window, there is our new Media table.
07:05 Let us now edit the table to add a new field MediaType which will hold the audio or the video type information.
07:15 Now, we are in the Table Design window.
07:19 Here, let us introduce MediaType as the last column.
07:24 Let us click on the cell below publishyear
07:27 and enter 'MediaType’ as Field Name and then choose Text for Field Type.
07:36 Now, let us save the table design and we are done.
07:41 There, we just created our Media table by using the Copy method.
07:48 Okay, here is another assignment.
07:51 Create a table using the ‘Use Wizard to Create table’ method.
07:57 Here, use the ‘Assets’ sample table and rename it to ‘AssetsCopy’
08:04 and explore the various options in this method.
08:08 This brings us to the end of this tutorial on Creating Tables in LibreOffice Base.
08:14 To summarize, we learned how to-
08:17 Create a Table by

a) Creating Views and b) Using the Copy method.

08:23 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.
08: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, Sandhya.np14