Database Reference
In-Depth Information
EXAMPLE 18
57
Create a new table containing the customer number and customer name, and the number, first name, and
last name of the customer's sales rep. Name the new table CustomerRep.
Figure 2-37 shows the query design to select records from the Customer and Rep tables.
Fields from
the Customer
table
Fields from
the Rep table
FIGURE 2-37
Make-table query design
After you create and test the query to make sure it selects the correct records, change the query type to
a make-table query by clicking the Make Table button in the Query Type group on the Query Tools Design
tab. In the Make Table dialog box that opens, enter the new table
'
s name and choose where to create it, as
shown in Figure 2-38.
