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.