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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
Line 328: Line 328:
 
|-
 
|-
 
|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'''.
  
 
|-
 
|-

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