The features you gain from using a database make this a Access hand down winner.
However, mysql/mariadb might be an even better choice long term.
You will eventually need to learn SQL, but know it will make life so much easier.
A database can be connected to via ODBC in many different programming languages. Therefore you can use one of a dozen (probably ...
It rather depends on the nature of the PDF files - some contain the text while others contain images of the text. In the former case pdfminer3 can do an excellent job. In the latter case you will need to perform OCR (Optical Character Recognition) on the images which is almost always an uncertain proposition.