Building a database application using OOo Base
REACHING BASE
If you need a quick and easy solution, try building your own database application in OpenOffice.org 2.0.
OpenOffice.org 2.0 features a new database module based on HyperSonic SQL, a Java-based relational database engine. You can use OOo Base to build anything from a simple recipe collection to a powerful asset management solution. Base is a powerful tool, but for those not familiar with its features, developing even a simple database solution can be a bit overwhelming. This article guides you through the steps of setting up a simple business database application using Base. Planning the Database A Relational Database Management System (RDBMS) typically consists of four parts: • tables • queries • forms • reports Data within a database is stored in tables. Queries are used to extract, view, and manipulate the data. Que- ries can draw together data from many tables, and If you need a quick and easy solution, try building your own database application in OpenOffice.org 2.0. BY DMITRI POPOV that data is then available for forms and reports. Forms allow you to view and edit the data in a table. Think of a form as a GUI for the database. Reports are used to produce formated output from the table, usually for printing.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
News
-
LPI Launches FOSSlife Website
Linux Professional Institute launches FOSSlife, a website for the FOSS community.
-
Tuxedo Computers Joins the Ryzen Bandwagon
Tuxedo Computers has released the Tuxedo Boot BA15 with an AMD Ryzen 3500 CPU.
-
Linux Apps on Windows Is Coming
Linux GUI apps will be coming to Windows Subsystem for Linux.
-
Linux Usage Is on the Rise
According to NetMarketShare, Linux saw a significant bump in usage during April.
-
Lenovo is Jumping on the Linux Laptop Bandwagon
PC and laptop maker Lenovo is set to release ThinkPad laptops pre-installed with Fedora Linux.
-
A New Linux Laptop Is in the Making
Manjaro Linux and TUXEDO computers have joined forces to develop the InfinityBook Manjaro.
-
Ubuntu 20.04 Has Been Released
The latest iteration of the user-friendly Linux distribution is now available.
-
Nextcloud Partners with IONOS
Nextcloud has partnered with Germany’s largest cloud provider, IONOS, to provide a safe haven for your data within the cloud.
-
Linux to Get High Resolution Wheel Scrolling
Work on high resolution wheel scrolling for the Linux desktop is being completed.
-
KDE Developers Are Working on a TV Interface
The developers of the KDE desktop are hard at work to create a TV interface.