What is database access?
MODX, along with many other CMS uses files that are installed on your web server and a database which stores much of the information necessary to make the site work. The database is usually where the content you add to your web site is stored. so when you use the MODX manager you are actually interacting with the database.
It is possible, and necessary when developing a site, to access the database directly without going into the MODX manager at all. This can be done using a web application called phpMyAdmin, if it is installed on your web hosting environment. It can also be accessed by typing instructions into 'the command line'. You can read more about this here:
https://dev.mysql.com/doc/mysql-getting-started/en/.
In order to get their job done your website developer is likely to have access to all the information they would need to access the database. They can be blocked, but this would normally be done in an environment where a system administrator would give them the necessary permissions. I suspect, from what you say, that you would not be able to do this. So I think you have to trust them. If you do ever fall out with them make sure you hire another developer quickly who can change all the necessary user names, passwords and permissions in order to deny them access. Although this may be easier said than done!