Using the Query Design Window
Queries can be easily constructed in Access by using the Query Design window. This
provides a GUI that allows the user to easily build a query on several tables. To use the Query
Design window, click Create in the Access menu and then click the Query Design icon in the
Macros & Code group of the ribbon. You will then see the window shown in Figure 12-1.
In the pop-up window called Show Table, click the tables and queries you want to use and
then click the Add button. Click the Close button when complete. You can return to this
window to add more tables or queries by right-clicking in the Query Design window and
clicking Show Table.
Select the Customers and the Orders tables only.
The tables you have selected will be shown graphically in the Query Design window,
listing all the fields available in each table. You can drag the tables around the window to
reposition them for easy viewing.
Access will also try to link the tables together for you, although this does not always work.
Do not rely on Access to do this for you since it can be wrong sometimes.150 Microsoft Access 2010 VBA Macro Programming
Figure 12-1 The Query Design window on opening