Queries in LibreOffice Base compared to MS Access

Many of the ‘action’ queries that we are going to look at in this section differ in the way that they are executed between MS Access and LibreOffice Base.

Queries that directly update, add to, append or delete records in a table can be done without using SQL code in MS Access, by using certain tools.

However, in Base there are no available tools, so we have to use some basic SQL commands.

SQL may seem confusing at first, but is actually very straightforward and intuitive when you get used to it. We will talk you through how each SQL statement works and you can use the glossary as a reference too.