Most people who use Microsoft office Access do not realize you can write most SQL queries in Access in order to query the Access data base. It is not straight forward so unless you know it was possible and knew the steps in how to do so, it is unlikely you would have discovered how by accident.
Access is part of Microsoft Office Suite. It is a lightweight database that is design for small business as well as home users. Sometimes it is easier to use a SQL query to find the fields in the database you are looking for. Fortunately Microsoft Access has that capability.
Open you access database and select Queries in the Object column. Then double click 'Create Query In design View'. Close the 'Show Table box that come up on top of the query window.
On the Tool bar, a SQL button with a down arrow appears in bold. When you press this button, the SQL query comes up and you are able to write your SQL query. To use the query, save as then select the name to save it. To run the query, simply double click the query with the name you chose for it. When you have any query open, you can select the type of query (Design view, datasheet view, SQL view, Pivot table view, or Pivot chart view) using the button on the left of the toolbar as you did when you chose SQL query.