Class 10 IT Chapter- Database Management System Topic- Edit Query in Open Office Base

How to use functions in Open Office Base?

Open Office Base gives many inbuilt function like Average, Count, Maximum, Minimum, and Sum to do calculation in query.

These are the steps to use functions:
1) Click Query component.
2) Select query and press mouse right button.
3) Click Edit option in menu.
4) In function select any function.
5) Press Save button.

How to use criteria in Open Office Base?

Criteria are used to get specific result in query. We can set single criteria or multiple criteria in open office base.

Criteria in Query in Open Office Base

These are the steps to use criteria.
1) Click Query component.
2) Select query and press mouse right button.
3) Click Edit option in menu.
4) In criteria, set condition.
5) Press Save button.

--------------------------------------------------

Chapter - Database Management System

• Database
• Primary key / Foreign Key
• Create Database in Open Office Base
• Create Table in Open Office Base
• Update Table in Open Office Base
  
• Create Query in Open Office Base
• Creating Form in Open Office Base
• Report in Open Office Base
  
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
  

-------------------------------------------------

How to use wild cards in Open Office Base?

Wildcard is used to get specific record from a table in a query. Open Office Base give two wildcards ‘%’ and ‘_’. The ‘%’ is used for multiple characters and ‘_’ is used for single character in a query.

These are the steps to use wildcard.
1) Select query in database.
2) Press mouse right button and select Edit option.
3) In query design view, set criteria using wildcard. For example like ‘M%’ or like ‘M_ _ _’.
4) Now run query.

--------------------------------------------------

  Class 10 IT (402) Notes

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application

--------------------------------------------------

How to use mathematical operators in query in Open Office Base?

In Open Office Base, fields can use mathematical operators to do calculation in query.

Calculation in Query in Open Office Base

These are the steps to use mathematical operators.
1) Select query in database.
2) Press mouse right button and select Edit option.
3) In query design view, type field with maths operators.
4) Now run query.

How to use grouping data in query in Open Office Base?

In Open Office Base, records can be grouped using inbuilt function to get summary of a long query.

These are the steps to use grouping.
1) Select query in database.
2) Press mouse right button and select Edit option.
3) In query design view, select group in desired field in function.
4) Select any function.
5) Now run query.