Difference between revisions of "LibreOffice-Suite-Base/C2/Create-queries-using-Query-Wizard/English-timed"

||Welcome to the Spoken tutorial on LibreOffice Base.

||In this tutorial, we will learn how to create simple queries using the Query wizard Select fields Set the sorting order of the fields And provide search criteria or conditions for a query

||Let us first learn what a query is.  

||A Query can be used to get specific information from a database.

||For example, let us consider our familiar Library database example.  

||Let us see how we can create a simple query using Base.  

||our example is to list all the members of the Library along with their phone numbers.

||We are in the Library database. You probably know how to open this by now.

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

||And that is by using a Query Wizard.  

||For creating complex queries, Base provides us with very handy options such as 'Create Query in Design View'  

||and 'Create Query in SQL view', which we will learn about later.

||Now, we see a popup window that says Query Wizard on the top.  

||We are in Step 1 - 'Field Selection'.

||On the right side, we will see a drop down box underneath the label Tables.  

||Since our example query is about getting a list of all the members of the Library, we will click on the Tables: Members from the drop down box.

||Now, let us double click on the 'Name' field in the Available fields list on the left and move it to the list box on the right.  

||Next, let us click on the 'Phone' field on the left and move it to the right.

||Note that to move all the fields to the right we can use the double arrow button that points to the right.

||Now let us click on the Next button at the bottom.

||Now we are in Step 2 - Sorting Order.  

||Since the result of our query is a list of members and their phone numbers, we can leave this as is,

||The Base Wizard, allows us to sort upto 4 fields in the result list at a time.

||For now, let us click on the top most drop down box,  

||And click on Members.Name.  

||Let us click on the Ascending option.

||And proceed to the next step.

||Step 3 - Search Conditions.  

||For example, we can limit the result set to only those members, whose name starts with the alphabet R.  

||For this, we will click on the Fields drop down box and then click on Members.Name.  

||Now, click on the Condition drop down box.  

||Notice the various conditions here;

||Let us click on 'Like'.  

||In the Value text box, let us type in ‘capital R’ and a ‘percentage symbol’.  

||Let us now delete the 'R%' from the value text box to list all the members and click on the Next button.

||This is because we are creating a simple query from a single table.

||Some examples are count of all the members, or sum of the prices of all the books.  

||Okay, now here, let us set aliases;

||Meaning, let us provide friendly and descriptive labels or headers in the resulting list.  

||So let us type in these new aliases in the two text boxes and click on the Next button.

||Now we are in Step 8 - the final step.  

||Now notice that we see an overview of our choices in the wizard.  

||Let us click on the 'Display Query' option on the top right side and click on the Finish button.

||The wizard window has closed and there is a new window whose title says, 'List of all members and their phone numbers'.

||Notice that we see all the four members that we originally entered in the Members table along with their phone numbers.

||Also, we see that, this list is arranged alphabetically in ascending order.  

||So this is our first simple query.

||This brings us to the end of this tutorial on Creating Queries using Wizard in LibreOffice Base

||To summarize, we learned how to : Create simple queries using,the Query wizard Select fields,Set the sorting order of the fields,And provide search criteria or conditions for a query.

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

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

 

And this is soundharya, DesiCrew Solutions, signing off.  

 

Thanks for joining