Microsoft Access Projects
stvrueg
chapter_17.zipChapter 17/Chapter/Solar17.accdb
| ContractID | CustomerID | ContractValue | DateSigned |
|---|---|---|---|
| 1301-KS | 1 | ¤ 500.00 | 2013-02-09 |
| 1302-KS | 1 | ¤ 14,000.00 | 2013-03-03 |
| 1303-MP | 16 | ¤ 1,150.00 | 2013-03-16 |
| 1304-MP | 22 | ¤ 1,200.00 | 2013-04-10 |
| 1305-KF | 3 | ¤ 800.00 | 2013-04-22 |
| 1306-MP | 23 | ¤ 1,100.00 | 2013-04-29 |
| 1307-RR | 5 | ¤ 620.00 | 2013-07-07 |
| 1308-RR | 25 | ¤ 800.00 | 2013-08-09 |
| 1309-KF | 11 | ¤ 450.00 | 2013-08-16 |
| 1310-MP | 16 | ¤ 89,000.00 | 2013-08-26 |
| 1311-KS | 26 | ¤ 25,500.00 | 2013-09-03 |
| 1312-KF | 24 | ¤ 25,000.00 | 2013-09-04 |
| 1313-RR | 17 | ¤ 550.00 | 2013-09-11 |
| 1314-RR | 5 | ¤ 16,500.00 | 2013-09-17 |
| 1315-MP | 2 | ¤ 690.00 | 2013-09-30 |
| 1316-RR | 25 | ¤ 32,500.00 | 2013-10-15 |
| 1317-KF | 11 | ¤ 15,500.00 | 2013-10-15 |
| 1318-KF | 3 | ¤ 18,000.00 | 2013-10-20 |
| 1319-RR | 25 | ¤ 39,000.00 | 2013-11-07 |
| 1401-MP | 2 | ¤ 20,000.00 | 2014-01-26 |
| 1402-RR | 25 | ¤ 138,000.00 | 2014-02-18 |
| 1403-RR | 17 | ¤ 14,500.00 | 2014-02-22 |
| 1404-KF | 21 | ¤ 15,750.00 | 2014-03-11 |
| 1405-KS | 20 | ¤ 1,000.00 | 2014-04-08 |
| 1406-MP | 9 | ¤ 16,500.00 | 2014-04-23 |
| 1407-RR | 10 | ¤ 22,800.00 | 2014-04-29 |
| 1408-AD | 19 | ¤ 700.00 | 2014-05-04 |
| 1409-KS | 20 | ¤ 23,750.00 | 2014-05-10 |
| 1410-AD | 15 | ¤ 205,000.00 | 2014-05-20 |
| 1411-RR | 12 | ¤ 1,150.00 | 2014-06-01 |
| 1412-RR | 13 | ¤ 575.00 | 2014-06-12 |
| 1413-AD | 19 | ¤ 18,500.00 | 2014-06-12 |
| 1414-KS | 6 | ¤ 25,500.00 | 2014-06-29 |
| 1415-MP | 14 | ¤ 14,500.00 | 2014-07-14 |
| 1416-MP | 18 | ¤ 35,000.00 | 2014-07-30 |
| 1417-KS | 4 | ¤ 6,500.00 | 2014-08-09 |
| 1418-RR | 8 | ¤ 15,000.00 | 2014-08-10 |
| 1419-AD | 13 | ¤ 38,500.00 | 2014-08-11 |
| 1420-AD | 25 | ¤ 50,000.00 | 2014-08-17 |
| 1421-MP | 7 | ¤ 875.00 | 2014-08-23 |
| 1422-AD | 25 | ¤ 41,000.00 | 2014-09-02 |
| CustomerID | LastName | FirstName | Company | Street | City | State | Zip | Phone | |
|---|---|---|---|---|---|---|---|---|---|
| 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] |
| InvNum | InvDate | Amount | Paid | ContractID |
|---|---|---|---|---|
| 1302-001 | 2013-02-18 | ¤ 500.00 | true | 1301-KS |
| 1304-002 | 2013-04-01 | ¤ 1,150.00 | true | 1303-MP |
| 1304-003 | 2013-04-29 | ¤ 1,200.00 | true | 1304-MP |
| 1305-004 | 2013-05-10 | ¤ 12,500.00 | true | 1302-KS |
| 1305-005 | 2013-05-15 | ¤ 1,100.00 | true | 1306-MP |
| 1305-006 | 2013-05-30 | ¤ 800.00 | true | 1305-KF |
| 1306-007 | 2013-06-09 | ¤ 1,500.00 | true | 1302-KS |
| 1307-008 | 2013-07-15 | ¤ 620.00 | true | 1307-RR |
| 1308-009 | 2013-08-28 | ¤ 450.00 | true | 1309-KF |
| 1308-010 | 2013-08-29 | ¤ 800.00 | true | 1308-RR |
| 1309-011 | 2013-09-15 | ¤ 5,100.00 | true | 1311-KS |
| 1309-012 | 2013-09-15 | ¤ 2,500.00 | true | 1312-KF |
| 1309-013 | 2013-09-29 | ¤ 17,800.00 | true | 1310-MP |
| 1309-014 | 2013-09-29 | ¤ 550.00 | true | 1313-RR |
| 1310-015 | 2013-10-15 | ¤ 690.00 | true | 1315-MP |
| 1310-016 | 2013-10-15 | ¤ 3,500.00 | true | 1314-RR |
| 1311-017 | 2013-11-12 | ¤ 8,500.00 | true | 1317-KF |
| 1311-018 | 2013-11-12 | ¤ 4,100.00 | true | 1315-MP |
| 1311-019 | 2013-11-15 | ¤ 6,500.00 | true | 1316-RR |
| 1311-020 | 2013-11-15 | ¤ 7,800.00 | true | 1319-RR |
| 1311-021 | 2013-11-15 | ¤ 20,400.00 | true | 1311-KS |
| 1311-022 | 2013-11-15 | ¤ 22,500.00 | true | 1312-KF |
| 1311-023 | 2013-11-29 | ¤ 45,600.00 | true | 1310-MP |
| 1312-024 | 2013-12-15 | ¤ 12,480.00 | true | 1319-RR |
| 1312-025 | 2013-12-21 | ¤ 15,000.00 | false | 1318-KF |
| 1312-026 | 2013-12-23 | ¤ 8,000.00 | true | 1314-RR |
| 1312-027 | 2013-12-29 | ¤ 13,000.00 | true | 1316-RR |
| 1401-001 | 2014-01-12 | ¤ 7,000.00 | true | 1317-KF |
| 1401-002 | 2014-01-15 | ¤ 18,720.00 | true | 1319-RR |
| 1401-003 | 2014-01-29 | ¤ 25,600.00 | true | 1310-MP |
| 1401-004 | 2014-01-29 | ¤ 8,500.00 | true | 1316-RR |
| 1401-005 | 2014-01-31 | ¤ 3,000.00 | false | 1318-KF |
| 1402-006 | 2014-02-12 | ¤ 5,000.00 | true | 1314-RR |
| 1402-007 | 2014-02-14 | ¤ 4,500.00 | true | 1316-RR |
| 1402-008 | 2014-02-28 | ¤ 18,000.00 | true | 1402-RR |
| 1403-009 | 2014-03-15 | ¤ 13,000.00 | true | 1401-MP |
| 1403-010 | 2014-03-29 | ¤ 4,725.00 | true | 1404-KF |
| 1403-011 | 2014-03-29 | ¤ 6,500.00 | true | 1403-RR |
| 1404-012 | 2014-04-15 | ¤ 1,000.00 | true | 1405-KS |
| 1404-013 | 2014-04-28 | ¤ 120,000.00 | true | 1402-RR |
| 1405-014 | 2014-05-01 | ¤ 7,000.00 | true | 1401-MP |
| 1405-015 | 2014-05-15 | ¤ 700.00 | true | 1408-AD |
| 1405-016 | 2014-05-15 | ¤ 8,000.00 | true | 1403-RR |
| 1405-017 | 2014-05-29 | ¤ 9,025.00 | true | 1404-KF |
| 1405-018 | 2014-05-29 | ¤ 10,000.00 | true | 1409-KS |
| 1405-019 | 2014-05-29 | ¤ 12,400.00 | true | 1407-RR |
| 1406-020 | 2014-06-12 | ¤ 41,000.00 | true | 1410-AD |
| 1406-021 | 2014-06-12 | ¤ 1,150.00 | false | 1411-RR |
| 1406-022 | 2014-06-29 | ¤ 2,000.00 | true | 1404-KF |
| 1406-023 | 2014-06-29 | ¤ 137,500.00 | true | 1409-KS |
| 1406-024 | 2014-06-29 | ¤ 8,000.00 | true | 1413-AD |
| 1406-025 | 2014-06-29 | ¤ 575.00 | true | 1412-RR |
| 1407-026 | 2014-07-12 | ¤ 4,500.00 | true | 1407-RR |
| 1407-027 | 2014-07-12 | ¤ 10,000.00 | true | 1410-AD |
| 1407-028 | 2014-07-23 | ¤ 16,500.00 | true | 1406-MP |
| 1408-029 | 2014-08-12 | ¤ 4,500.00 | true | 1414-KS |
| 1408-030 | 2014-08-12 | ¤ 8,500.00 | true | 1410-AD |
| 1408-031 | 2014-08-12 | ¤ 7,000.00 | true | 1416-MP |
| 1408-032 | 2014-08-12 | ¤ 3,000.00 | true | 1407-RR |
| 1408-033 | 2014-08-15 | ¤ 10,500.00 | true | 1413-AD |
| 1408-034 | 2014-08-29 | ¤ 15,000.00 | true | 1420-AD |
| 1409-035 | 2014-09-01 | ¤ 2,900.00 | false | 1415-MP |
| 1409-036 | 2014-09-12 | ¤ 9,000.00 | true | 1418-RR |
| 1409-037 | 2014-09-12 | ¤ 875.00 | false | 1421-MP |
| 1409-038 | 2014-09-12 | ¤ 3,000.00 | true | 1414-KS |
| 1409-039 | 2014-09-12 | ¤ 14,200.00 | true | 1410-AD |
| 1409-040 | 2014-09-29 | ¤ 2,900.00 | true | 1407-RR |
| 1409-041 | 2014-09-29 | ¤ 8,200.00 | true | 1422-AD |
| 1409-042 | 2014-09-29 | ¤ 8,500.00 | true | 1416-MP |
| 1410-043 | 2014-10-10 | ¤ 6,500.00 | false | 1417-KS |
| 1410-044 | 2014-10-12 | ¤ 12,000.00 | true | 1414-KS |
| 1410-045 | 2014-10-12 | ¤ 7,500.00 | false | 1415-MP |
| 1410-046 | 2014-10-12 | ¤ 4,000.00 | true | 1418-RR |
| 1410-047 | 2014-10-12 | ¤ 43,600.00 | true | 1410-AD |
| 1410-048 | 2014-10-29 | ¤ 10,000.00 | true | 1416-MP |
| 1410-049 | 2014-10-29 | ¤ 17,500.00 | true | 1420-AD |
| 1411-050 | 2014-11-12 | ¤ 29,500.00 | false | 1410-AD |
| 1411-051 | 2014-11-12 | ¤ 2,000.00 | false | 1418-RR |
| 1411-052 | 2014-11-29 | ¤ 32,800.00 | false | 1422-AD |
| 1411-053 | 2014-11-29 | ¤ 17,500.00 | false | 1420-AD |
| 1411-054 | 2014-11-29 | ¤ 9,500.00 | false | 1416-MP |
| 1412-055 | 2014-12-12 | ¤ 37,500.00 | false | 1410-AD |
Chapter 17/On Your Own/Contacts17.accdb
| 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 | ¤ 800.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 |
Chapter 17/On Your Own/ContactsTable17.accdb
| ID | ContactFirst | ContactLast | Address | City | State | Zip | Phone | BirthDate |
|---|---|---|---|---|---|---|---|---|
| 201 | Lori | Sinclair | 2315 Philadelphia Avenue | Murray | UT | 84107 | 801-966-0454 | 1965-05-29 |
| 202 | Leo | Wessel | 2195 Scattershot Way | Salt Lake City | UT | 84111 | 801-869-3378 | 1976-12-12 |
| 203 | Leonard | Black | 784 Philadelphia Avenue | Salt Lake City | UT | 84104 | 801-474-8135 | 1982-01-08 |
| 205 | Thomas | Friedel | 4880 Tori Lane | Salt Lake City | UT | 84116 | 801-573-3401 | 1940-03-07 |
| 206 | William | Tsan | 2204 Buck Drive | Salt Lake City | UT | 84111 | 801-490-1641 | 1949-11-15 |
| 209 | Robert | Pharr | 595 Pignole Drive | West Valley City | UT | 84119 | 801-483-3559 | 1980-09-05 |
| 210 | Tina | Allen | 1950 Kemper Lane | Salt Lake City | UT | 84116 | 801-981-0593 | 1943-08-05 |
| 211 | Alice | Cox | 4879 Tori Lane | Salt Lake City | UT | 84113 | 801-733-7017 | 1982-10-16 |
| 212 | Arthur | Miller | 3613 Hickory Street | Salt Lake City | UT | 84104 | 801-450-9220 | 1983-05-09 |
| 215 | Sarah | Robinson | 4411 Walton Street | Salt Lake City | UT | 84104 | 801-274-0595 | 1983-04-08 |
| 216 | Thomas | Mathis | 2299 White River Way | Salt Lake City | UT | 84111 | 801-570-0381 | 1970-03-25 |
| 217 | Lois | Augustine | 1979 Thrice Way | Salt Lake City | UT | 84106 | 801-488-3255 | 1966-08-01 |
| 220 | Kevin | Smith | 3291 Kemper Lane | Murray | UT | 84107 | 801-449-9225 | 1980-06-15 |
| 221 | Tracy | Kemp | 3651 Plympton Lane | Kearns | UT | 84118 | 801-440-5209 | 1965-01-31 |
| 222 | Cora | Velez | 510 Walton Street | Salt Lake City | UT | 84104 | 801-534-1420 | 1972-09-15 |
| 225 | Angel | Pinto | 2983 Stringfeld Way | Salt Lake City | UT | 84111 | 435-728-5245 | 1971-08-28 |
| 228 | John | Pittman | 4132 Hickory Street | Salt Lake City | UT | 84104 | 435-538-4925 | 1989-07-22 |
| 229 | Michelle | Frey | 242 Sweetwater Drive | Salt Lake City | UT | 84111 | 801-584-3146 | 1971-10-31 |
| 230 | Dan | Eason | 1439 Tempest Avenue | Salt Lake City | UT | 84116 | 801-795-7666 | 1965-02-22 |
Chapter 17/On Your Own/Donations17.accdb
| AgencyID | Agency | FirstName | LastName | Street | City | State | Zip | Phone | Fax | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| K64 | Wyoming Homeless Services | Bradley | Feeney | 4263 Archwood Avenue | Mountain View | WY | 82939 | 307-555-7539 | 307-555-7540 | |
| K82 | SeniorCare | Edward | Hyslop | 3482 Thorn Street | Cheyenne | WY | 82001 | 307-555-4663 | 307-555-4661 | |
| N33 | Family Crisis Center | Jerry | Caldwell | 4673 Naito Avenue | Lingle | WY | 82223 | 307-555-9416 | 307-555-9411 | |
| N57 | Wheelchair Soccer League | Marie | Llanos | 4418 Arbor Court | Cheyenne | WY | 82001 | 307-555-9592 | 307-555-9598 | |
| R15 | Self Defense for Youth | Mark | Ellis | 1011 38th Street | Mountain View | WY | 82939 | 307-555-1800 | 307-555-1814 | |
| R31 | Cheyenne Food Pantry | Kenneth | Mead | 2987 Oak Street | Cheyenne | WY | 82001 | 307-555-3158 | 307-555-3159 | |
| R86 | Carpenter After-School Center | Verlie | Chacko | 4999 Lake Avenue | Carpenter | WY | 82054 | 307-555-7030 | 307-555-7031 | |
| W22 | Wildlands Restoration of Wyoming | Curtis | Shannon | 1338 Woodward Court | Green River | WY | 82935 | 307-555-1395 | 307-555-1402 | |
| W43 | Kids Write! | Madeline | Holler | 4939 Main Street | Albin | WY | 82050 | 307-555-8687 | 307-555-8693 | |
| Y68 | Eastern Wyoming Trails | Otis | Lopez | 628 Pleasant Boulevard | Cheyenne | WY | 82003 | 307-555-3900 | 307-555-3901 |
| DonorID | Title | FirstName | LastName | Phone |
|---|---|---|---|---|
| 36001 | Mr. | John | Stevens | 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 17/On Your Own/DonationTable17.accdb
| DonationDate | Description | DonationValue | DonationID | DonorID | ID | Pickup |
|---|---|---|---|---|---|---|
| 2013-01-12 | Books | 31.0 | 2100 | 36001 | K82 | false |
| 2013-06-02 | Housewares | 14.0 | 2103 | 36033 | N57 | false |
| 2013-03-10 | Electronics | 20.0 | 2105 | 36001 | K64 | false |
| 2013-05-17 | Small rugs | 145.0 | 2108 | 36062 | W22 | true |
| 2013-09-07 | Furniture | 35.0 | 2110 | 36041 | R31 | false |
| 2013-03-05 | Tools | 140.0 | 2112 | 36060 | Y68 | false |
| 2013-03-19 | Books | 34.0 | 2115 | 36056 | N57 | false |
| 2013-06-01 | Clothing | 153.0 | 2116 | 36001 | K82 | true |
| 2013-02-20 | Books | 62.0 | 2117 | 36012 | K82 | false |
| 2013-04-23 | Furniture | 80.0 | 2119 | 36051 | W22 | true |
| 2013-02-24 | Toys | 99.0 | 2121 | 36058 | K64 | false |
| 2013-03-22 | Furniture | 44.0 | 2122 | 36016 | N33 | false |
| 2013-10-02 | Electronics | 361.0 | 2124 | 36055 | Y68 | true |
| 2013-09-03 | Clothing | 128.0 | 2125 | 36077 | R31 | false |
| 2013-10-04 | Small appliances | 20.0 | 2126 | 36019 | N57 | false |
| 2013-02-28 | Garden tools | 24.0 | 2129 | 36012 | R86 | false |
| 2013-07-03 | Electronics | 93.0 | 2131 | 36049 | N33 | true |
| 2013-12-25 | Cookware | 49.0 | 2133 | 36042 | W22 | false |
| 2013-07-31 | Linens | 17.0 | 2136 | 36037 | W43 | false |
| 2013-05-01 | Books | 106.0 | 2137 | 36062 | R31 | false |
| 2013-02-26 | Furniture | 188.0 | 2142 | 36064 | N33 | true |
| 2013-05-12 | Clothes | 476.0 | 2144 | 36058 | N57 | true |
| 2013-11-10 | CDs | 37.0 | 2145 | 36020 | R15 | false |
| 2013-10-17 | Shoes and boots | 287.0 | 2147 | 36032 | R15 | true |
| 2013-09-10 | Costume jewelry | 37.0 | 2148 | 36037 | W22 | false |
| 2013-11-06 | Plates and bowls | 30.0 | 2151 | 36037 | N33 | false |
| 2013-08-02 | Books | 24.0 | 2153 | 36070 | N57 | false |
| 2013-12-12 | Clothing | 49.0 | 2154 | 36025 | R31 | false |
| 2013-01-01 | Silverware | 360.0 | 2155 | 36077 | R31 | true |
| 2013-01-18 | Furniture | 50.0 | 2157 | 36028 | W22 | false |
| 2013-03-07 | DVDs | 319.0 | 2159 | 36041 | K64 | true |
| 2013-02-21 | Bicycle | 28.0 | 2160 | 36032 | W43 | false |
| 2013-11-29 | Power tools | 26.0 | 2163 | 36055 | R86 | false |
| 2013-05-27 | Bicycle | 654.0 | 2167 | 36037 | W22 | true |
| 2013-12-02 | Vases | 214.0 | 2168 | 36033 | Y68 | false |
| 2013-09-10 | Office equipment | 269.0 | 2170 | 36074 | R31 | true |
| 2013-11-03 | Furniture | 22.0 | 2171 | 36056 | W43 | false |
| 2013-03-24 | Books | 32.0 | 2172 | 36033 | Y68 | false |
| 2013-06-12 | CDs | 103.0 | 2175 | 36041 | R15 | false |
| 2013-03-07 | Toys | 44.0 | 2177 | 36019 | W43 | false |
| 2013-10-11 | Garden equipment | 278.0 | 2179 | 36016 | K64 | true |
| 2013-06-03 | Tea set | 37.0 | 2180 | 36037 | K64 | false |
| 2013-03-07 | Cutlery | 31.0 | 2181 | 36055 | N33 | false |
| 2013-05-12 | Small appliances | 48.0 | 2182 | 36012 | N57 | false |
| 2013-02-28 | Guitar | 173.0 | 2184 | 36020 | Y68 | true |
| 2013-12-11 | Stuffed animals | 96.0 | 2185 | 36074 | K82 | false |
| 2013-10-19 | Cookware | 28.0 | 2187 | 36070 | W43 | false |
| 2013-04-30 | Books | 125.0 | 2188 | 36073 | R31 | false |
| 2013-04-14 | Clothing | 72.0 | 2190 | 36074 | N57 | false |
| 2013-01-01 | Cookware | 18.0 | 2191 | 36077 | W43 | false |
| 2013-05-02 | Bicycle | 19.0 | 2192 | 36073 | W22 | false |
| 2013-06-01 | Furniture | 25.0 | 2193 | 36042 | N33 | false |
| 2013-04-15 | Small appliances | 284.0 | 2195 | 36064 | K64 | false |
| 2013-12-04 | DVDs | 34.0 | 2196 | 36051 | N33 | true |
| 2013-06-05 | Electronics | 262.0 | 2197 | 36033 | Y68 | false |
| 2013-06-04 | Small rugs | 33.0 | 2200 | 36032 | K82 | false |
| 2013-06-20 | Power tools | 256.0 | 2202 | 36051 | W22 | true |
| 2013-03-07 | Office equipment | 368.0 | 2205 | 36056 | N33 | true |
| 2013-03-01 | Clothing | 191.0 | 2210 | 36060 | Y68 | false |
| 2013-06-20 | Books | 252.0 | 2212 | 36077 | R86 | true |
| 2013-06-13 | Toys | 337.0 | 2213 | 36055 | W43 | false |
| 2013-05-12 | Small appliances | 238.0 | 2215 | 36070 | N33 | false |
| 2013-06-21 | Shoes and boots | 17.0 | 2219 | 36077 | W22 | false |
Chapter 17/On Your Own/Reservations17.accdb
| ReservationID | ContactID | RoomID | StartDate | EndDate | Guests | Deposit |
|---|---|---|---|---|---|---|
| 503 | 209 | 3488 | 2013-06-12 | 2013-06-12 | 150 | ¤ 2,000.00 |
| 504 | 203 | 3529 | 2013-03-11 | 2013-03-11 | 300 | ¤ 1,600.00 |
| 507 | 225 | 3002 | 2013-05-12 | 2013-05-22 | 120 | ¤ 1,000.00 |
| 510 | 220 | 3107 | 2013-05-01 | 2013-05-02 | 60 | ¤ 1,300.00 |
| 511 | 201 | 3142 | 2013-08-20 | 2013-08-21 | 50 | ¤ 700.00 |
| 512 | 211 | 3222 | 2013-04-04 | 2013-04-04 | 400 | ¤ 1,500.00 |
| 513 | 216 | 3007 | 2013-07-20 | 2013-07-22 | 80 | ¤ 3,600.00 |
| 515 | 202 | 3050 | 2013-09-08 | 2013-09-09 | 100 | ¤ 1,300.00 |
| 520 | 215 | 3002 | 2013-08-10 | 2013-08-10 | 60 | ¤ 800.00 |
| 521 | 206 | 3395 | 2013-06-03 | 2013-06-03 | 150 | ¤ 900.00 |
| 522 | 230 | 3190 | 2013-06-22 | 2013-06-26 | 125 | ¤ 3,250.00 |
| 525 | 212 | 3010 | 2013-07-11 | 2013-07-14 | 90 | ¤ 4,800.00 |
| 530 | 229 | 3204 | 2013-08-05 | 2013-08-07 | 150 | ¤ 2,700.00 |
| 531 | 205 | 3515 | 2013-11-16 | 2013-11-16 | 150 | ¤ 1,600.00 |
| 535 | 221 | 3003 | 2013-09-10 | 2013-09-10 | 80 | ¤ 800.00 |
| 536 | 222 | 3675 | 2013-02-20 | 2013-02-21 | 200 | ¤ 2,500.00 |
| 537 | 210 | 3611 | 2013-08-04 | 2013-08-06 | 70 | ¤ 2,100.00 |
| 540 | 211 | 3222 | 2014-04-10 | 2014-04-10 | 350 | ¤ 1,500.00 |
| 541 | 228 | 3628 | 2013-05-20 | 2013-05-20 | 150 | ¤ 700.00 |
| 545 | 203 | 3529 | 2014-03-15 | 2014-03-15 | 300 | ¤ 1,600.00 |
| 548 | 212 | 3395 | 2013-10-02 | 2013-10-02 | 60 | ¤ 900.00 |
| 550 | 229 | 3670 | 2013-11-05 | 2013-11-06 | 50 | ¤ 1,400.00 |
Chapter 17/Practice It/Art17.accdb
| ClassID | ClassName | Juniors | Cost | Length | Level |
|---|---|---|---|---|---|
| CL-293 | Clay Discovery | false | ¤ 100.00 | 45 | Beginning |
| CL-294 | Clay Handbuilding and Sculpture | false | ¤ 150.00 | 60 | Advanced |
| CL-295 | Clay Wheel Throwing I | false | ¤ 125.00 | 60 | Beginning |
| CL-296 | Clay Wheel Throwing II | false | ¤ 300.00 | 90 | Intermediate |
| DR-104 | Drawing Basics | false | ¤ 125.00 | 45 | Beginning |
| DR-105 | Drawing Portraits | false | ¤ 175.00 | 60 | Beginning |
| DR-106 | Cartooning I | false | ¤ 75.00 | 60 | Beginning |
| DR-107 | Cartooning II | false | ¤ 125.00 | 90 | Intermediate |
| PA-024 | Watercolor Basics | false | ¤ 90.00 | 45 | Beginning |
| PA-025 | Watercolor II | false | ¤ 150.00 | 90 | Advanced |
| PA-026 | Acrylics I | false | ¤ 150.00 | 45 | Beginning |
| PA-027 | Acrylics II | false | ¤ 250.00 | 90 | Intermediate |
| PH-311 | Photography I | false | ¤ 100.00 | 45 | Beginning |
| PH-312 | Photography II | false | ¤ 200.00 | 90 | Intermediate |
| PH-313 | Darkroom I | false | ¤ 175.00 | 90 | Beginning |
| PH-314 | Darkroom II | false | ¤ 350.00 | 120 | Intermediate |
| 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 | 1987-04-14 | M |
| AOF7548 | CL-295 | Alba | Fischer | 4972 Andell Road | Dublin | OH | 43017 | 614-555-7408 | 614-555-1275 | 1996-04-24 | F |
| BEA7502 | PH-312 | Brenda | Acker | 2122 Collins Avenue | Westerville | OH | 43081 | 614-555-0774 | 614-555-9117 | 1983-03-13 | F |
| BLK7509 | CL-293 | Betty | Kingsley | 2954 Bates Brothers Road | Columbus | OH | 43215 | 614-555-9182 | 614-555-0091 | 1996-04-10 | F |
| CAS7530 | DR-106 | Christopher | Soderlund | 2943 Quilly Lane | Upper Arlington | OH | 43221 | 614-555-5818 | 614-555-6876 | 1995-10-23 | M |
| CCH7542 | CL-296 | Christa | Harris | 4794 Viking Drive | Worthington | OH | 43085 | 740-555-1599 | 740-555-8337 | 1993-09-27 | F |
| CEH7584 | DR-104 | Chris | Hernandez | 3554 Olive Street | Bowling Green | OH | 43402 | 419-555-5926 | 419-555-8882 | 1982-04-13 | M |
| DAH7527 | PH-314 | Deanna | Hugo | 1735 Davis Place | Hamler | OH | 43524 | 419-555-8581 | 419-555-1972 | 1956-03-18 | F |
| DIR7511 | PH-311 | Delmar | Rector | 2043 Palmer Road | Worthington | OH | 43085 | 614-555-3375 | 614-555-0443 | 1967-11-22 | M |
| EAW7518 | PH-311 | Eddie | White | 403 Bates Brothers Road | Westerville | OH | 43081 | 614-555-0112 | 614-555-1956 | 1967-10-04 | M |
| GTB7545 | CL-293 | Gail | Broussard | 129 Quilly Lane | Westerville | OH | 43081 | 614-555-8448 | 614-555-4932 | 1975-02-20 | F |
| HAR7524 | PH-314 | Henry | Rose | 1676 Jessie Street | Lancaster | OH | 43130 | 740-555-7456 | 740-555-2790 | 1976-12-16 | M |
| HOC7545 | CL-295 | Horace | Chatman | 1508 Sole Lane | Columbus | OH | 43201 | 740-555-8715 | 740-555-7984 | 1997-09-23 | M |
| JAR7553 | PH-311 | James | Davis | 4152 Olive Street | Bowling Green | OH | 43402 | 419-555-2956 | 419-555-5951 | 1995-08-04 | M |
| JER7551 | PA-027 | James | Robinson | 2201 Stonecoal Road | Maumee | OH | 43537 | 419-555-6182 | 419-555-6303 | 1974-05-13 | M |
| JMN7538 | PH-313 | John | Navarro | 1765 Old Brickstone Drive | London | OH | 43140 | 740-555-1485 | 740-555-0202 | 1970-04-19 | M |
| JOW7531 | DR-104 | James | Woodruff | 3711 Old House Drive | Worthington | OH | 43085 | 740-555-4326 | 740-555-7712 | 1959-01-26 | M |
| LAB7533 | DR-105 | Larry | Britt | 976 Old House Drive | Westerville | OH | 43081 | 740-555-5202 | 740-555-1045 | 1996-12-12 | M |
| LIA7534 | CL-293 | Lisa | Anderson | 562 James Martin Circle | Pataskala | OH | 43062 | 614-555-7895 | 614-555-2410 | 1982-04-05 | F |
| LRT7544 | CL-293 | Leslie | Trevino | 1460 Palmer Road | Columbus | OH | 43215 | 614-555-0515 | 614-555-2277 | 1996-05-28 | F |
| MAE7556 | PH-312 | Marcus | Elam | 1914 Andell Road | Westerville | OH | 43081 | 614-555-6116 | 614-555-9511 | 1993-01-27 | M |
| MAP7549 | DR-105 | Marian | Pettit | 2972 Upland Avenue | Holland | OH | 43528 | 419-555-3288 | 419-555-7819 | 1968-12-06 | F |
| MIL7521 | CL-295 | Mercedes | Longino | 4900 Jessie Street | Centerburg | OH | 43011 | 740-555-5206 | 740-555-5573 | 1969-12-14 | F |
| PHF7522 | PA-025 | Paul | Frank | 2589 Cedarstone Drive | Maumee | OH | 43537 | 419-555-0216 | 419-555-7299 | 1970-02-22 | M |
| RAM7537 | PA-027 | Ruben | Moore | 3713 Viking Drive | Worthington | OH | 43085 | 740-555-2756 | 740-555-8002 | 1979-07-31 | M |
| REC7541 | CL-294 | Richard | Collins | 840 Birdhouse Drive | Alexandria | OH | 43001 | 740-555-5921 | 740-555-8902 | 1979-10-18 | M |
Chapter 17/Practice It/Health17.accdb
| MemberID | ProgramID | First | Last | Street | City | State | Zip | Status | DateJoined | Expiration |
|---|---|---|---|---|---|---|---|---|---|---|
| 1103 | 201 | Joseph | Eckler | 29 Prospect Street | Ashland | VA | 23005 | Active | 2013-01-16 | 2014-01-16 |
| 1105 | 204 | Barry | Hassan | 9 Harrington Avenue | Richmond | VA | 23220 | Active | 2013-03-02 | 2015-03-02 |
| 1106 | 202 | Debbie | Ward | 18 Barton Street | Richmond | VA | 23219 | Active | 2013-04-22 | 2013-10-22 |
| 1110 | 201 | Ashish | Mittal | 103 Hubbard Way | Glen Allen | VA | 23058 | On Hold | 2013-04-03 | 2014-04-03 |
| 1111 | 203 | Liz | Sorrento | 134 Lincoln Road | Chester | VA | 23831 | Active | 2013-02-10 | 2013-08-20 |
| 1115 | 203 | Michelle | Kim | 290 Brook Mill Road | Bon Air | VA | 23235 | Active | 2013-05-17 | 2015-05-17 |
| 1116 | 207 | Robert | DeCosta | 35 Washington Street | Richmond | VA | 23220 | Inactive | 2013-08-04 | 2014-08-04 |
| 1117 | 203 | Paul | Novick | 302 Great Road | Ashland | VA | 23005 | Active | 2013-09-20 | 2015-09-20 |
| 1120 | 202 | Carmen | Sanchez | 1294 Monument Avenue | Richmond | VA | 23219 | On Hold | 2013-10-18 | 2014-09-25 |
| 1121 | 209 | Kelly | Smith | 7 Lakeview Road | Chester | VA | 23831 | Active | 2013-07-18 | 2014-07-18 |
| 1125 | 203 | Jessica | Picard | 17 Briarwood Lane | Mechanicsville | VA | 23111 | Active | 2013-06-22 | 2013-12-22 |
| 1126 | 204 | Sam | Bethel | 258 Elm Street | Mechanicsville | VA | 23111 | Active | 2013-05-19 | 2014-05-19 |
| 1131 | 207 | Olivia | Alexander | 29 Newtown Circle | Richmond | VA | 23220 | Active | 2013-03-11 | 2015-03-11 |
| 1135 | 201 | Tina | Sun | 682 Hickory Way | Chester | VA | 23831 | Active | 2013-06-03 | 2014-06-03 |
| 1136 | 212 | Mary | Grant | 913 Main Street | Chester | VA | 23831 | Active | 2013-05-01 | 2015-05-01 |
| 1137 | 210 | Alan | Fraser | 41 Carver Hill Road | Mechanicsville | VA | 23111 | Active | 2013-03-20 | 2014-03-20 |
| 1139 | 210 | Peter | Grigas | 3 Pleasant Street | Glen Allen | VA | 23058 | Inactive | 2013-06-09 | 2015-06-09 |
| 1140 | 206 | Ronald | Cunningham | 52 Putnam Road | Ashland | VA | 23005 | Active | 2013-02-04 | 2013-08-04 |
| 1142 | 207 | Kye | Nguyen | 456 Harringont Avenue | Richmond | VA | 23220 | On Hold | 2013-02-20 | 2015-02-20 |
| 1143 | 206 | Barry | Feinberg | 73 Endicott Avenue | Chester | VA | 23831 | Active | 2013-10-05 | 2014-10-05 |
| 1144 | 208 | Colleen | Murphy | 47 Winter Street | Mechanicsville | VA | 23111 | Active | 2013-06-09 | 2014-06-09 |
| 1146 | 209 | Marlene | Halpin | 75 Elm Boulevard | Bon Air | VA | 23235 | On Hold | 2013-07-17 | 2015-07-17 |
| 1147 | 210 | Elijah | Slomich | 108 Roosevelt Avenue | Mechanicsville | VA | 23111 | On Hold | 2013-08-02 | 2015-08-02 |
| 1148 | 212 | Todd | Wolfe | 18 Parker Avenue | Richmond | VA | 23219 | Active | 2013-09-20 | 2014-09-20 |
| 1150 | 203 | Zach | Adgate | 92 Apple Blossom Lane | Ashland | VA | 23005 | Active | 2013-10-15 | 2014-10-15 |
| 1151 | 202 | Isabella | Cimino | 429 South Street | Ashland | VA | 23005 | Active | 2013-08-02 | 2014-08-02 |
| 1153 | 212 | Vinnie | Tumbiolo | 358 East Street | Richmond | VA | 23219 | Inactive | 2013-05-19 | 2015-05-29 |
| 1154 | 204 | Jamal | Asmal | 9872 Turnpike Road | Richmond | VA | 23220 | Active | 2013-06-07 | 2014-06-07 |
| 1155 | 210 | Juliette | Beaumont | 35 Walnut Street | Glen Allen | VA | 23058 | Active | 2013-08-01 | 2014-08-01 |
| 1156 | 208 | Kurt | Eisler | 5 Bradford Circle | Richmond | VA | 23220 | On Hold | 2013-04-17 | 2015-04-17 |
| 1158 | 201 | Pedro | Fuente | 9 Mockingbird Lane | Chester | VA | 23831 | Active | 2013-09-05 | 2014-09-05 |
| 1159 | 211 | Maggie | Hadley | 6 Rose Court | Ashland | VA | 23005 | Active | 2013-03-19 | 2014-03-19 |
| 1160 | 212 | Mark | Reynolds | 11 Pond Lane | Mechanicsville | VA | 23111 | Active | 2013-06-20 | 2015-06-20 |
| 1165 | 207 | Shea | McKiernan | 780 Flint Street | Ashland | VA | 23005 | Active | 2013-07-13 | 2014-07-13 |
| 1166 | 203 | Abigail | Turner | 99 Maple Road | Richmond | VA | 23219 | On Hold | 2013-09-01 | 2015-09-01 |
| 1167 | 204 | George | Krukonis | 14 Collins Drive | Richmond | VA | 23219 | Active | 2013-05-05 | 2014-05-05 |
| 1169 | 211 | Maria | Gonzalez | 100 Tower Drive | Richmond | VA | 23220 | Active | 2013-05-19 | 2014-05-19 |
| 1170 | 203 | Student First | Student Last | 40 Green Boulevard | Bon Air | VA | 23235 | Active | 2013-06-03 | 2013-12-03 |
| 1172 | 211 | Ed | Curran | 25 Fairway Drive | Richmond | VA | 23220 | Active | 2013-11-16 | 2014-11-16 |
| ProgramID | ProgramType | MonthlyFee | StartDate | PhysicalRequired |
|---|---|---|---|---|
| 201 | Youth Full (ages 13-17) | ¤ 50.00 | true | |
| 202 | Youth Limited (ages 13-17) | ¤ 30.00 | true | |
| 203 | College Full | ¤ 50.00 | true | |
| 204 | Young Adult Full (ages 18-35) | ¤ 65.00 | false | |
| 206 | Young Adult Limited (ages 18-35) | ¤ 35.00 | false | |
| 207 | Adult Full (ages 36-50) | ¤ 60.00 | false | |
| 208 | Adult Limited (ages 36-50) | ¤ 45.00 | false | |
| 209 | Starter Senior Full (ages 51-65) | ¤ 50.00 | true | |
| 210 | Starter Senior Limited (ages 51-65) | ¤ 35.00 | true | |
| 211 | Senior Full (ages 66 and over) | ¤ 50.00 | true | |
| 212 | Senior Limited (ages 66 and over) | ¤ 30.00 | true |
Chapter 17/Practice It/Snow17.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 Living 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 |
| AgreementNum | ClientID | InvDate | InvAmt | Paid | InvNo |
|---|---|---|---|---|---|
| 1301 | 1 | 2013-01-09 | ¤ 30.00 | true | 1301-001 |
| 1418 | 19 | 2014-11-26 | ¤ 25.00 | true | 1411-026 |
| 1301 | 1 | 2013-01-29 | ¤ 120.00 | true | 1301-009 |
| 1306 | 12 | 2013-01-16 | ¤ 700.00 | true | 1301-005 |
| 1408 | 7 | 2014-10-22 | ¤ 20.00 | true | 1410-016 |
| 1316 | 22 | 2013-12-17 | ¤ 335.00 | true | 1312-023 |
| 1313 | 13 | 2013-12-28 | ¤ 700.00 | true | 1312-029 |
| 1401 | 13 | 2014-11-30 | ¤ 1,400.00 | true | 1411-027 |
| 1415 | 21 | 2014-12-29 | ¤ 1,100.00 | false | 1412-034 |
| 1402 | 26 | 2014-01-16 | ¤ 120.00 | true | 1401-001 |
| 1302 | 19 | 2013-01-10 | ¤ 20.00 | true | 1301-004 |
| 1302 | 19 | 2013-01-29 | ¤ 80.00 | true | 1301-012 |
| 1307 | 3 | 2013-01-29 | ¤ 120.00 | true | 1301-008 |
| 1409 | 14 | 2014-10-23 | ¤ 20.00 | true | 1410-017 |
| 1309 | 5 | 2013-11-20 | ¤ 35.00 | true | 1311-015 |
| 1312 | 15 | 2014-01-30 | ¤ 2,200.00 | true | 1401-007 |
| 1317 | 20 | 2013-12-28 | ¤ 80.00 | true | 1312-028 |
| 1404 | 4 | 2014-02-28 | ¤ 1,160.00 | true | 1402-012 |
| 1319 | 18 | 2013-12-28 | ¤ 350.00 | true | 1312-027 |
| 1412 | 6 | 2014-11-10 | ¤ 19.00 | true | 1411-020 |
| 1418 | 19 | 2014-12-29 | ¤ 75.00 | false | 1412-037 |
| 1421 | 11 | 2014-12-09 | ¤ 25.00 | true | 1412-030 |
| 1411 | 3 | 2014-12-29 | ¤ 66.00 | false | 1412-044 |
| 1408 | 7 | 2014-12-29 | ¤ 80.00 | false | 1412-038 |
| 1309 | 5 | 2013-12-28 | ¤ 140.00 | true | 1312-030 |
| 1416 | 1 | 2014-11-25 | ¤ 30.00 | true | 1411-023 |
| 1310 | 14 | 2013-11-30 | ¤ 20.00 | true | 1311-016 |
| 1402 | 26 | 2014-01-30 | ¤ 480.00 | true | 1401-009 |
| 1318 | 24 | 2013-12-28 | ¤ 80.00 | true | 1312-026 |
| 1413 | 16 | 2014-11-20 | ¤ 1,110.00 | true | 1411-021 |
| 1422 | 25 | 2014-12-11 | ¤ 100.00 | true | 1412-031 |
| 1412 | 6 | 2014-12-29 | ¤ 76.00 | false | 1412-040 |
| 1405 | 8 | 2014-02-28 | ¤ 50.00 | false | 1402-011 |
| 1405 | 8 | 2014-01-22 | ¤ 25.00 | true | 1401-004 |
| 1413 | 16 | 2014-12-29 | ¤ 1,220.00 | false | 1412-041 |
| 1403 | 12 | 2014-01-16 | ¤ 250.00 | true | 1401-002 |
| 1303 | 4 | 2013-01-29 | ¤ 1,200.00 | false | 1301-011 |
| 1316 | 22 | 2013-12-28 | ¤ 1,340.00 | true | 1312-025 |
| 1311 | 11 | 2013-12-06 | ¤ 25.00 | true | 1312-017 |
| 1406 | 5 | 2014-01-25 | ¤ 50.00 | true | 1401-005 |
| 1414 | 17 | 2014-11-25 | ¤ 25.00 | true | 1411-024 |
| 1401 | 13 | 2014-10-12 | ¤ 350.00 | true | 1410-014 |
| 1407 | 2 | 2014-12-29 | ¤ 68.00 | false | 1412-042 |
| 1404 | 4 | 2014-01-22 | ¤ 290.00 | true | 1401-003 |
| 1312 | 15 | 2013-12-08 | ¤ 1,100.00 | true | 1312-018 |
| 1304 | 16 | 2013-02-28 | ¤ 2,800.00 | true | 1302-014 |
| 1314 | 9 | 2013-12-28 | ¤ 1,120.00 | true | 1312-024 |
| 1313 | 13 | 2014-01-30 | ¤ 1,050.00 | true | 1401-008 |
| 1304 | 16 | 2013-01-16 | ¤ 700.00 | true | 1301-007 |
| 1317 | 20 | 2013-12-17 | ¤ 20.00 | true | 1312-022 |
| 1403 | 12 | 2014-01-30 | ¤ 1,000.00 | true | 1401-010 |
| 1414 | 17 | 2014-12-29 | ¤ 50.00 | false | 1412-043 |
| 1308 | 25 | 2013-01-29 | ¤ 450.00 | true | 1301-013 |
| 1314 | 9 | 2013-12-08 | ¤ 280.00 | true | 1312-019 |
| 1410 | 24 | 2014-11-04 | ¤ 25.00 | true | 1411-019 |
| 1311 | 11 | 2013-12-28 | ¤ 100.00 | true | 1312-033 |
| 1423 | 15 | 2014-12-17 | ¤ 1,000.00 | false | 1412-032 |
| 1303 | 4 | 2013-01-10 | ¤ 300.00 | true | 1301-003 |
| 1417 | 10 | 2014-11-25 | ¤ 110.00 | true | 1411-025 |
| 1419 | 23 | 2014-12-02 | ¤ 315.00 | true | 1412-028 |
| 1319 | 18 | 2014-01-30 | ¤ 400.00 | false | 1401-006 |
| 1410 | 24 | 2014-12-29 | ¤ 100.00 | false | 1412-039 |
| 1310 | 14 | 2013-12-28 | ¤ 80.00 | true | 1312-034 |
| 1312 | 15 | 2013-12-28 | ¤ 1,200.00 | true | 1312-032 |
| 1416 | 1 | 2014-12-29 | ¤ 60.00 | false | 1412-036 |
| 1407 | 2 | 2014-10-19 | ¤ 17.00 | false | 1410-015 |
| 1315 | 17 | 2013-12-28 | ¤ 76.00 | true | 1312-031 |
| 1420 | 9 | 2014-12-09 | ¤ 290.00 | true | 1412-029 |
| 1318 | 24 | 2013-12-17 | ¤ 20.00 | true | 1312-021 |
| 1409 | 14 | 2014-12-29 | ¤ 80.00 | false | 1412-035 |
| 1306 | 12 | 2013-01-29 | ¤ 1,000.00 | true | 1301-010 |
| 1315 | 17 | 2013-12-11 | ¤ 19.00 | true | 1312-020 |
| 1415 | 21 | 2014-11-25 | ¤ 550.00 | true | 1411-022 |
| 1406 | 5 | 2014-02-28 | ¤ 200.00 | true | 1402-013 |
| 1417 | 10 | 2014-12-29 | ¤ 220.00 | false | 1412-033 |
| 1307 | 3 | 2013-01-10 | ¤ 20.00 | true | 1301-002 |
| 1411 | 3 | 2014-11-04 | ¤ 33.00 | true | 1411-018 |
| 1305 | 7 | 2013-01-16 | ¤ 100.00 | true | 1301-006 |
| Client ID | Amount | Date Signed | AgreementNum |
|---|---|---|---|
| 1 | ¤ 150.00 | 2013-01-09 | 1301 |
| 19 | ¤ 100.00 | 2013-01-10 | 1302 |
| 4 | ¤ 1,500.00 | 2013-01-10 | 1303 |
| 16 | ¤ 3,500.00 | 2013-01-16 | 1304 |
| 7 | ¤ 100.00 | 2013-01-16 | 1305 |
| 12 | ¤ 1,250.00 | 2013-01-19 | 1306 |
| 3 | ¤ 120.00 | 2013-01-22 | 1307 |
| 25 | ¤ 450.00 | 2013-01-29 | 1308 |
| 5 | ¤ 175.00 | 2013-11-20 | 1309 |
| 14 | ¤ 100.00 | 2013-11-30 | 1310 |
| 11 | ¤ 125.00 | 2013-12-06 | 1311 |
| 13 | ¤ 1,750.00 | 2013-12-08 | 1312 |
| 9 | ¤ 1,400.00 | 2013-12-08 | 1313 |
| 15 | ¤ 4,500.00 | 2013-12-08 | 1314 |
| 17 | ¤ 95.00 | 2013-12-11 | 1315 |
| 22 | ¤ 1,675.00 | 2013-12-17 | 1316 |
| 20 | ¤ 100.00 | 2013-12-17 | 1317 |
| 24 | ¤ 100.00 | 2013-12-17 | 1318 |
| 18 | ¤ 750.00 | 2013-12-29 | 1319 |
| 26 | ¤ 600.00 | 2014-01-16 | 1401 |
| 12 | ¤ 1,250.00 | 2014-01-16 | 1402 |
| 4 | ¤ 1,450.00 | 2014-01-22 | 1403 |
| 8 | ¤ 75.00 | 2014-01-22 | 1404 |
| 5 | ¤ 250.00 | 2014-01-25 | 1405 |
| 13 | ¤ 1,750.00 | 2014-10-12 | 1406 |
| 2 | ¤ 85.00 | 2014-10-19 | 1407 |
| 7 | ¤ 100.00 | 2014-10-22 | 1408 |
| 14 | ¤ 100.00 | 2014-10-23 | 1409 |
| 24 | ¤ 125.00 | 2014-11-04 | 1410 |
| 3 | ¤ 165.00 | 2014-11-04 | 1411 |
| 6 | ¤ 95.00 | 2014-11-10 | 1412 |
| 16 | ¤ 3,555.00 | 2014-11-20 | 1413 |
| 21 | ¤ 2,750.00 | 2014-11-25 | 1414 |
| 1 | ¤ 150.00 | 2014-11-25 | 1415 |
| 10 | ¤ 550.00 | 2014-11-25 | 1416 |
| 17 | ¤ 125.00 | 2014-11-25 | 1417 |
| 19 | ¤ 125.00 | 2014-11-26 | 1418 |
| 23 | ¤ 1,575.00 | 2014-12-02 | 1419 |
| 9 | ¤ 1,450.00 | 2014-12-09 | 1420 |
| 11 | ¤ 125.00 | 2014-12-09 | 1421 |
| 25 | ¤ 500.00 | 2014-12-11 | 1422 |
| 15 | ¤ 5,000.00 | 2014-12-17 | 1423 |
