LibreOffice - How to set Switch Design View to create a Query

Source image

About project

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?

• You will learn to create a query.
• You will learn how to add the column from table using Switch Design View tool.
• You will learn to set your SQL Switch Design view tool to creat a query.

What is query ?

Query is a language used to manipulate a database, which has been standardized and known as Structured Query Language (SQL)

Queries can be defined as commands to access data in a database or database. So in general, Understanding the query is a language used to manipulate, change, add, organize something or data in the database.

What is SQL ?

SQL is a language used to access data in a relational database. This language is de facto the standard language used in relational database management.

Through SQL, you can perform administrative functions on databases such as running queries to retrieve data in a database, accessing data (read database), loading data in a database, deleting data from a database, and changing data in the database.

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 create a report and how to edit a report, I explain how to edit header, date and time, page of number, font style, underlining and more. To more detail please go to video i have attached

Video Tutorial

Curriculum

This is my first Video Tutorial on LibreOffice

Before I also made a tutorial on Apache Openoffice. you can see my tutorial below

• Apache Openoffice - Tutorial Creating query on database using App Apache Openoffice

• Apache OpenOffice - Tutorial create table using formula SUM IF, SUM IFS, & SUM PRODUCT using app Apache Openoffice

• Apache OpenOffice - How to create calculating future finance using FV, PMT , and PV formulas using app Apache Openoffice

• Apache OpenOffice - How to Calculating Depreciation with various methods

• Apache OpenOffice - How to calculate financial finance using openoffice calc

• Apache OpenOffice - Using Offset, Choose and Indirect on Openoffice calc

  
  

  ---

  Posted on Utopian.io - Rewarding Open Source Contributors

  ---