MS Access Queries can be switched to SQL View: this will allow you to type
and execute SQL statements. It might be a good place to start.

If your database is SQL Server, you can use Query Analyser; for Oracle use
SQL*PLUS. These are already written SQL front ends.

It is fairly easy to write your own SQL front end: however, you said that
you do not know VBA and that makes it difficult.