How to create Query using SQL View on OpenOffice Base

Source Image

Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information

What Will I Learn?

In the video I give an explanation how to creating Query using SQL mode.

• You will learn about SELECT & FROM function in writing SQL for searching data in table.
• You will learn to using = , > , < , >= , <= function to searching data
• You will learn about WHERE & AND function in writing SQL for searching data in table.
• You will learn about BETWEEN & AND function in writing SQL

What is OpenOffice Database?

Openoffice.org base or known as BASE alone is software to manipulate and manage the database. Making data input, as well as manipulating and making reports can be done with this BASE.

What is Query?

Query is an extracting data from a database and displays it for further "processing".

Based on some sites i visited, the query can be interpreted as below for detail

Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information in a database. Either can be an efficient way of finding the information you want, especially when you're dealing with thousands of records. Of course, in the hands of an expert, queries can be far more precise and complicated than a filter, but, if you are using OpenOffice.org Base, then the analogy generally holds true, although queries are slightly more complicated than filters to set up. When saved in Base for long term use, a query becomes a view. Source

Or you can read Wikipedia for more information.

Requirements

• System Requirements : Program Install Support Install and Uninstall
• System Requirements : No special requirements.
• OS Support : Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions) Mac OS X (x86-64 only)

Information

• Website & Download: https://www.openoffice.org/
• Type : Office suite software
• License : Dual-licensed under the SISSL and GNU LGPL
• Operating System : Linux, OS X, Microsoft Windows, Solaris
• Platform : IA-32, x86-64, PowerPC, SPARC

Difficulty

Intermediate

Description

Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, I explain how to create a query using SQL view.

Little additional explanation

some SQL instances that i use to

SELECT * FORM "Employee_tbl"

SELECT "First Name", "Last Name", "Gender" FROM "Employee_tbl" WHERE "ID" = 5 (You can change=to>,<,<=,>=)

SELECT "First Name", "Last Name", "Gender" FROM "Employee_tbl" WHERE "Location" = 'Bireuen'

The Formula : 

SELECT ___data you want to display__ FROM __table name__

SELECT ___data you want to display__ FROM __table name__ WHERE __data search area__ = 'data needed'

SELECT ___data you want to display__ FROM __table name__ WHERE __data search area__ BETWEEN __start__ AND __end__

Video Tutorial

Curriculum

If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :

• Apache Open Office learn to create relationship on OpenOffice Base
• Apache OpenOffice learn to use Mail Merge
• Apache OpenOffice Formula learning (1)
• Apache OpenOffice Formula learning (2)
• And if you want to know more of tutorials you can directly see on my profile

---

Posted on Utopian.io - Rewarding Open Source Contributors

---