Question: please help on create the quareys ups RE Customer Information - + + + + Customel - Last Nar , First Nal 1 Wagoner Sam

please help on create the quareys ups RE Customer

please help on create the quareys ups RE Customer

please help on create the quareys ups RE Customerplease help on create the quareys

ups RE Customer Information - + + + + Customel - Last Nar , First Nal 1 Wagoner Sam 2 Calahan Eliza 3 Lake James 4 Meadows Sara 20 Smith Alto 64 Monarch Shiela 65 Guo Amy 80 Rivera Juan 85 Williams Max 0 Street City 5480 Alpine Street Boulder 2140 Edgewood Ave Boulder 701 Eastman Road Boulder Pond Hill Drive Boulder 114 Lexington Street Boulder 431 Phillips Lane Boulder 1935 Snow Ave Boulder 482 Weston Ave Boulder 230 Southpark Circle Boulder Sta CO CO CO CO CO CO ZipCoc - 80308 80308 80308 80308 80308 80308 80308 80308 80308 Phone (303) 161-5545 (303) 886-6003 (303) 562-4499 (303) 792-3646 (303) 838-7111 (303) 352-4847 (303) 555-6731 (303) 815-2456 (303) 333-0000 FirstPickup Click to Add 05/25/2004 05/25/2004 08/25/2005 02/28/2004 06/02/2004 07/17/2005 05/19/2005 12/28/2004 07/19/2003 + + + + + * T 32 85 12 43 8 15 19 0 28 174 8 Custo - Srvc Date - Weight Pape - Weight Othe. Click to Add 1 10/15/2006 1 11/7/2006 1 11/22/2006 2 11/7/2006 2 11/22/2006 3 10/15/2006 3 11/22/2006 3 12/4/2006 20 10/15/2006 20 11/22/2006 80 10/15/2006 80 11/7/2006 13 80 11/22/2006 18 80 12/4/2006 16 32 7 12 18 40 35 60 10 10 9 16 18 21 0 0 Waste Recycling (WR) is an organization that picks up recyclables from homeowners in Boulder, Colorado. The Customer Information table holds static customer information such as name, address, and phone. The Pickup Records table holds data about each recyclable pickup. Enough test data have been added to each table to test queries (use the WR.accdb file associated with this text). The owners of Waste Recycling have asked you to assist with creating several queries. Specifically, they need you to do the following: 1. Create a query using the Customer Information data that will select records for customers who had their first pickup in May 2004. Sort the records by customer's Last Name. Save the query as May Pickup Query 2. Create a query on Pickup Records and Customer Information to determine the total weights of paper and other products each customer has had picked up. Use the CUSTOMER Last Name and First Name in the query. Save the query as Customer Weight Query 3. Create a query using the Name, Street, Address, and Weight fields from the Pickup Records and Customer Information tables. Enter the criteria that will select customers with less than 10 pounds in either recyclable field. Save the query as Low Volume Query munt houn oblo honoun it onnnnt ha anonod

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!