Hopelessly lost trying to create a database/table

I’m trying to create a database/table of DnD creatures that will display creatures with a particular quality (such as forest or level 1 or natural) once I click on or enter into search together. So, I would have the name in column one, its habitat (forest, mountain, desert, etc) in column two, its level in column three, and so on. Then when I click on or search for a particular quality, say desert, it will display all creatures with that quality.
Which program will I need and can someone point me to the relevant documentation on how to do so, please?

Base is the right component for databases, but your simple table could also be done in Calc with Autofilter.

For reasons unknown to me the guide for Base is currently not listed directly on the place I usually recomended (LibreOffice.org See menu “Get help > Documentstion” but you can find there at the end a link to the following wiki page.

https://wiki.documentfoundation.org/Documentation/Publications

1 Like

Thank you… I’ll check that and see if it will do what I need.

It’s because the version of this Guide is a little bit older. But the Guide isn’t outdated. Seems someone decided better to show all new versions directly and the older versions will need a separate link …

1 Like

This worked perfectly. I found the way to do it and have been tediously entering in data into a Base table. I can sort for any characteristic I want then revert to alphabetical order easily.

Please be aware that real DBs distribute data between tables.
So it could be a table for “habitats”;
another for “levels”…
But of course if 1 table suits your need, fine.