MS Access - SQL View

In this chapter, we will be covering the SQL view. Whenever you create a query in query design, Access automatically creates the SQL query for you. This actually retrieves data from the tables. To see how your query is created in sql when you create it in query design, let us open your database.

Select the Query Design from the Create tab and add the tblEmployees table.

Select the field you want to see as query result and then run your query.

You can now see all the employee information as query result. You have selected certain fields in the Query Grid; at the same time, MS Access has also created an SQL Query with the results obtained from your Query Grid.

To view the SQL, go to the Home tab. Select SQL View from the View menu and you will see the SQL of your query.

Example

The following is another example wherein, we will see the projects in progress.

Let us now run your query.

To see the SQL, select the SQL View from the View menu.

You can see the SQL query which is generated by Access automatically. This helps retrieve data from two tables.