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

|Welcome to the Spoken tutorial on LibreOffice Base.

|Create a Table by

|a) Creating Views and

|b) Using the Copy method

|Lets go to our Library database.  

|Let us click on the Tables icon on the left panel.  

|We will go through the ‘Create View’ option now.

|Before that, let us learn about Views. What is a View?

|A view is similar to a table, but it does not hold the data.  

|Views can be used to allow limited access  

|Or hide the structure and names of the underlying table columns and table data.

|For example, we can create a simple view which will list all the members of the library,

|And we can leave out their phone numbers to maintain confidentiality.  

|Here the underlying table would be Members.  

|Other users of the Library database can be allowed to access this view but not the Members table.  

|Okay, let us go back to the main Base window, and create this view.

|Let us click on ‘Create View’ on the right panel.

|We see a new window called the View Design and a popup window that says Add tables.

|Let us click on Members  

|And close this popup window.

|Now, we are in the View design window.  

|And we will double click on the MemberId and the Name fields.  

|Adding the Id field is always useful  

|Because this helps us to join this view with any other related table, for example the BooksIssued Table.

|For this, let us click on the empty cell in the Sort row under the Name column in the bottom section.  

|And then click on ‘ascending’.

|Let us save our first view.  

|Here, let us type a descriptive name for this view: View: Members Name Only.  

|And let us click on the Ok button.  

|To see the underlying data, let us click on the Edit menu at the top  

|And then click on Run Query at the bottom.

|And we see a new section at the top that lists all the members of the Library in ascending order.  

|And there is our simple view.  

|Create a View of Books Issued to Members and only those books that are not checked in.  

|Include in the view, the following fields: Book Titles, Member Names, Issue Date, and Return Date.  

|Name the view as ‘View: List of Books not checked in’.

|Okay, let us learn to create tables by using the copy method.

|For this, let us assume that our Library has DVDs and CDs.  

|And we can store this data in a new table called Media.  

|In order to distinguish between an audio and a video, we will introduce a MediaType field.  

|Now since the Books table has almost similar fields, we can copy-paste the Books table,

|And then we can rename the fields and the table name in the process.  

|Let us go to the main Base window.

|Here let us right click on the Books table,

|And we will see the copy option. Let us click on it;

|And then right click on it.  

|Notice the various options here. There is a paste and  also there is a Paste Special.

|We can use copy and paste in a specific format.

|So we can choose the database table here,

|Or we can choose Paste from the right click menu.

|We will first rename our table by typing in ‘Media’ against the table name.

|In the options, we will click on Definition and Data.  

|Let us click on the Next button.

|Let us choose BookId, title and publish-year for this demonstration.  

|Now we will select these fields on the left and use the single arrow button to move them to the right side

|and click on Next button.

|Here we can rename the fields and change their data types.  

|We will rename the BookId to MediaId.

|And we will click on the Create button.

|In the main Base window, there is our new Media table.  

|Let us now edit the table to add a new field MediaType  which will hold the audio or the video type information.

|Now we are in the table design window.

|Here let us introduce MediaType as the last column.  

|Let us click on the cell below Publishyear

|And enter ‘MediaType’ as Field Name and then choose Text or Field Type.

|Now let us save the table design and we are done.  

|There, we just created our Media table by using the Copy method.

|Here, use the ‘Assets’ sample table and rename it to ‘AssetsCopy’.

|And explore the various options in this method.

|This brings us to the end of this tutorial on Creating Tables in LibreOffice Base

|To summarize, we learned how to   

b) Using the Copy method

|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.  

|This script has been contributed by Priya Suresh, DesiCrew Solutions.

 

And this is Soundharya, DesiCrew Solutions, signing off.  

 

 

Thanks for joining