The Fine Shirt Company creates and sells shirts to its customers. These customers are retailers who sell shirts to customers. The company has created an Access database file P4_22.MDB that has information on sales to its customers over the past five years (i.e., from 1995 through 1999). There are three related tables in this database: Customers, Orders, and Products. These tables are described in detail in Example 4.3. Find all of the records from the Orders table where the order was placed in 1998 or 1999, the product number is 1 or 10, the customer number is not 7, and the number of units ordered is at least 75. Return to Excel all fields in the Orders table for each of these records.

Example 4.3.

The Fine Shirt Company would like to break down revenue from its various customers and products by using pivot tables. How should it proceed?