What is Query in Open Office Base?
In database Query
is the main component of a Database. In tables large amount of data is stored
in an organized way. A query is designed to get record from a database or a table.
In My SQL query can be designed by writing a command. On the other hand Open
Office Base gives three ways to design a query.
Query can be designed in three ways:
1) Create Query in
Design View
2) Use Wizard to Create Query
3) Create Query in SQL View
--------------------------------------------------
Other Topics of this Chapter
- 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 create Query in Design View in Open Office Base?
1) In Database select Queries option and click “Create Query in Design View”
 |
| Database Components in Open Office Base |
2) “Add tables for Query” dialogue box opens up. Select the tables for Query.
 |
| Query in Open Office Base |
3) Select fields, Criterion and other option and press “Run Query” button.
 |
| Query in Open Office Base |
4) Now give the query name and save it.
 |
| Query in Open Office Base |
Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application
--------------------------------------------------
How to create Query using wizard in Open Office Base?
In Open Office Base, Wizard gives many options to create a Query to get record from a tables in database.
1) In Database select “Use Wizard to Create Query”
 |
| Query Wizard in Open Office Base |
2) A Query Wizard
dialogue box opens up. Select tables and fields from the dialogue box.
 |
| Query Wizard in Open Office Base |
Sample Paper of Class 10
- English Sample Paper 2022 - 23
- Hindi A Sample Paper 2022 - 23
- Maths (Standard) Sample Paper 2022 - 23
- Maths (Basic) Sample Paper 2022 - 23
- Science Sample Paper 2022 - 23
- Social Science Sample Paper 2022 - 23
4) Press next
button and select conditions in the dialogue box.
5) Now press
finish button, and it gives the result.
Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application
What is Relationship among tables in Database?
Relational means establishing link between two or more tables of a database. RDBMS is a relational DBMS in which tables are linked to each other by fields.
 |
| Relationship in Tables in Database |
1) Many to Many: In these relationship primary keys of two tables join together and form another table to set up relationship among tables.
 |
| Many to Many Relationship in Table |
2) One to Many: In this relationship primary key of one table becomes foreign key of another table to set up relationship between two tables.
 |
| One to Many Relationship in Table |
3) One to One: In this relationship two or more table share same primary key to set up relationship among tables
 |
| One to One Relationship in Table |
--------------------------------------------------
Sample Paper of Class 10 IT 402
- Sample Paper 2020 - 21
- Sample Paper 2021 - 22
- Sample Paper 2021 - 22
- Sample Paper 2022 - 23
- Sample Paper 2022 - 23
No comments:
Post a Comment