Page 245 - IT_V1.0_Class10
P. 245

Unit-3 DATABASE MANAGEMENT SYSTEM USING LIBREOFFICE BASE






                11        QUERIES IN BASE











                 A query in LibreOffice Base is a powerful tool used to retrieve, manipulate, and analyse data stored in a
                 database. It  allows  users  to  extract specific  information  by  defining  conditions,  such  as  filtering records,
                 sorting data, and performing calculations. LibreOffice Base offers various types of queries, including Select,
                 Update, Insert, and Delete queries, each serving different purposes.

                   QUERY

                 In a database, a query is a tool through which data is accessed or manipulated in a table. A user can apply
                 filter criteria in the query so that only those records that meet the criteria are accessed and displayed. The
                 information can be retrieved from a single table or multiple tables. The query results are displayed in a tabular
                 format, with field names as column headers and the corresponding records in rows.
                 In LibreOffice Base, there are two ways to generate a query, which are as follows:

                   Create Query in Design View
                   Use Wizard to Create Query
                 Example:  Suppose  we  have  a  database  for  a  company,  and  it  includes  a  table  named  Employees.  The
                 Employees table has various records, including information about the department each employee belongs
                 to. We want to retrieve the details of all employees who work in the Editorial department.

                 Create Query in Design View

                 Follow the given steps to create a query using a Design view:
                 Step 1:  Select the Queries object in the Database pane
                 Step 2:  Select the Create Query in Design View option under the Tasks pane.









                                2



                                1


                          The Query Design window open with the Add Table or Query dialog box.

                 Step 3:  Select the desired Tables radio button if you want to create a query by using a table or select the
                          Queries radio button if you want to create a query by using other queries. In our case, we have
                          selected the Tables radio button.



                                                                                                  Queries in Base   243
   240   241   242   243   244   245   246   247   248   249   250