How to Write SQL Query in MS Access

‍

‍

Here's how to do it step by step:

‍

1. Open an existing query, right click the query and select 'SQL View'.
2. Start entering your query in the field.
3. Once you have entered your query, click 'Run' to see the results.