Getting started with LibreOffice Base
|
With Access, Microsoft created a program that hid SQL databases (see the "Relational Databases" box) behind a graphical user interface. With this approach, SQL queries and data entry forms are easily created using mouse clicks without users' having to know anything about programming.
LibreOffice, too, recognized the potential of such software and delivered the Access-like Base (Figure 1) [1] at the end of 2005. Users accustomed to graphical user interfaces could thereby "program" their book or video databases, and smaller companies could analyze their financial data.
Data Storage
The core of the image database is the Images table. It contains a column ("field") for each property of a photo you want to save. Figure 2 suggests seven such data fields.
[...]
Buy this article as PDF
Pages: 6
(incl. VAT)
Buy Ubuntu User
US / Canada
UK / Australia
Related content
-
LibreOffice Base
A database without a search function is like a car without an engine. The second part of our Base series is dedicated to implementing a database search.
-
Managing an Inventory with PartKeepr
Staying on top of stock inventory levels will allow you to plan for capacity and profit. PartKeepr will help you out.
-
Working with SQLiteStudio
SQLiteStudio, a compact graphical tool, lets you complete everyday tasks relating to SQLite databases quickly and easily.
-
Publishing books with LibreOffice, CreateSpace, and KDP
In the past, publishing a book meant sending it to a publishing house. With Amazon's CreateSpace and Kindle Direct Publishing, you can now publish on your own. This article will guide you through the process.
-
Managing personal finance with Grisbi
A program for managing personal finances ought to be as simple and clear as possible. The Grisbi financial manager promises simplicity but doesn't support online banking.