 |
 |
 |
 |
 |
Use the database created in the previous exercise to generate the following reports:
- A mailing list for all of the customers. Include the customer’s first and last names, address, city, state and zip. Optional: create mailing labels for all of the customers.
- A list of customers with the paintings they bought. (You will need to create a relationship first). Include customer’s first and last names and the names of the paintings.
- An inventory list that includes the painting name, size, media and customer name, if sold.
- A list of unsold paintings only. Include all of the fields from the previous report, except customer name. You will need to do a query first.
- A list of customers from out of state (not from Illinois). You will need to do a query first.