Limit the record for creating Query on LibreOffice Base

in #utopian-io6 years ago (edited)

canok.png

Source Image

LibreOffice is a powerful office suite – its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice includes several applications that make it the most powerful Free and Open Source office suite on the market: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing). More Information

What Will I Learn?

In the video I give an explanation how to looking value in LibreOffice base.

  • You will learn to create a Query.
  • You will learn search for a value using the Distinct Value.
  • You will learn how to limit the data record to Query.
  • You will learn to add new Record.

What is LibreOffice Database?

LibreOffice Base is a LibreOffice application component that works to create and manipulate a structured database.

Based on LibreOffice's official website, LibreOffice base can be explained as below.

Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.

What is LibreOffice Base Report?

A report is a Writer text document that can show your data in an organized order and formatting. In LibreOffice Base, you have a choice to create a report either manually using drag-and-drop in the Report Builder window, or semi-automatic by following a series of dialogs in the Report Wizard.
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.libreoffice.org/
  • Type : Office suite software
  • License : MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[9]
  • Operating System : Linux, Windows, macOS,[5] FreeBSD, OpenBSD,[6] NetBSD, Android (Viewer)
  • Platform : IA-32, x86-64, ARMel, ARMhf, MIPS, MIPSel, PowerPC, Sparc, S390, S390x, IA-64 (additional Debian platforms)[7]

Difficulty

Intermediate

Description

LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. In the video below, I explain how to limit the record using Distinct tools & limit. you can see the Video i attached below.

Little additional explanation

first.PNG
In the photo above, I show all the records from my table.

second.PNG
in the photo above, I limit the view to 20 records only.

third.PNG
In the photo above, I added a new record manually, every letter writing in the addition of a record should start with a ' sign and end with ' too, for example: 'Indonesia'

Video Tutorial

Curriculum

However I have made some Video Tutorials how to use Apache OpenOffice, you can see it below :



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

WARNING - The message you received from @edoaja is a CONFIRMED SCAM!
DO NOT FOLLOW any instruction and DO NOT CLICK on any link in the comment!

For more information, read this post:
https://steemit.com/steemit/@arcange/phishing-site-reported-steemautobot-dot-ml

If you find my work to protect you and the community valuable, please consider to upvote this warning or to vote for my witness.

Upon further review, we discover that this tutorial cannot be accepted.

Your tutorial fails to deliver substantial functions of the Open source project as limiting the rows from 20 to 5 is self explanatory and does not need a tutorial for this purpose.

Please spend time to create tutorials that give people insight into the usage of the functions. Trivial simple tutorials hold no particular value as this kind of information can be easily found.

If you have questions, please contact us at Discord.


Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.

[utopian-moderator]

Thank you for reviewing :)