What is the best way to deal with database tables?

Question

PHP

There is an online store database, but there is no access to the database itself, you can only download the file. But you need to make samples according to orders and goods. How better to be? Perform selections and filters through php or through the access database. Perhaps php functions will be needed for a new site in the future, but you will have to remember php again.

Answer 1

1) There is an online store => there must be a web interface for managing goods, groups of goods, etc.
2) It is necessary to make selections for orders and goods.
If you are a developer, then this, in principle, seems logical, but only at the development stage of the administrative part or at the testing stage. Or, if you have a need to unload a certain group of goods, then the developers should provide for this unloading. Again, exclusively from the administrative part of the store.
In general, the question is about nothing. Try to reformulate or supplement it: it's so hard to answer in essence.
Just a bit of philosophy: how do you imagine the development of such a resource without access to the database EVEN at the reading level? If we are talking about an Internet resource, then it is obvious that you will need to work with the database from the server side. The language is not fundamental, but in this case, PHP is simply more convenient due to the size of the community and the proven solutions.

Answer 2

there is no access to the database itself, you can only download the file

Access is the data file, download it for yourself and build queries. And if the database is password-protected, then in Access the password is stored in the file itself in clear text. At least it used to be.