1-866-245-5224 sales@keystonelearning.com

Access 2007: Adding Tables to a Query

Access 2007: Adding Tables to a Query

Although a simple answer, this is one of the most common questions for those new to Access – How do I add a table to an existing query?

Figure 38. Show Table Dialog Box

Adding a Table or Query to an Existing Query

1.       Open the Query in Design View

2.       Click the Show Table command in the Query Setup group on the Query Tools Design Contextual tab

3.       Choose the Table(s)/Query(ies) to add to your query

4.       Click Add

5.       Click Close