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
-
Linux Can Now Run on Apple’s M1 Chipset
Linux users looking to take advantage of Apple Silicon are about to get their wish with the M1 chipset.
-
MX Linux 21 RC Candidate Available For Testing
The MX Linux development team has released the RC images for MX Linux 21 for testing purposes.
-
Fedora 35 is Shaping Up to Be an Impressive Release
Although the beta version of Fedora’s upcoming release is behind schedule, the Linux distribution is still slotted for October and will include numerous bug fixes and some exciting new features.
-
Canonical Extends Support For Ubuntu 14.04 and 16.04
The company behind Ubuntu offered a much-needed lifeline to those who still depend on older versions of the open-source operating system.
-
GNOME 41 Has Arrived
The latest version of the GNOME desktop environment has been released with new functionality and plenty of improvements.
-
System76 Updates the 15" Pangolin with Ryzen
System76 announced they’re updating the Ryzen-powered Pangolin laptop to meet today’s need for more power.
-
KDE Plasma 5.23 Promises Plenty of Subtle Improvements
The next release of the KDE Plasma desktop includes new features, numerous improvements, and plenty of bug fixes.
-
GNOME 41 Beta is Now Available
The most popular open-source desktop environment is on the cusp of yet another new release, but don’t expect the massive changes found in the previous iteration.
-
Debian 11 “Bullseye” Now Available
The developers of Debian have released the latest version of the operating system so many distributions depend on.
-
Elementary OS 6 Odin Now Available
The developers of elementary OS have released their latest iteration which is all-in on Flatpaks and all about the user experience.