If you have a legacy MS Access database or like its GUI, then there are ways to boost its abilities by teaming it up with SQL.

Let’s say you have your WordPress server set up (running on IP address 192.168.1.100) to access a MySQL database named wordpressdb on the MySQL server with user wpadmin.

In the connection dialog: Enter localhost (for a local server) or the name of your MySQL server in the Server field. Enter the Database Name ( I have selected World as my database) Click OK to connect ...

Use the PHP extension for MySQL to access data from the MySQL database.