INDEPENDENT SOFTWARE JOURNAL
TrebuchetJOURNAL
EST. 2026 · DIGITAL EDITIONExplore guides
LIBREOFFICE · BASE · HOW-TO GUIDE

LibreOffice Base Tutorial: Your First Small Database

Learn the difference between tables, records, forms and queries before building a small database.

Learn the difference between tables, records, forms and queries before building a small database. This tutorial focuses on a repeatable real-world task you can test on a sample file, not an unverified performance claim. LibreOffice is a desktop office suite; application menus and options may differ by operating system and release.

How to do it: a practical workflow

Work on a copy of your files when learning a new application. The sequence below gives you a testable outcome and a way to verify the result.

  1. Step 1. Define the records you need: for example customers, jobs and payments, with distinct identifiers.
  2. Step 2. Start Base and use the database wizard to create or connect to a database using a supported engine.
  3. Step 3. Create a table with carefully named fields and choose an appropriate type for each column.
  4. Step 4. Add a few sample records, then experiment with a basic form and a query that filters them.
  5. Step 5. Save backups and test restoring data before relying on a database for a real business workflow.

Worked example you can recreate

Try this on a sample file

For an equipment checkout database, keep EquipmentID, ItemName, BorrowerID and ReturnDate. A query can list equipment with no return date. This is a basic example, not an inventory-control system.

Common problems and what to verify

Base setups can depend on a compatible Java runtime or database backend. Follow the current official setup guide for your chosen configuration.

Before handing a document to someone else, open the output in the format that person will use. Check the content and key calculations rather than relying on an export-success notification.

Quick answer

Is Base a drop-in Microsoft Access replacement?

It supports database tasks and connections but is not a guaranteed direct replacement for every Access application.

Official reference and download

These instructions draw on documentation from The Document Foundation. For current user-interface details, refer to the official guide for this topic ↗. Download installation files only from LibreOffice's official download page ↗.

Keep learning

Each of these related guides answers a different task, so you can move from basic setup to a more specific workflow without repeating the same overview.

Independent educational coverage. Trebuchet is not affiliated with or endorsed by The Document Foundation. This article describes documented workflows and illustrative examples; it is not a report of hands-on benchmarking or testing.