Calculates Employee Salary in Query Creation on LibreOffice Base

in #utopian-io • 7 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 how to calculate the employees' daily salary
  • You will learn how to calculate the employees' weekly salary
  • You will learn how to calculate the employees' monthly salary
  • You will learn how to create a new Record
  • You will learn how to using * Function in calculate a value.

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 calculate a value. you can see the Video i attached below.

Little additional explanation

first.PNG
In the photo above, I have a Record called "Hourly Wage" whose content is the hourly employee wage.

second.PNG
In the photo above, to find the amount of daily salary of the employee, I use the way Rp.25000 * 12, Working hours of employees in a day is 12 hours.

third.PNG
In the photo above, to find the number of employees weekly salary, I use the way Rp.25000 * 12 * 6, Working hours of employees in a week is 6 days.

fourth.PNG
In the photo above, to find the monthly salary amount of employees, I use the way Rp.25000 * 12 * 6 * 4, Employee's Working Hours in a Month is 4 weeks.

Video Tutorial

#video #tutorial #libreoffice
7 years ago in #utopian-io by
$0.30
  • Past Payouts $0.30, 0.00 TRX
  • - Author $0.25, 0.00 TRX
  • - Curators $0.05, 0.00 TRX
12 votes
Reply 2
Sort:  
  • Trending
    • [-]
     7 years ago 

    @darsondrew I am rejecting this contribution because the level of complexity of your topics is too low. These functions are covered a numerous places throughout the Internet and is easily accessible to the average user. In the future I suggest avoiding functions of these sorts when doing contributions.

    Your future contributions need to focus on UNIQUE functionality of an Open Source project which are not easily learned by the average user. LibreOffice is VERY well documented throughout the Internet. So doing any contributions on a well documented project can be risky.

    If you have a topic you are considering for a contribution you can ask me or any mod for advice before you begin working.

    On another point, much of your text is copied (and sourced) from other websites. We ask that you try to create as much original content as possible for your submissions.

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

    [utopian-moderator]

    $0.00
      Reply
      [-]
       7 years ago 

      Your Post Has Been Featured on @Resteemable!
      Feature any Steemit post using resteemit.com!
      How It Works:
      1. Take Any Steemit URL
      2. Erase https://
      3. Type re
      Get Featured Instantly & Featured Posts are voted every 2.4hrs
      Join the Curation Team Here | Vote Resteemable for Witness