LibreOffice-Suite-Base/C3/Create-tables/English-timed

From Script | Spoken-Tutorial
Revision as of 15:06, 9 July 2014 by Gaurav (Talk | contribs)

Jump to: navigation, search
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 Lets 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 popup window that says Add tables.
02:06 Let us click on Members
02:09 And close this popup 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 or 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 co-ordinated 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