Page 223 - Computer - 10(A&B)

Customer Orders Products
CustID Order ID ProductsID
First Name CustID ProductName
Last Name ProductsID Price
Amount

Removeing a Relationship

The relationships applied on the tables can be removed. Right-click on the relationship thread (line) and select
the Delete option.

Session 4

Queries in Base

Sometimes, you may not need entire database values all the time. You might need to extract some specific piece
of information which satisfies certain conditions. Queries help to display selective records or fields from single
or multiple tables related with each other.
LibreOffice Base allow us to design, execute, and store a query. You can create a query with one of the following
ways:
v Create a Query in Design View: This method allows us to design a query from scratch.
v Use Wizard to Create a Query: The wizard will guide you to create a query from a selected table.
v Create a Query in SQL View: SQL stands for Structured Query Language. SQL is the standard language for
relational database management system.

Creating a Query Using Design View
This is one of the most common way to create queries which retrieve data from one or more tables to select and
display the required information. This is also known as simple select Query.
Step 1: Open the database.
Step 2: In the left pane of the database window, click the Queries icon.
Step 3: Under Tasks area, click Create Query in Design View.

105