1. Open the “Plant” database in the labs folder of my instructor folder.
2. Create a relationship between the Customer and Worker tables.
   Make sure you Enforce Referential Integrity.
   (Note: The relationship will already have been created in the database used for your test).
3. Add a new customer to the customer table:
   Customer Number:               LM57
   Customer Last name:          Mayer
   Customer First name:           Lynne
   Street:                              1700 Spartan Drive
   City:                                  Elgin
   Telephone Number:              697-1000
   Balance:                             $50
   Amount Paid:                     $175
   Worker Number:                 205
   Close the table to save the changes.
4. Create a report using the Report Wizard (found on the Create ribbon)
   with the following fields (and in the following order):
   Customer First name
   Customer Last name
   Customer Telephone Number
   Customer Balance
   Worker First name
   Worker Last name
   Worker Hourly Rate
5. View by Worker
6. No Grouping
7. Sort Ascending on Balance
8. Use a Stepped layout in Landscape Orientation
9. Title the report “Balances Due”
10. Make sure nothing is cut off and the report is easy to read.
    You may need to go into design view and adjust field width or alignment.
11. Add your name to the report footer using the label tool.

Extra Credit: Create a query for customers with balances >0 using the same fields listed in step 4 above. Create a report with the same requirements as the report  above, but create the report from the query instead of the tables.

lmayer@elgin.edu