The Query Designer Explained

In this post, we will be explaining the constituent parts of the query designer.

 0.1 To open the query designer navigate to the Create Tab of the Ribbon and click on the Query Design icon.  In the image below we can see the query designer for Access 2010. The query designers for Access 2007 and Access 2013 look similar.

 The Query Designer

When a new query designer window is opened you are immediately presented with the Show Table dialog box. Double click any of the tables and they will be added to section 4, the diagram panel.
The Show Table dialog also shows queries which you can include in this new query. Click on the Queries tab and double-click a query; it will be added to diagram panel just like a table.
The second highlighted section is the Query Ribbon. It provides us with a lot of very useful tools including functions, summations, changing the nature of the query and viewing the data the query returns.
Section three is a horizontal list of all the fields used within the query. Literally every field we use, whether it is visible or not, will have a place along this line.
Section four is the Diagram panel; all the entities involved in the query are shown here.

We hope this post has helped you to better understand the query designer.

Related Posts

Using The Like Operator In Queries

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!