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.

The addition of drop-down lists can make your LibreOffice Calc spreadsheets more flexible and powerful. Get instructions on adding them in Calc.