LibreOffice contains a very powerful database tool that is actually quite user friendly. Here's how to create a database query using the Design View tool.

You also have the option here to view the new query immediately, or else open it in Design View to add more advanced touches that are beyond the capacity of the wizard. Using Queries In order to ...

The Query Design: Create a new blank query in Design View. You can use the Show Table dialog box to add queries and tables to the Query Design. What are the Advantages of using a Query?