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.

Your application indirectly authenticates and connects with your Access database through SQL Server and the OLE DB Provider for Jet database engine.

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.

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