Page 25 - 2501_KVS_C-8

Now, select the “Delete Record” option from the menu and the record of ‘Kishan’ will get
deleted. The screen after deletion will be shown as:

Likewise, we may delete other records as per our need.
So, this is how we can insert and delete records from a table in Base of LibreOffice. Now,

it’s time for you to practice on your computer system.

1.10 QUERY CREATION USING WIZARD

In this section, we will discuss how to query some information from a table. For this, we
need to understand the meaning of the term “Query”. Let us discuss it first.
Query: A query is a kind of request for information from a database or in general
term query means to asking for information. Actually, this is the aim of developing
a database to provide us with information as required. Also, all of us always need

some form of information in our day-to-day life. Therefore, we learn how to develop
a database and query them for getting information as per our requirement. The Base
software of LibreOffice also provides us with the facility to query the database.
For example, one may need the first name of those contacts who live in “Delhi” from our

above created table “Contacts”.

Introduction to Database Concepts 23