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

