How does Access query SQL view switch?

There are not many sentences in a simple SQL language, but many names of various tables, queries, and fields are required in the application process. In this way, when you set up a query that involves a lot of fields, you need to input a lot of text. It is much more time consuming to establish a query than to use the query planning view. Therefore, when I set up a query, the query planning view will be fundamental.

There are not many sentences in a simple SQL language, but many names of various tables, queries, and fields are required in the application process. In this way, when you set up a query that involves a lot of fields, you need to input a lot of text. It is much more time consuming to establish a query than to use the query planning view. Therefore, when I set up a query, the query planning view will be fundamental.

There are not many sentences in a simple SQL language, but many names of various tables, queries, and fields are required in the application process. In this way, when you set up a query that involves a lot of fields, you need to input a lot of text. It is much more time consuming to establish a query than to use the query planning view.

So when I set up a query, I first completed all the basic query functions in the query planning view, and finally switched to the SQL view to complete some special queries after writing SQL sentences. Next we will introduce some SQL languages that are often used in ACCESS.

We have said that you can switch to the SQL view when creating a query. Let's take a look at how to switch:

After you open a query, When you click the "New Method" list, there is no "create query using SQL View" option,

This also indicates that ACCESS does not advocate the use of the SQL language at work, then we click "create query in design view", and a design view will appear on the screen,

To switch to the SQL view, move the cursor to the "View" option button on the far left of the toolbar.

Click the down button on the right and select "SQL design view" from the drop-down menu to switch the view to the SQL status.