Microsoft Access Projects

profilestvrueg
chapter_19.zip

Chapter 19/Chapter/Panels.jpg

Chapter 19/Chapter/Solar19.accdb

ContractID CustomerID ContractValue DateSigned
1301-KS 1 ¤ 500.00 2/9/13
1302-KS 1 ¤ 14,000.00 3/3/13
1303-MP 16 ¤ 1,150.00 3/16/13
1304-MP 22 ¤ 1,200.00 4/10/13
1305-KF 3 ¤ 805.00 4/22/13
1306-MP 23 ¤ 1,100.00 4/29/13
1307-MP 34 ¤ 68,000.00 7/7/13
1308-RR 5 ¤ 620.00 7/7/13
1309-KF 32 ¤ 650.00 7/23/13
1310-KS 32 ¤ 14,000.00 7/30/13
1311-RR 25 ¤ 800.00 8/9/13
1312-KF 11 ¤ 450.00 8/16/13
1313-MP 16 ¤ 89,000.00 8/26/13
1314-KS 26 ¤ 25,500.00 9/3/13
1315-KF 24 ¤ 25,000.00 9/4/13
1316-RR 17 ¤ 550.00 9/11/13
1317-RR 5 ¤ 16,500.00 9/17/13
1318-MP 2 ¤ 690.00 9/30/13
1319-RR 30 ¤ 1,200.00 10/8/13
1320-RR 25 ¤ 32,500.00 10/15/13
1321-KF 11 ¤ 15,500.00 10/15/13
1322-KF 3 ¤ 18,000.00 10/20/13
1323-RR 25 ¤ 39,000.00 11/7/13
1401-KF 28 ¤ 30,800.00 1/12/14
1402-KS 34 ¤ 34,000.00 1/16/14
1403-MP 2 ¤ 20,000.00 1/26/14
1404-RR 25 ¤ 138,000.00 2/18/14
1405-RR 17 ¤ 14,500.00 2/22/14
1406-KF 21 ¤ 15,750.00 3/11/14
1407-KF 31 ¤ 550.00 3/26/14
1408-MP 28 ¤ 165,000.00 3/26/14
1409-KS 20 ¤ 1,000.00 4/8/14
1410-RR 29 ¤ 900.00 4/23/14
1411-MP 9 ¤ 16,500.00 4/23/14
1412-AD 31 ¤ 37,000.00 4/29/14
1413-RR 10 ¤ 22,800.00 4/29/14
1414-AD 19 ¤ 700.00 5/4/14
1415-KS 20 ¤ 23,750.00 5/10/14
1416-AD 15 ¤ 205,000.00 5/20/14
1417-MP 12 ¤ 1,150.00 6/1/14
1418-RR 31 ¤ 46,000.00 6/4/14
1419-KS 13 ¤ 575.00 6/12/14
1420-AD 19 ¤ 18,500.00 6/12/14
1421-KS 6 ¤ 25,500.00 6/29/14
1422-MP 14 ¤ 14,500.00 7/14/14
1423-RR 27 ¤ 37,250.00 7/26/14
1424-MP 18 ¤ 35,000.00 7/30/14
1425-KS 4 ¤ 6,500.00 8/9/14
1426-RR 8 ¤ 15,000.00 8/10/14
1427-AD 13 ¤ 38,500.00 8/11/14
1428-AD 25 ¤ 50,000.00 8/17/14
1429-MP 7 ¤ 875.00 8/23/14
1430-AD 25 ¤ 41,000.00 9/2/14
1431-AD 33 ¤ 132,000.00 9/9/14
CustomerID LastName FirstName Company Street City State Zip Phone Email
1 Tam Dennis 2930 Duck Creek Road Palo Alto CA 94306 650-555-3132 [email protected]
2 Derrick Barbara 2071 Clifford Street Oakland CA 94612 510-555-5217 [email protected]
3 Sharma Sumiko 53 Wolf Pen Road Redwood City CA 94063 650-555-6578 [email protected]
4 Stanwood Misti Brisbane Engineering Dept. 4118 Straite Road Brisbane CA 94005 650-555-6869 [email protected]
5 Faries Leopold 438 Boring Lane Dublin CA 94568 415-555-7870 [email protected]
6 Schumer Bradley 2547 Hillview Drive San Francisco CA 94103 707-555-0613 [email protected]
7 Grady Yvette San Rafael Medical Partners 4287 Roosevelt Street San Rafael CA 94903 415-555-2591 [email protected]
8 Colberg Chung 1626 Fairway Drive Oakland CA 94612 707-555-3001 [email protected]
9 Selin Xenia Jack's Café 1675 Meadow Lane Oakland CA 94612 707-555-2064 [email protected]
10 Kennison Pamela Pleasanton Waldorf School 2646 Park Street Pleasanton CA 94588 925-555-1913 [email protected]
11 Christofferson Khali 3348 Delaware Avenue San Francisco CA 94124 415-555-7074 [email protected]
12 Tedeschi Anthony M. Doufay Financial 981 Fairway Drive Concord CA 94520 707-555-4193 [email protected]
13 Miga Manda Oak Roots Development 1505 Thunder Road Oakland CA 94612 650-555-0084 [email protected]
14 Walker Frank 3722 Davis Avenue Fremont CA 94539 707-555-5274 [email protected]
15 Stille Tamara Prentice College 2793 Wayside Lane Oakland CA 94612 510-555-7478 [email protected]
16 Ferebee Julianne Oakland Neighborhood Development 3033 Beech Street Oakland CA 94612 925-555-6240 [email protected]
17 Lemaire Alexa 2916 Friendship Lane Oakland CA 94612 408-555-0092 [email protected]
18 Borgmeyer Emerita 4430 Marietta Street Rohnert Park CA 94928 707-555-4074 [email protected]
19 Doten Al 4591 Haverford Road San Carlos CA 94070 650-555-6517 [email protected]
20 Hartt Cecille Sauerbrook & Mars Fashions 3144 Ringland Lane San Francisco CA 94110 415-555-2691 [email protected]
21 Arter Kathleen Prancing Pony Grill 3118 Roosevelt Street San Francisco CA 94108 415-555-4887 [email protected]
22 Wilcox Jennifer Swan Senior Living Center 494 Friendship Lane Oakland CA 94607 408-555-9912 [email protected]
23 Fry Juanita Bay Area Communities United 535 Locust View Drive San Francisco CA 94105 415-555-8025 [email protected]
24 Hearns Raymond 2565 Beech Street Oakland CA 94607 925-555-6543 [email protected]
25 Frevert Krystle LKW Construction 4457 Water Street Palo Alto CA 94301 650-555-3470 [email protected]
26 Puig Jacob Liehe Contracting 4169 Clifford Street Oakland CA 94612 510-555-6733 [email protected]
27 Gallivan Melanie Happy Skies Day Care 4997 Park Street Pleasanton CA 94566 925-555-8069 [email protected]
28 Marcell Angela Greenleaf Builders 464 Wolf Pen Road Concord CA 94520 650-555-9985 [email protected]
29 Neyhart Maryann Duschesne Investment Corp. 3641 Black Oak Hollow Road Sunnyvale CA 94089 408-555-1707 [email protected]
30 Ansari Janelle Watering Hole Mini Golf 791 Brown Street Walnut Creek CA 94596 925-555-9101 [email protected]
31 Bruneau Latasha Sierra Nevada Contracting 3768 Delaware Avenue San Francisco CA 94115 415-555-4969 [email protected]
32 Klinkhammer Annalisa 4575 Wounterman Road Dublin CA 94568 650-555-3803 [email protected]
33 Yamada Sachiko Yamada Architects, Inc. 1185 Park Avenue Sacramento CA 94260 916-555-3776 [email protected]
34 Chen Ralph Chen Builders 18 Market Street Oakland CA 94612 415-555-9370 [email protected]
InvNum ContractID InvDate Amount Paid
1302-001 1301-KS 2/18/13 ¤ 500.00 true
1304-002 1303-MP 4/1/13 ¤ 1,150.00 true
1304-003 1304-MP 4/29/13 ¤ 1,200.00 true
1305-004 1302-KS 5/10/13 ¤ 12,500.00 true
1305-005 1306-MP 5/15/13 ¤ 1,100.00 true
1305-006 1305-KF 5/30/13 ¤ 800.00 true
1306-007 1302-KS 6/9/13 ¤ 1,500.00 true
1307-008 1307-MP 7/7/13 ¤ 13,600.00 true
1307-009 1308-RR 7/15/13 ¤ 620.00 true
1307-010 1309-KF 7/23/13 ¤ 650.00 true
1308-011 1310-KS 8/15/13 ¤ 2,800.00 true
1308-012 1312-KF 8/28/13 ¤ 450.00 true
1308-013 1311-RR 8/29/13 ¤ 800.00 true
1309-014 1314-KS 9/15/13 ¤ 5,100.00 true
1309-015 1315-KF 9/15/13 ¤ 2,500.00 true
1309-016 1313-MP 9/29/13 ¤ 17,800.00 true
1309-017 1316-RR 9/29/13 ¤ 550.00 true
1310-018 1318-MP 10/15/13 ¤ 690.00 true
1310-019 1317-RR 10/15/13 ¤ 3,500.00 true
1310-020 1319-RR 10/15/13 ¤ 1,200.00 true
1311-021 1321-KF 11/12/13 ¤ 8,500.00 true
1311-022 1320-RR 11/15/13 ¤ 6,500.00 true
1311-023 1323-RR 11/15/13 ¤ 7,800.00 true
1311-024 1314-KS 11/15/13 ¤ 20,400.00 true
1311-025 1315-KF 11/15/13 ¤ 22,500.00 true
1311-026 1313-MP 11/29/13 ¤ 45,600.00 true
1312-027 1323-RR 12/15/13 ¤ 12,480.00 true
1312-028 1322-KF 12/21/13 ¤ 15,000.00 false
1312-029 1317-RR 12/23/13 ¤ 8,000.00 true
1312-030 1320-RR 12/29/13 ¤ 13,000.00 true
1401-001 1321-KF 1/12/14 ¤ 7,000.00 true
1401-002 1323-RR 1/15/14 ¤ 18,720.00 true
1401-003 1313-MP 1/29/14 ¤ 25,600.00 true
1401-004 1320-RR 1/29/14 ¤ 8,500.00 true
1401-005 1401-KF 1/29/14 ¤ 6,160.00 true
1401-006 1322-KF 1/31/14 ¤ 3,000.00 false
1402-007 1317-RR 2/12/14 ¤ 5,000.00 true
1402-008 1320-RR 2/14/14 ¤ 4,500.00 true
1402-009 1401-KF 2/14/14 ¤ 24,640.00 true
1402-010 1404-RR 2/28/14 ¤ 18,000.00 true
1403-011 1403-MP 3/15/14 ¤ 13,000.00 true
1403-012 1406-KF 3/29/14 ¤ 4,725.00 true
1403-013 1405-RR 3/29/14 ¤ 6,500.00 true
1404-014 1407-KF 4/14/14 ¤ 550.00 true
1404-015 1408-MP 4/14/14 ¤ 33,000.00 true
1404-016 1409-KS 4/15/14 ¤ 1,000.00 true
1404-017 1404-RR 4/28/14 ¤ 120,000.00 true
1405-018 1403-MP 5/1/14 ¤ 7,000.00 true
1405-019 1408-MP 5/14/14 ¤ 26,400.00 true
1405-020 1412-AD 5/15/14 ¤ 7,400.00 true
1405-021 1410-RR 5/15/14 ¤ 900.00 true
1405-022 1414-AD 5/15/14 ¤ 700.00 true
1405-023 1405-RR 5/15/14 ¤ 8,000.00 true
1405-024 1406-KF 5/29/14 ¤ 9,025.00 true
1405-025 1415-KS 5/29/14 ¤ 10,000.00 true
1405-026 1413-RR 5/29/14 ¤ 12,400.00 true
1406-027 1418-RR 6/4/14 ¤ 9,200.00 true
1406-028 1416-AD 6/12/14 ¤ 41,000.00 true
1406-029 1417-MP 6/12/14 ¤ 1,150.00 false
1406-030 1408-MP 6/14/14 ¤ 26,400.00 true
1406-031 1412-AD 6/15/14 ¤ 20,000.00 true
1406-032 1406-KF 6/29/14 ¤ 2,000.00 true
1406-033 1415-KS 6/29/14 ¤ 13,750.00 true
1406-034 1420-AD 6/29/14 ¤ 8,000.00 true
1406-035 1419-KS 6/29/14 ¤ 575.00 true
1407-036 1413-RR 7/12/14 ¤ 4,500.00 true
1407-037 1416-AD 7/12/14 ¤ 10,000.00 true
1407-038 1408-MP 7/14/14 ¤ 50,000.00 true
1407-039 1422-MP 7/14/14 ¤ 4,100.00 true
1407-040 1412-AD 7/15/14 ¤ 9,600.00 true
1407-041 1418-RR 7/15/14 ¤ 6,500.00 true
1407-042 1411-MP 7/23/14 ¤ 16,500.00 true
1408-043 1421-KS 8/12/14 ¤ 4,500.00 true
1408-044 1416-AD 8/12/14 ¤ 8,500.00 true
1408-045 1424-MP 8/12/14 ¤ 7,000.00 true
1408-046 1413-RR 8/12/14 ¤ 3,000.00 true
1408-047 1408-MP 8/14/14 ¤ 29,200.00 true
1408-048 1418-RR 8/15/14 ¤ 6,000.00 true
1408-049 1420-AD 8/15/14 ¤ 10,500.00 true
1408-050 1423-RR 8/15/14 ¤ 18,625.00 true
1408-051 1307-MP 8/15/14 ¤ 25,750.00 true
1408-052 1428-AD 8/29/14 ¤ 15,000.00 true
1409-053 1422-MP 9/1/14 ¤ 2,900.00 true
1409-054 1431-AD 9/9/14 ¤ 60,000.00 true
1409-055 1426-RR 9/12/14 ¤ 9,000.00 true
1409-056 1429-MP 9/12/14 ¤ 875.00 false
1409-057 1421-KS 9/12/14 ¤ 3,000.00 true
1409-058 1416-AD 9/12/14 ¤ 14,200.00 true
1409-059 1423-RR 9/15/14 ¤ 9,000.00 true
1409-060 1307-MP 9/15/14 ¤ 14,325.00 true
1409-061 1310-KS 9/15/14 ¤ 6,200.00 true
1409-062 1413-RR 9/29/14 ¤ 2,900.00 true
1409-063 1430-AD 9/29/14 ¤ 8,200.00 true
1409-064 1424-MP 9/29/14 ¤ 8,500.00 true
1410-065 1425-KS 10/10/14 ¤ 6,500.00 false
1410-066 1421-KS 10/12/14 ¤ 12,000.00 true
1410-067 1422-MP 10/12/14 ¤ 7,500.00 false
1410-068 1426-RR 10/12/14 ¤ 4,000.00 true
1410-069 1416-AD 10/12/14 ¤ 43,600.00 true
1410-070 1423-RR 10/14/14 ¤ 9,625.00 true
1410-071 1418-RR 10/14/14 ¤ 21,000.00 true
1410-072 1431-AD 10/14/14 ¤ 68,000.00 true
1410-073 1310-KS 10/15/14 ¤ 5,000.00 true
1410-074 1424-MP 10/29/14 ¤ 10,000.00 true
1410-075 1428-AD 10/29/14 ¤ 17,500.00 true
1411-076 1416-AD 11/12/14 ¤ 29,500.00 false
1411-077 1426-RR 11/12/14 ¤ 2,000.00 false
1411-078 1418-RR 11/14/14 ¤ 9,800.00 false
1411-079 1431-AD 11/14/14 ¤ 4,000.00 false
1411-080 1307-MP 11/29/14 ¤ 14,325.00 false
1411-081 1430-AD 11/29/14 ¤ 32,800.00 false
1411-082 1428-AD 11/29/14 ¤ 17,500.00 false
1411-083 1424-MP 11/29/14 ¤ 9,500.00 false
1412-084 1416-AD 12/12/14 ¤ 37,500.00 false
1412-085 1421-KS 12/12/14 ¤ 6,000.00 true

Chapter 19/On Your Own/CharityLogo.png

Chapter 19/On Your Own/Contacts19.accdb

ContactID ContactFirst ContactLast Address City State Zip Phone
201 Edwin Morales 2315 Philadelphia Avenue Murray UT 84107 801-966-0454
202 Leo Wessel 2195 Scattershot Way Salt Lake City UT 84111 801-869-3378
203 Leonard Black 784 Philadelphia Avenue Salt Lake City UT 84104 801-474-8135
205 Thomas Friedel 4880 Tori Lane Salt Lake City UT 84116 801-573-3401
206 William Tsan 2204 Buck Drive Salt Lake City UT 84111 801-490-1641
209 Robert Pharr 595 Pignole Drive West Valley City UT 84119 801-483-3559
210 Tina Allen 1950 Kemper Lane Salt Lake City UT 84116 801-981-0593
211 Alice Cox 4879 Tori Lane Salt Lake City UT 84113 801-733-7017
212 Arthur Miller 3613 Hickory Street Salt Lake City UT 84104 801-450-9220
215 Sarah Robinson 4411 Walton Street Salt Lake City UT 84104 801-274-0595
216 Thomas Mathis 2299 White River Way Salt Lake City UT 84111 801-570-0381
217 Lois Augustine 1979 Thrice Way Salt Lake City UT 84106 801-488-3255
220 Kevin Smith 3291 Kemper Lane Murray UT 84107 801-449-9225
221 Tracy Kemp 3651 Plympton Lane Kearns UT 84118 801-440-5209
222 Cora Velez 510 Walton Street Salt Lake City UT 84104 801-534-1420
225 Angel Pinto 2983 Stringfeld Way Salt Lake City UT 84111 435-728-5245
228 John Pittman 4132 Hickory Street Salt Lake City UT 84104 435-538-4925
229 Michelle Frey 242 Sweetwater Drive Salt Lake City UT 84111 801-584-3146
230 Dan Eason 1439 Tempest Avenue Salt Lake City UT 84116 801-795-7666
RoomID RoomName BuildingName Campus DailyRate SeatingCapacity DiningCapacity RoomType Description
3002 Adams 100 Adams Hall Main ¤ 800.00 150 70 Meeting Large windows, tall ceilings, can be combined with Adams 101
3003 Adams 101 Adams Hall Main ¤ 875.00 150 70 Meeting Large windows, tall ceilings, can be combined with Adams 100
3007 Adams 200 Adams Hall Main ¤ 1,200.00 200 90 Meeting Large windows, tall ceilings, can be combined with Adams 201
3010 Adams 201 Adams Hall Main ¤ 1,200.00 200 90 Meeting Large windows, tall ceilings, can be combined with Adams 200
3050 Siegelman 100 Siegelman Hall West Valley City ¤ 650.00 125 60 Meeting Dedicated kitchen and restrooms, can be combined with Siegelman 150
3107 Siegelman 150 Siegelman Hall West Valley City ¤ 650.00 125 60 Meeting Dedicated kitchen and restrooms, can be combined with Siegelman 100
3142 Jones Room Jackson Hall Main ¤ 350.00 75 35 Social Carpeted, private area of building
3179 Smith Room Jackson Hall Main ¤ 350.00 75 35 Social Carpeted, private area of building
3190 Johnson Room Jackson Hall Main ¤ 650.00 125 60 Social Carpeted, large windows
3204 Little Theater Pike Student Center Main ¤ 900.00 150 70 Lecture Wedged shape, well suited for presentations
3222 Grand Theater Pike Student Center Main ¤ 1,500.00 420 205 Lecture Wedged shape, well suited for presentations
3395 Wang 100 Wang Hall Downtown ¤ 900.00 150 70 Social Carpeted, large windows, tall ceilings, can be combined with Wang 200
3423 Wang 200 Wang Hall Downtown ¤ 900.00 150 70 Social Carpeted, large windows, tall ceilings, can be combined with Wang 100
3488 Ballroom Tenuta Hall Main ¤ 2,000.00 360 175 Social Ornate neoclassical theater, with tapestries and carpet
3515 Phillips 100 Phillips Hall West Valley City ¤ 1,600.00 350 160 Meeting Dedicated kitchen and restrooms, can be combined with Phillips 150
3529 Phillips 150 Phillips Hall West Valley City ¤ 1,600.00 350 160 Meeting Dedicated kitchen and restrooms, can be combined with Phillips 100
3611 Chavez 110 Chavez Hall Main ¤ 700.00 150 70 Meeting Large windows, can be combined with Chavez 120 and 130
3628 Chavez 120 Chavez Hall Main ¤ 700.00 150 70 Meeting Large windows, can be combined with Chavez 110 and 130
3670 Chavez 130 Chavez Hall Main ¤ 700.00 150 70 Meeting Large windows, can be combined with Chavez 110 and 120
3675 Chavez 140 Chavez Hall Main ¤ 1,250.00 240 105 Meeting Large windows, dedicated restrooms
ReservationID ContactID RoomID StartDate EndDate Guests Deposit
503 209 3488 6/12/13 6/12/13 150 ¤ 2,000.00
504 203 3529 3/11/13 3/11/13 300 ¤ 1,600.00
507 225 3002 5/12/13 5/22/13 120 ¤ 1,000.00
510 220 3107 5/1/13 5/2/13 60 ¤ 1,300.00
511 201 3142 8/20/13 8/21/13 50 ¤ 700.00
512 211 3222 4/4/13 4/4/13 400 ¤ 1,500.00
513 216 3007 7/20/13 7/22/13 80 ¤ 1,650.00
515 202 3050 9/8/13 9/9/13 100 ¤ 1,300.00
520 215 3002 8/10/13 8/10/13 60 ¤ 800.00
521 206 3395 6/3/13 6/3/13 150 ¤ 900.00
522 230 3190 6/22/13 6/26/13 125 ¤ 3,250.00
530 229 3204 8/5/13 8/7/13 150 ¤ 2,700.00
531 205 3515 11/16/13 11/16/13 150 ¤ 1,600.00
535 221 3003 9/10/13 9/10/13 80 ¤ 800.00
536 222 3675 2/20/13 2/21/13 200 ¤ 2,500.00
537 210 3611 8/4/13 8/6/13 70 ¤ 2,100.00
540 211 3222 4/10/14 4/10/14 350 ¤ 1,500.00
541 228 3628 5/20/13 5/20/13 150 ¤ 700.00
545 203 3529 3/15/14 3/15/14 300 ¤ 1,600.00
548 212 3395 10/2/13 10/2/13 60 ¤ 950.00
550 229 3670 11/5/13 11/6/13 50 ¤ 1,400.00

Chapter 19/On Your Own/Donations19.accdb

AgencyID Agency FirstName LastName Street City State Zip Phone
K12 Cheyenne Youth Connection Leslie Hopkins 348 Pape Avenue Cheyenne WY 82003 307-555-8742
K64 Wyoming Homeless Services Bradley Feeney 4263 Archwood Avenue Mountain View WY 82939 307-555-7539
K82 SeniorCare Edward Hyslop 3482 Thorn Street Cheyenne WY 82001 307-555-4663
N33 Family Crisis Center Jerry Caldwell 4673 Naito Avenue Lingle WY 82223 307-555-9416
N57 Wheelchair Soccer League Marie Llanos 4418 Arbor Court Cheyenne WY 82001 307-555-9592
R15 Self Defense for Youth Mark Ellis 1011 38th Street Mountain View WY 82939 307-555-1800
R31 Cheyenne Food Pantry Kenneth Mead 2987 Oak Street Cheyenne WY 82001 307-555-3158
R86 Carpenter After-School Center Verlie Chacko 4999 Lake Avenue Carpenter WY 82054 307-555-7030
W22 Wildlands Restoration of Wyoming Curtis Shannon 1338 Woodward Court Green River WY 82935 307-555-1395
W43 Kids Write! Madeline Holler 4939 Main Street Albin WY 82050 307-555-8687
Y68 Eastern Wyoming Trails Otis Lopez 628 Pleasant Boulevard Cheyenne WY 82003 307-555-3900
DonationID DonorID AgencyID DonationDate Description DonationValue Pickup
2100 36001 K82 1/12/13 Books 31.0 false
2101 36033 N33 2/4/13 Cash 250.0 false
2102 36012 K12 2/24/13 Books 56.0 false
2103 36033 N57 6/2/13 Housewares 14.0 false
2104 36055 K12 3/1/13 Toys 125.0 true
2105 36001 K64 3/10/13 Electronics 20.0 false
2106 36074 N57 3/1/13 Cash 750.0 false
2108 36062 W22 5/17/13 Small rugs 145.0 true
2109 36077 K12 3/3/13 Cash 275.0 false
2110 36041 R31 9/7/13 Furniture 35.0 false
2112 36060 Y68 3/5/13 Tools 140.0 false
2115 36056 N57 3/19/13 Books 34.0 false
2116 36001 K82 6/1/13 Clothing 153.0 true
2117 36012 K82 2/20/13 Books 62.0 false
2119 36051 W22 4/23/13 Furniture 80.0 true
2121 36058 K64 2/24/13 Toys 99.0 false
2122 36016 N33 3/22/13 Furniture 44.0 false
2124 36055 Y68 10/2/13 Electronics 361.0 true
2125 36077 R31 9/3/13 Clothing 128.0 false
2126 36019 N57 10/4/13 Small appliances 20.0 false
2129 36012 R86 2/28/13 Garden tools 24.0 false
2131 36049 N33 7/3/13 Electronics 93.0 true
2133 36042 W22 12/25/13 Cookware 49.0 false
2136 36037 W43 7/31/13 Linens 17.0 false
2137 36062 R31 5/1/13 Books 106.0 false
2142 36064 N33 2/26/13 Furniture 188.0 true
2144 36058 N57 5/12/13 Clothes 476.0 true
2145 36020 R15 11/10/13 CDs 37.0 false
2147 36032 R15 10/17/13 Shoes and boots 287.0 true
2148 36037 W22 9/10/13 Costume jewelry 37.0 false
2151 36037 N33 11/6/13 Plates and bowls 30.0 false
2153 36070 N57 8/2/13 Books 24.0 false
2154 36025 R31 12/12/13 Clothing 49.0 false
2155 36077 R31 1/1/13 Silverware 360.0 true
2157 36028 W22 1/18/13 Furniture 50.0 false
2159 36041 K64 3/7/13 DVDs 319.0 true
2160 36032 W43 2/21/13 Bicycle 28.0 false
2163 36055 R86 11/29/13 Power tools 26.0 false
2167 36037 W22 5/27/13 Bicycle 654.0 true
2168 36033 Y68 12/2/13 Vases 214.0 false
2170 36074 R31 9/10/13 Office equipment 269.0 true
2171 36056 W43 11/3/13 Furniture 22.0 false
2172 36033 Y68 3/24/13 Books 32.0 false
2175 36041 R15 6/12/13 CDs 103.0 false
2177 36019 W43 3/7/13 Toys 44.0 false
2179 36016 K64 10/11/13 Garden equipment 278.0 true
2180 36037 K64 6/3/13 Tea set 37.0 false
2181 36055 N33 3/7/13 Cutlery 31.0 false
2182 36012 N57 5/12/13 Small appliances 48.0 false
2184 36020 Y68 2/28/13 Guitar 173.0 true
2185 36074 K82 12/11/13 Stuffed animals 96.0 false
2187 36070 W43 10/19/13 Cookware 28.0 false
2188 36073 R31 4/30/13 Books 125.0 false
2189 36070 R31 6/13/15 Cash 25.0 false
2190 36074 N57 4/14/13 Clothing 72.0 false
2191 36077 W43 1/1/13 Cookware 18.0 false
2192 36073 W22 5/2/13 Bicycle 19.0 false
2193 36042 N33 6/1/13 Furniture 25.0 false
2195 36064 K64 4/15/13 Small appliances 284.0 false
2196 36051 N33 12/4/13 DVDs 34.0 true
2197 36033 Y68 6/5/13 Electronics 262.0 false
2199 36012 Y68 8/15/13 Cash 75.0 false
2200 36032 K82 6/4/13 Small rugs 33.0 false
2202 36051 W22 6/20/13 Power tools 256.0 true
2203 36020 W43 1/8/13 Cash 80.0 false
2205 36056 N33 3/7/13 Office equipment 368.0 true
2210 36060 Y68 3/1/13 Clothing 191.0 false
2212 36077 R86 6/20/13 Books 252.0 true
2213 36055 W43 6/13/13 Toys 337.0 false
2215 36070 N33 5/12/13 Small appliances 238.0 false
2219 36077 W22 6/21/13 Shoes and boots 17.0 false
DonorID Title FirstName LastName Phone
36001 Mrs. Karen Ludwig 307-555-6464
36012 Ms. Janice Busch 307-555-7006
36016 Mrs. Lucille Martinez 970-555-2605
36019 Mrs. Wanda Dubay 307-555-8183
36020 Mr. John Schuller 307-555-9857
36025 Ms. Tina Moore 307-555-0146
36028 Mrs. Ella Phillips 307-555-8762
36032 Mr. Melvin Brown 208-555-9033
36033 Mr. Edward Fleming 970-555-4733
36037 Mr. Stuart Wynn 307-555-9075
36041 Mrs. Lindsey Christopher 307-555-0769
36042 Mr. Terrell Ulrey 307-555-6002
36049 Mr. Jermaine Green 307-555-8377
36051 Mr. Antonio Meehan 970-555-9954
36055 Ms. Lyda Davis 307-555-0692
36056 Ms. Rene Olesen 307-555-7129
36058 Mrs. Alma Mears 307-555-7251
36060 Mrs. Maria Cave 307-555-9588
36062 Mr. Randy Rivera 307-555-5160
36064 Mr. David Brogan 307-555-6556
36070 Mrs. Brenda Lawson 307-555-9224
36073 Mr. Jamie Stapleton 307-555-8855
36074 Mr. Roberto Horvath 307-555-7550
36077 Mr. Michael Brazelton 307-555-3370

Chapter 19/On Your Own/Villa.bmp

Chapter 19/Practice It/Art19.accdb

ClassID InstructorID ClassName Juniors Length Cost
CL-293 99-3421 Clay Discovery true 45 ¤ 100.00
CL-294 99-3421 Clay Handbuilding and Sculpture false 60 ¤ 150.00
CL-295 17-1798 Clay Wheel Throwing I true 60 ¤ 125.00
CL-296 22-0102 Clay Wheel Throwing II false 90 ¤ 300.00
DR-102 34-4506 Drawing Basics true 45 ¤ 125.00
DR-103 55-5310 Drawing Basics false 45 ¤ 125.00
DR-104 34-4506 Drawing Basics false 45 ¤ 125.00
DR-105 34-4506 Drawing Portraits true 60 ¤ 175.00
DR-106 63-1554 Cartooning I true 60 ¤ 75.00
DR-107 70-4490 Cartooning II false 90 ¤ 125.00
PA-024 72-0005 Watercolor Basics true 45 ¤ 90.00
PA-025 72-0005 Watercolor II false 90 ¤ 150.00
PA-026 15-9384 Acrylics I false 45 ¤ 150.00
PA-027 17-1798 Acrylics II false 90 ¤ 250.00
PA-028 34-4506 Watercolor II true 90 ¤ 150.00
PH-311 77-1201 Photography I true 45 ¤ 100.00
PH-312 77-1201 Photography II false 90 ¤ 200.00
PH-313 22-0102 Darkroom I false 90 ¤ 175.00
PH-314 63-1554 Darkroom II false 120 ¤ 350.00
PH-315 63-1554 Darkroom III false 120 ¤ 400.00
InstructorID FirstName LastName HireDate FullTime
15-9384 Jo Rock 1/12/12 false
17-1798 Ervin Merritt 1/15/12 false
22-0102 Glen Matz 3/3/12 false
34-4506 Olivia Deleon 5/1/12 true
55-5310 Robert Ratcliff 3/12/12 false
63-1554 Jose Weigel 5/12/12 true
70-4490 Virginia Garfield 9/2/12 false
72-0005 Elisa Rockwell 3/30/13 true
77-1201 Christa Camacho 1/25/13 true
91-0178 William James 8/14/12 false
96-2151 Eric Mueller 6/22/13 false
99-3421 Mark Druin 5/25/14 true
StudentID ClassID FirstName LastName Street City State Zip Phone AltPhone BirthDate Gender
AES7562 CL-293 Alfred Stanley 874 Jessie Street Columbus OH 43215 740-555-1293 740-555-3388 4/14/87 M
AOF7548 CL-295 Alba Fischer 4972 Andell Road Dublin OH 43017 614-555-7408 614-555-1275 4/24/96 F
BEA7502 PH-312 Brenda Acker 2122 Collins Avenue Westerville OH 43081 614-555-0774 614-555-9117 3/13/83 F
BLK7509 CL-293 Betty Kingsley 2954 Bates Brothers Road Columbus OH 43215 614-555-9182 614-555-0091 4/10/96 F
CAS7530 DR-106 Christopher Soderlund 2943 Quilly Lane Upper Arlington OH 43221 614-555-5818 614-555-6876 10/23/95 M
CCH7542 CL-296 Christa Harris 4794 Viking Drive Worthington OH 43085 740-555-2920 740-555-8337 9/27/93 F
CEH7584 DR-104 Chris Hernandez 3554 Olive Street Bowling Green OH 43402 419-555-5926 419-555-8882 4/13/82 M
DAH7527 PH-314 Deanna Hugo 1735 Davis Place Hamler OH 43524 419-555-8581 419-555-1972 3/18/56 F
DIR7511 PH-311 Delmar Rector 2043 Palmer Road Worthington OH 43085 614-555-3375 614-555-0443 11/22/67 M
EAW7518 PH-311 Eddie White 403 Bates Brothers Road Westerville OH 43081 614-555-0112 614-555-1956 10/4/67 M
GTB7545 CL-293 Gail Broussard 129 Quilly Lane Westerville OH 43081 614-555-8448 614-555-4932 2/20/75 F
HAR7524 PH-314 Henry Rose 1676 Jessie Street Lancaster OH 43130 740-555-7456 740-555-2790 12/16/76 M
HOC7545 CL-295 Horace Chatman 1508 Sole Lane Columbus OH 43201 740-555-8715 740-555-7984 9/23/97 M
JAR7553 PH-311 James Davis 4152 Olive Street Bowling Green OH 43402 419-555-2956 419-555-5951 8/4/95 M
JER7551 PA-027 James Robinson 2201 Stonecoal Road Maumee OH 43537 419-555-6182 419-555-6303 5/13/74 M
JMN7538 PH-313 John Navarro 1765 Old Brickstone Drive London OH 43140 740-555-1485 740-555-0202 4/19/70 M
JOW7531 DR-104 James Woodruff 3711 Old House Drive Worthington OH 43085 740-555-4326 740-555-7712 1/26/59 M
LAB7533 DR-105 Larry Britt 976 Old House Drive Westerville OH 43081 740-555-5202 740-555-1045 12/12/96 M
LIA7534 CL-293 Lisa Anderson 562 James Martin Circle Pataskala OH 43062 614-555-7895 614-555-2410 4/5/82 F
LRT7544 CL-293 Leslie Trevino 1460 Palmer Road Columbus OH 43215 614-555-0515 614-555-2277 5/28/96 F
MAE7556 PH-312 Marcus Elam 1914 Andell Road Westerville OH 43081 614-555-6116 614-555-9511 1/27/93 M
MAP7549 DR-105 Marian Pettit 2972 Upland Avenue Holland OH 43528 419-555-3288 419-555-7819 12/6/68 F
MIL7521 CL-295 Mercedes Longino 4900 Jessie Street Centerburg OH 43011 740-555-5206 740-555-5573 12/14/69 F
PHF7522 PA-025 Paul Frank 2589 Cedarstone Drive Maumee OH 43537 419-555-0216 419-555-7299 2/22/70 M
RAM7537 PA-027 Ruben Moore 3713 Viking Drive Worthington OH 43085 740-555-2756 740-555-8002 7/31/79 M
REC7541 CL-294 Richard Collins 840 Birdhouse Drive Alexandria OH 43001 740-555-5921 740-555-8902 10/18/79 M

Chapter 19/Practice It/Health19.accdb

MemberID ProgramID First Last Street City State Zip Phone DateJoined Expiration Status
1103 201 Robert Johnston 29 Prospect Street Ashland VA 23005 1/16/13 1/16/14 Active
1105 204 Barry Hassan 9 Harrington Avenue Richmond VA 23220 3/2/13 3/2/15 Active
1106 202 Debbie Ward 18 Barton Street Richmond VA 23219 4/22/13 10/22/13 Active
1110 201 Ashish Mittal 103 Hubbard Way Glen Allen VA 23058 4/3/13 4/3/14 On Hold
1111 203 Liz Sorrento 134 Lincoln Road Chester VA 23831 2/10/13 8/20/13 Active
1115 203 Michelle Kim 290 Brook Mill Road Bon Air VA 23235 5/17/13 5/17/15 Active
1116 207 Robert DeCosta 35 Washington Street Richmond VA 23220 8/4/13 8/4/14 Inactive
1117 203 Paul Novick 302 Great Road Ashland VA 23005 9/20/13 9/20/15 Active
1120 202 Carmen Sanchez 1294 Monument Avenue Richmond VA 23219 10/18/13 9/25/14 On Hold
1121 209 Kelly Smith 7 Lakeview Road Chester VA 23831 7/18/13 7/18/14 Active
1125 203 Jessica Picard 17 Briarwood Lane Mechanicsville VA 23111 6/22/13 12/22/13 Active
1126 204 Sam Bethel 258 Elm Street Mechanicsville VA 23111 5/19/13 5/19/14 Active
1131 207 Olivia Alexander 29 Newtown Circle Richmond VA 23220 3/11/13 3/11/15 Active
1135 201 Tina Sun 682 Hickory Way Chester VA 23831 6/3/13 6/3/14 Active
1136 212 Mary Grant 913 Main Street Chester VA 23831 5/1/13 5/1/15 Active
1137 210 Alan Fraser 41 Carver Hill Road Mechanicsville VA 23111 3/20/13 3/20/14 Active
1139 210 Peter Grigas 3 Pleasant Street Glen Allen VA 23058 6/9/13 6/9/15 Inactive
1140 206 Ronald Cunningham 52 Putnam Road Ashland VA 23005 2/4/13 8/4/13 Active
1142 207 Kye Nguyen 456 Harringont Avenue Richmond VA 23220 2/20/13 2/20/15 On Hold
1143 206 Barry Feinberg 73 Endicott Avenue Chester VA 23831 10/5/13 10/5/14 Active
1144 208 Colleen Murphy 47 Winter Street Mechanicsville VA 23111 6/9/13 6/9/14 Active
1146 209 Marlene Halpin 75 Elm Boulevard Bon Air VA 23235 7/17/13 7/17/15 On Hold
1147 210 Elijah Slomich 108 Roosevelt Avenue Mechanicsville VA 23111 8/2/13 8/2/15 On Hold
1148 212 Todd Wolfe 18 Parker Avenue Richmond VA 23219 9/20/13 9/20/14 Active
1150 203 Zach Adgate 92 Apple Blossom Lane Ashland VA 23005 10/15/13 10/15/14 Active
1151 202 Isabella Cimino 429 South Street Ashland VA 23005 8/2/13 8/2/14 Active
1153 212 Vinnie Tumbiolo 358 East Street Richmond VA 23219 5/19/13 5/29/15 Inactive
1154 204 Jamal Asmal 9872 Turnpike Road Richmond VA 23220 6/7/13 6/7/14 Active
1155 210 Juliette Beaumont 35 Walnut Street Glen Allen VA 23058 8/1/13 8/1/14 Active
1156 208 Kurt Eisler 5 Bradford Circle Richmond VA 23220 4/17/13 4/17/15 On Hold
1158 201 Pedro Fuente 9 Mockingbird Lane Chester VA 23831 9/5/13 9/5/14 Active
1159 211 Maggie Hadley 6 Rose Court Ashland VA 23005 3/19/13 3/19/14 Active
1160 212 Mark Reynolds 11 Pond Lane Mechanicsville VA 23111 6/20/13 6/20/15 Active
1166 203 Abigail Turnquist 99 Maple Road Richmond VA 23219 9/1/13 9/1/15 On Hold
1167 204 George Krukonis 14 Collins Drive Richmond VA 23219 5/5/13 5/5/14 Active
1169 211 Maria Gonzalez 100 Tower Drive Richmond VA 23220 5/19/13 5/19/14 Active
1170 203 Ginger Bell 40 Green Boulevard Bon Air VA 23235 6/3/13 12/3/13 Active
1172 211 Ed Curran 25 Fairway Drive Richmond VA 23220 11/16/13 11/16/14 Active
1190 205 Alicia Jones 5 Blue Jay Blvd Chester VA 23831 804-555-2956 5/31/13 5/31/14 Active
ProgramID ProgramType MonthlyFee StartDate PhysicalRequired
201 Youth Full (ages 13-17) ¤ 50.00 1/1/14 true
202 Youth Limited (ages 13-17) ¤ 30.00 6/1/14 true
203 College Full ¤ 50.00 6/1/14 true
204 Young Adult Full (ages 18-35) ¤ 65.00 3/15/14 false
205 Early Teen (ages 13-15) ¤ 30.00 6/1/14 false
206 Young Adult Limited (ages 18-35) ¤ 35.00 4/1/14 false
207 Adult Full (ages 36-50) ¤ 60.00 2/15/14 false
208 Adult Limited (ages 36-50) ¤ 45.00 2/1/14 false
209 Starter Senior Full (ages 51-65) ¤ 50.00 1/15/14 true
210 Starter Senior Limited (ages 51-65) ¤ 35.00 1/15/14 true
211 Senior Full (ages 66 and over) ¤ 50.00 4/15/14 true
212 Senior Limited (ages 66 and over) ¤ 30.00 4/1/14 true

Chapter 19/Practice It/Paint.png

Chapter 19/Practice It/Shovel.jpg

Chapter 19/Practice It/Snow19.accdb

ClientID Company FirstName LastName Phone Street City State Zip
1 Erick Lewis 207-555-3132 193 Brimmer Street Bangor ME 04401
2 Jonah West 207-555-5217 2938 Parker Street Glenburn ME 04401
3 Mica Harris 207-555-6578 29 Highland Avenue Bangor ME 04401
4 Bangor Lighting Scott Woodman 207-555-6869 398 Eastern Avenue Bangor ME 04401
5 Jessica Fay 207-555-7870 973 Lincoln Street Glenburn ME 04401
6 Harris Bradley 207-555-0613 2398 Maple Street Bangor ME 04401
7 Pat Midford 207-555-2591 38 Winter Street Bangor ME 04401
8 Connie Essex 207-555-3001 392 Rodney Street Bangor ME 04401
9 Xander's Café Xander Parker 207-555-2064 44 Larkin Street Glenburn ME 04401
10 Park Condo Association Kenny Thompson 207-555-1913 2646 Park Street Bangor ME 04402
11 Jo Norris 207-555-7074 9 Railroad Street Bangor ME 04401
12 Mendez Accounting Jose Mendez 207-555-4193 778 Union Street Bangor ME 04401
13 Long Dry Goods Miranda Long 207-555-0084 24 Brook Street Bangor ME 04402
14 Lisa Alfanador 207-555-5274 89 Fawn Court Bangor ME 04401
15 The Soup Wagon Tamara Smith 207-555-7478 65 Silk Street Bangor ME 04401
16 The Doughnut Spot Jose Jiminez 207-555-6240 927 Parkway North Glenburn ME 04401
17 Alex Borgen 207-555-0092 456 Clover Lane Bangor ME 04402
18 Stephen Mayers 207-555-4074 4640 Willow Way Bangor ME 04402
19 Aurelia Doren 207-555-6517 1293 Longmeadow Drive Bangor ME 04401
20 Lester Flynn 207-555-2691 15 Floyd Street Glenburn ME 04401
21 Pony Grill Kari Michelon 207-555-4887 3118 Cresecent Street Veazie ME 04401
22 Bangor Senior Center Will Coatil 207-555-9912 494 Oak Grove Drive Glenburn ME 04401
23 High Estate Realtors Sandy Frankel 207-555-8025 535 Penobscot Street Glenburn ME 04401
24 Paul Raymond 207-555-6543 2565 State Street Bangor ME 04401
25 George Rooney 207-555-3470 4457 North Main Street Veazie ME 94301
26 King Groceries Doreen Howard 207-555-6733 4169 Capri Street Bangor ME 94612
27 Waxer Preschool Joshua Kreller 207-555-8069 4997 Park Street Bangor ME 04402
28 Genie Road Building Supplies Zach Theisen 207-555-9985 464 Genie Road Glenburn ME 04401
29 Molly O'Brien 207-555-1707 3641 Oak Hollow Road Bangor ME 04401
30 Cuts & Color Janis Fontaine 207-555-9101 792 Broadlawn Drive Bangor ME 04402
31 Hanford Fashion Shira Mayers 207-555-4968 3968 Forsest Avenue Veazie ME 04401
32 Claudia Schnell 207-555-3803 575 Milford Road Bangor ME 04401
33 Kenduskeag College Cameron Kelly 207-555-3776 1285 Forest Avenue Kenduskeag ME 04450
34 Eastern Penobscot Medical Center Ralph Wantito 207-555-9370 21 Birch Street Glenburn ME 04401
35 Snow Sports Supply House Marcus Ioto 207-555-4825 1347 Juniper Lane Veazie ME 04401
36 Penobscot Photography Glen Iradelli 207-555-2786 144 Bates Road Bangor ME 04401
37 Selma Coombs 207-555-1984 1878 Kira Drive Bangor ME 04401
38 Otis Howard 207-555-7653 791 Leighton Street Veazie ME 04401
39 Bangor's Best Bagels Jack Garland 207-555-7353 1244 Mt. Hope Avenue Bangor ME 04401
40 Madison Dentistry Kia Madison 207-555-5439 412 Garland Street Glenburn ME 04401
41 Pasta, Pizza, 'n More Marcy Lewis 207-555-7105 52 South Park Street Veazie ME 04401
InvNum AgreementNum InvDate InvAmt Paid
1301-001 1301 1/9/13 ¤ 30.00 true
1301-002 1307 1/10/13 ¤ 20.00 true
1301-003 1303 1/10/13 ¤ 300.00 true
1301-004 1306 1/16/13 ¤ 50.00 true
1301-005 1304 1/16/13 ¤ 700.00 true
1301-006 1305 1/19/13 ¤ 20.00 true
1301-007 1302 1/22/13 ¤ 30.00 true
1301-008 1407 1/25/13 ¤ 200.00 true
1301-009 1305 1/29/13 ¤ 80.00 true
1301-010 1306 1/29/13 ¤ 100.00 true
1301-011 1304 1/29/13 ¤ 500.00 true
1301-012 1303 1/29/13 ¤ 1,200.00 true
1301-013 1307 1/29/13 ¤ 120.00 true
1301-015 1302 1/29/13 ¤ 70.00 true
1301-016 1301 1/29/13 ¤ 120.00 true
1302-017 1304 2/28/13 ¤ 300.00 true
1303-002 1433 12/19/14 ¤ 500.00 false
1305-009 1308 2/28/14 ¤ 75.00 true
1306-012 1310 11/29/13 ¤ 250.00 true
1306-013 1311 12/15/13 ¤ 500.00 true
1306-014 1434 12/20/14 ¤ 25.00 false
1307-015 1312 12/15/13 ¤ 900.00 true
1307-016 1310 12/29/13 ¤ 100.00 true
1308-020 1310 1/29/14 ¤ 150.00 true
1311-018 1309 11/20/13 ¤ 35.00 true
1311-019 1310 11/30/13 ¤ 20.00 true
1312-020 1311 12/6/13 ¤ 25.00 true
1312-021 1314 12/8/13 ¤ 280.00 true
1312-022 1312 12/8/13 ¤ 1,100.00 true
1312-023 1313 12/8/13 ¤ 350.00 true
1312-024 1315 12/11/13 ¤ 19.00 true
1312-026 1317 12/17/13 ¤ 20.00 true
1312-027 1316 12/17/13 ¤ 50.00 true
1312-028 1318 12/17/13 ¤ 20.00 true
1312-029 1314 12/28/13 ¤ 120.00 true
1312-030 1311 12/28/13 ¤ 100.00 true
1312-031 1309 12/28/13 ¤ 140.00 true
1312-032 1310 12/28/13 ¤ 80.00 true
1312-033 1315 12/28/13 ¤ 76.00 true
1312-034 1319 12/28/13 ¤ 150.00 true
1312-035 1313 12/28/13 ¤ 300.00 true
1312-036 1312 12/28/13 ¤ 2,200.00 true
1312-037 1316 12/28/13 ¤ 50.00 true
1312-038 1318 12/28/13 ¤ 80.00 true
1312-039 1317 12/28/13 ¤ 80.00 true
1312-040 1315 12/29/13 ¤ 700.00 true
1401-041 1401 1/12/14 ¤ 350.00 true
1401-042 1403 1/16/14 ¤ 250.00 true
1401-043 1402 1/16/14 ¤ 120.00 true
1401-045 1405 1/22/14 ¤ 290.00 true
1401-046 1406 1/22/14 ¤ 60.00 true
1401-050 1401 1/30/14 ¤ 1,400.00 true
1401-051 1403 1/30/14 ¤ 1,000.00 true
1401-052 1326 1/30/14 ¤ 300.00 false
1401-053 1320 1/30/14 ¤ 700.00 true
1401-054 1319 1/30/14 ¤ 1,600.00 true
1401-055 1402 1/30/14 ¤ 480.00 true
1402-056 1406 2/28/14 ¤ 15.00 true
1402-057 1405 2/28/14 ¤ 60.00 false
1402-058 1404 2/28/14 ¤ 1,150.00 true
1402-059 1404 2/28/14 ¤ 600.00 true
1402-060 1328 2/28/14 ¤ 1,000.00 true
1402-061 1327 2/28/14 ¤ 500.00 true
1403-012 1412 10/29/14 ¤ 255.00 true
1403-062 1328 3/29/14 ¤ 1,000.00 true
1405-025 1412 11/29/14 ¤ 525.00 false
1405-026 1429 12/10/14 ¤ 350.00 true
1406-049 1412 12/29/14 ¤ 495.00 false
1407-014 1314 1/29/14 ¤ 50.00 true
1407-025 1314 12/15/14 ¤ 75.00 true
1407-044 1404 1/18/14 ¤ 750.00 false
1407-047 1327 1/29/14 ¤ 500.00 true
1407-048 1328 1/29/14 ¤ 850.00 true
1407-049 1315 1/29/14 ¤ 675.00 true
1407-058 1429 12/29/14 ¤ 700.00 false
1407-059 1311 2/28/14 ¤ 375.00 true
1407-100 1427 12/29/14 ¤ 550.00 false
1408-069 1312 1/29/14 ¤ 700.00 true
1408-071 1311 1/29/14 ¤ 375.00 true
1408-072 1427 12/9/14 ¤ 275.00 false
1409-074 1309 2/15/13 ¤ 1,575.00 true
1409-083 1312 2/28/14 ¤ 300.00 false
1409-088 1422 11/26/14 ¤ 370.00 false
1410-063 1407 10/19/14 ¤ 17.00 true
1410-064 1408 10/22/14 ¤ 20.00 true
1410-065 1409 10/23/14 ¤ 20.00 true
1410-066 1411 10/29/14 ¤ 25.00 true
1411-067 1411 11/4/14 ¤ 33.00 true
1411-068 1410 11/4/14 ¤ 25.00 true
1411-069 1412 11/10/14 ¤ 19.00 true
1411-070 1413 11/20/14 ¤ 75.00 true
1411-071 1416 11/25/14 ¤ 300.00 false
1411-072 1414 11/25/14 ¤ 65.00 true
1411-073 1417 11/25/14 ¤ 110.00 true
1411-074 1415 11/25/14 ¤ 50.00 true
1411-075 1418 11/26/14 ¤ 25.00 true
1411-108 1422 12/29/14 ¤ 740.00 false
1412-076 1419 12/2/14 ¤ 150.00 true
1412-077 1424 12/8/14 ¤ 500.00 false
1412-078 1426 12/9/14 ¤ 25.00 true
1412-079 1421 12/9/14 ¤ 25.00 true
1412-080 1420 12/9/14 ¤ 290.00 true
1412-081 1422 12/11/14 ¤ 100.00 true
1412-082 1423 12/17/14 ¤ 1,000.00 false
1412-083 1424 12/17/14 ¤ 25.00 true
1412-084 1425 12/20/14 ¤ 340.00 true
1412-085 1424 12/29/14 ¤ 1,000.00 false
1412-086 1411 12/29/14 ¤ 100.00 false
1412-087 1410 12/29/14 ¤ 75.00 false
1412-088 1417 12/29/14 ¤ 220.00 false
1412-089 1411 12/29/14 ¤ 66.00 false
1412-090 1413 12/29/14 ¤ 50.00 false
1412-091 1412 12/29/14 ¤ 76.00 false
1412-092 1418 12/29/14 ¤ 100.00 false
1412-093 1407 12/29/14 ¤ 68.00 false
1412-094 1409 12/29/14 ¤ 80.00 false
1412-095 1416 12/29/14 ¤ 600.00 false
1412-096 1414 12/29/14 ¤ 100.00 false
1412-097 1408 12/29/14 ¤ 80.00 false
1412-098 1415 12/29/14 ¤ 45.00 false
AgreementNum ClientID AgreementAmt AgreementDate ServiceType
1301 1 ¤ 150.00 1/9/13 Residential
1302 19 ¤ 100.00 1/10/13 Residential
1303 4 ¤ 1,500.00 1/10/13 Commercial
1304 16 ¤ 1,500.00 1/16/13 Commercial
1305 7 ¤ 100.00 1/16/13 Residential
1306 3 ¤ 150.00 1/16/13 Residential
1307 25 ¤ 140.00 1/9/13 Residential
1308 38 ¤ 75.00 2/4/13 Residential
1309 36 ¤ 1,750.00 2/10/13 Commercial
1310 37 ¤ 500.00 10/18/13 Residential
1311 39 ¤ 1,375.00 10/18/13 Commercial
1312 34 ¤ 5,200.00 10/19/13 Commercial
1313 5 ¤ 650.00 11/20/13 Residential
1314 32 ¤ 525.00 11/24/13 Commercial
1315 28 ¤ 1,470.00 11/30/13 Commercial
1316 14 ¤ 100.00 11/30/13 Residential
1317 11 ¤ 100.00 12/6/13 Residential
1318 15 ¤ 100.00 12/8/13 Commercial
1319 13 ¤ 1,750.00 12/8/13 Commercial
1320 9 ¤ 700.00 12/8/13 Commercial
1321 17 ¤ 95.00 12/11/13 Residential
1322 22 ¤ 1,675.00 12/17/13 Commercial
1323 20 ¤ 100.00 12/17/13 Residential
1324 24 ¤ 100.00 12/17/13 Residential
1325 18 ¤ 750.00 12/29/13 Residential
1326 12 ¤ 300.00 1/19/14 Commercial
1327 30 ¤ 1,000.00 12/28/13 Commercial
1328 33 ¤ 2,850.00 12/28/13 Commercial
1401 13 ¤ 1,750.00 1/12/14 Commercial
1402 26 ¤ 600.00 1/16/14 Commercial
1403 12 ¤ 1,250.00 1/16/14 Commercial
1404 31 ¤ 2,500.00 1/18/14 Commercial
1405 4 ¤ 350.00 1/22/14 Commercial
1406 8 ¤ 75.00 1/22/14 Residential
1407 5 ¤ 285.00 1/25/13 Residential
1408 2 ¤ 100.00 10/19/14 Residential
1409 7 ¤ 100.00 10/22/14 Residential
1410 14 ¤ 100.00 10/23/14 Residential
1411 29 ¤ 224.00 10/29/14 Residential
1412 39 ¤ 1,370.00 10/29/14 Commercial
1413 24 ¤ 125.00 11/4/14 Residential
1414 3 ¤ 165.00 11/4/14 Residential
1415 6 ¤ 95.00 11/10/14 Residential
1416 16 ¤ 900.00 11/20/14 Commercial
1417 17 ¤ 330.00 11/25/14 Residential
1418 21 ¤ 125.00 11/25/14 Commercial
1419 1 ¤ 150.00 11/25/14 Residential
1420 10 ¤ 550.00 11/25/14 Commercial
1421 19 ¤ 125.00 11/26/14 Residential
1422 36 ¤ 1,310.00 11/26/14 Commercial
1423 23 ¤ 1,575.00 12/2/14 Commercial
1424 27 ¤ 1,525.00 12/8/14 Commercial
1425 9 ¤ 340.00 12/9/14 Commercial
1426 32 ¤ 125.00 12/9/14 Residential
1427 35 ¤ 1,375.00 12/9/14 Commercial
1428 11 ¤ 125.00 12/9/14 Residential
1429 41 ¤ 1,200.00 12/10/14 Commercial
1430 25 ¤ 500.00 12/11/14 Residential
1431 15 ¤ 500.00 12/17/14 Commercial
1432 20 ¤ 125.00 12/17/14 Residential
1433 40 ¤ 500.00 12/19/14 Commercial
1434 38 ¤ 125.00 12/20/14 Residential
1435 22 ¤ 1,700.00 12/20/14 Commercial

Chapter 19/Practice It/Weights.bmp