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.

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 ...

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.

The tool, MySQL Migration Suite, allows schema objects such as tables and views to be automatically migrated from an Oracle or Microsoft Access database to MySQL.

Select a database connection in the "Stored Connection" pull-down list and click the "OK" button. The program prompts you for the database password with a new dialog, "Connect to MySQL Server." ...