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
Thank you for your contribution.
Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.
[utopian-moderator]
Thank you mod
Hey @darsondrew! Thank you for the great work you've done!
We're already looking forward to your next contribution!
Fully Decentralized Rewards
We hope you will take the time to share your expertise and knowledge by rating contributions made by others on Utopian.io to help us reward the best contributions together.
Utopian Witness!
Vote for Utopian Witness! We are made of developers, system administrators, entrepreneurs, artists, content creators, thinkers. We embrace every nationality, mindset and belief.
Want to chat? Join us on Discord https://discord.me/utopian-io