After creating the tables and relationships for the Antiques database, you meet with Tim Richards,..

After creating the tables and relationships for the Antiques
database, you meet with Tim Richards, the chief information officer for the NHD
Development Group, and Linda Sutherland, the manager of the antique mall. As
you review the database, Linda makes a few requests. When she tracked sales for
a month, she found that repeat customers accounted for 60% of her revenue. She
therefore wants to use the Antiques database to increase marketing efforts to
her current customer base. First, she wants to extract information about her
customers, such as a list that organizes customers by city and
»

After creating the tables and relationships for the Antiques
database, you meet with Tim Richards, the chief information officer for the NHD
Development Group, and Linda Sutherland, the manager of the antique mall. As
you review the database, Linda makes a few requests. When she tracked sales for
a month, she found that repeat customers accounted for 60% of her revenue. She
therefore wants to use the Antiques database to increase marketing efforts to
her current customer base. First, she wants to extract information about her
customers, such as a list that organizes customers by city and another that
provides customer names and phone numbers. She also needs to retrieve
information about the antique and restoration classes the mall offers to
determine which customers enroll in the classes. Then she could provide
information in the classes about items that might interest those customers. She
asks for your help filtering data and creating queries that extract the
information she needs.

Complete the following:

Linda also needs a list of classes that she can use in the
mall when customers and others inquire about the classes. When people call for
information about the classes, they often want to know when the classes will be
held. Linda also wants to use this list to call enrollees in case of a
cancellation. Linda considers a person officially enrolled only when they have
paid for the class.

a. Create a list that includes the class ID and other
information that callers want to know about the classes. Test your results.

b. Modify the list so that it also includes information
Linda needs to call customers and determine whether a customer is enrolled in a
class. To help her find the information she needs, sort the list first by class
and then by whether the customer has paid.

c. Save the query as qryClassListing.

»