1. WasteNot Recycling WasteNott Recycling pick up recyclables from homeowners in Boulder, Colorado. Neighborhoods subscribe to the service so that pickup is cost-effective. WasteNot provides special containers to subscribers for sorting recyclables: a blue container for paper products and a purple container for aluminum, plastic, and glass products. Subscribers place their recycling containers on the curb for biweekly pickup. Each recycling container is weighed before being emptied. WasteNot drivers carry handheld recording devices used to track each pickup. Subscribers receive quarterly profit-sharing checks based on their contributions. If WasteNot does not make a profit, subscribers are not paid for their recyclables. If WasteNot makes a profit, subscribers share in that profit. WasteNot has asked you to help develop a relational database that will effectively track subscribers, using the data downloaded from the drivers devices. WasteNot has provided you with a snapshot of two tables you need to create. The Customer table shown here holds static customer information such as name, address, and phone. The Customer Record table holds data about each recyclable pickup. Specifically, WasteNot needs you to:

1. Create a Microsoft Access database. 2. Create the tables, fields, data types, and primary key(s) for the database. 3. Create the relationship(s) needed between the tables. 4. Populate the database with the data provided above.

Customer ID Last Name First Name ZIP Code First Pickup Street City State Phone 80308 5480 Alpine Street WagonerSam Boulder CO 8 (303) 161- 05/25/2004 5545 Calahan Eliza Boulder CO 80308(303) 886 05/25/2004 2140 Edgewood Avenue 6003 Lake James 701 Eastman Boulder CO 80308 (303) 562- 08/25/2005 Road 499 Meadows Sar Boulder CO 80308(303) 792 02/28/2004 80308 (303) 838 06/02/2004 80308(303) 352 07/17/2005 80308 (303) 555 05/19/2005 80308(303) 815 12/28/2004 Pond Hill Drive 3646 20 Smith Alto 114 Lexington Boulder CO Street 431 Phillips Lane 1935 Snovw 64 Monarch Shiela Boulder CO 4847 65 Guo Amy Boulder CO Avenue 6731 80 Rivera Juan 482 Weston Boulder CO Avenue 2456 85 Williams Max 230 Southpark Boulder CO 80308 (303) 333- 07/19/2003 Circle Customer ID Last Name First Name ZIP Code First Pickup Street City State Phone 80308 5480 Alpine Street WagonerSam Boulder CO 8 (303) 161- 05/25/2004 5545 Calahan Eliza Boulder CO 80308(303) 886 05/25/2004 2140 Edgewood Avenue 6003 Lake James 701 Eastman Boulder CO 80308 (303) 562- 08/25/2005 Road 499 Meadows Sar Boulder CO 80308(303) 792 02/28/2004 80308 (303) 838 06/02/2004 80308(303) 352 07/17/2005 80308 (303) 555 05/19/2005 80308(303) 815 12/28/2004 Pond Hill Drive 3646 20 Smith Alto 114 Lexington Boulder CO Street 431 Phillips Lane 1935 Snovw 64 Monarch Shiela Boulder CO 4847 65 Guo Amy Boulder CO Avenue 6731 80 Rivera Juan 482 Weston Boulder CO Avenue 2456 85 Williams Max 230 Southpark Boulder CO 80308 (303) 333- 07/19/2003 Circle