need help to those tutorials for my computer information class, Access data base

profilemalk60
access_tutorials_1-4.zip
Home>Information Systems homework help>need help to those tutorials for my computer information class, Access data base

Access1/Case1/Lessons.xlsx

Sheet1

ContractID StudentID TeacherID StartDate EndDate LessonType LessonLength LessonCost RentalCost
3100 CAR7534 13-1100 3/31/12 3/31/13 Piano 30 130.00 0.00
3102 MEH7551 63-1554 5/18/13 5/18/14 Guitar 30 100.00 30.00
3103 MAK7556 34-4506 6/15/13 12/15/13 Violin 30 100.00 0.00
3105 BUR7559 22-0102 4/8/12 4/8/13 Cello 60 280.00 50.00
3107 MIL7512 22-0102 6/15/13 6/15/14 Piano 60 260.00 0.00
3108 SHA7522 63-1554 6/17/12 6/17/13 Guitar 30 100.00 30.00
3110 HIR7521 17-1798 9/9/12 9/9/13 Percussion 30 120.00 0.00
3113 YAM7535 91-0178 9/10/12 9/10/13 Violin 60 280.00 0.00
3114 MEN7541 70-4490 9/10/12 9/10/13 Guitar 60 200.00 30.00
3117 BRA7545 55-5310 3/11/13 3/11/14 Voice 30 120.00 0.00
3119 BAR7544 55-5310 9/15/12 3/15/13 Voice 30 100.00 0.00
3121 ROC7545 96-2151 9/20/13 9/20/14 Guitar 30 100.00 0.00
3122 SMI7538 17-1798 8/24/12 2/24/13 Percussion 30 120.00 75.00
3125 TEA7562 22-0102 10/1/12 10/1/13 Cello 60 280.00 50.00
3126 MCE7551 70-4490 12/1/12 6/1/13 Guitar 30 100.00 30.00
3128 FOR7548 72-0005 4/7/13 10/7/13 Violin 30 100.00 35.00
3130 TAN7549 72-0005 4/26/13 4/26/14 Violin 60 200.00 35.00
3133 LAM7537 63-1554 9/2/13 9/2/14 Saxophone 60 200.00 25.00
3136 HAV7535 55-5310 5/17/12 5/17/13 Voice 30 120.00 0.00
3137 BOL7533 63-1554 1/9/13 1/9/14 Guitar 60 200.00 30.00
3139 ECK7542 96-2151 7/15/13 7/15/14 Guitar 60 200.00 30.00
3141 KAL7530 13-1100 3/23/13 3/23/14 Piano 30 130.00 0.00
3144 LIM7553 70-4490 10/15/12 10/15/13 Guitar 30 100.00 0.00
3145 BRA7545 98-9123 9/14/13 9/14/14 Flute 30 130.00 25.00
3146 MIL7512 63-1554 12/1/13 6/1/14 Guitar 30 100.00 0.00
3147 GRE7502 96-2151 9/13/13 9/13/14 Saxophone 30 100.00 25.00
3148 APP7509 17-1798 2/1/12 2/1/13 Percussion 30 120.00 75.00
3150 THO7505 77-1201 2/2/13 2/2/14 Voice 30 100.00 0.00
3152 RIV7511 17-1798 2/2/13 8/2/13 Percussion 60 260.00 75.00
3153 PEN7515 98-9123 10/5/13 10/5/14 Flute 30 130.00 0.00
3156 HAM7518 96-2151 8/4/13 8/4/14 Saxophone 60 200.00 0.00
3157 YAM7535 13-1100 5/20/13 11/20/13 Piano 30 130.00 0.00
3158 GIL7529 91-0178 3/15/13 3/15/14 Violin 60 280.00 35.00
3162 CAR7534 13-1100 3/31/13 3/31/14 Piano 30 130.00 0.00
3164 MEH7551 63-1554 9/21/13 3/21/14 Saxophone 30 100.00 0.00
3165 BUR7559 22-0102 4/8/13 4/8/14 Cello 30 140.00 50.00
3166 COR7531 22-0102 6/16/12 12/16/12 Piano 30 125.00 0.00
3167 TAN7549 13-1100 11/3/13 11/3/14 Piano 30 130.00 0.00
3168 GAR7553 34-4506 6/16/12 6/16/13 Violin 30 100.00 0.00
3169 SHA7522 63-1554 6/17/13 6/17/14 Guitar 30 100.00 0.00
3170 KAL7530 34-4506 10/20/13 4/20/14 Violin 30 100.00 35.00
3171 HIR7521 17-1798 9/9/13 9/9/14 Percussion 60 260.00 0.00
3172 MEN7541 70-4490 9/10/13 9/10/14 Guitar 30 100.00 0.00
3174 BAR7544 77-1201 3/15/13 9/15/13 Voice 30 100.00 0.00
3175 SMI7538 17-1798 2/24/13 2/24/14 Percussion 60 260.00 0.00

Sheet2

Sheet3

Access1/Case1/Music.accdb

ID Last Name First Name Address City State Zip

Access1/Case1/Piano.bmp

Access1/Case1/School.accdb

TeacherID FirstName LastName Degree School HireDate
63-1554 Carey Eberle BM University of Oregon 2012-06-03
70-4490 Roger Norris BA University of Portland 2012-09-02
72-0005 Sachi Tanaka BM Lawrence University 2013-03-30
77-1201 Joy Culbertson BM Reed College 2013-01-25
91-0178 Fred Bishop DMA Eastman School of Music 2012-08-14
96-2151 Eric Mueller BA Whitman College 2013-06-22
98-9123 Diana Reese MM Berklee College of Music 2013-09-02

Access1/Case1/Student.txt

BOL7533 Eddie Bolton 320 Main St Gresham OR 97236 503-760-5326 503-760-1045 6/12/1997 0:00:00 M
BRA7545 Lindsay Brandenburg 78 Calaveras Ct Beaverton OR 97007 503-672-4409 503-579-4932 8/20/2000 0:00:00 F
BUR7500 Joshua Burgess 11250 SW Walnut St Portland OR 97223 541-563-1135 541-563-0219 1/12/1999 0:00:00 M
BUR7559 Sara Burmeister 279 Summer St Cornelius OR 97113 503-357-8410 503-357-9625 9/24/2001 0:00:00 F
CAR7534 Nicki Carroll 1401 Lorraine Dr Beaverton OR 97229 503-617-3045 503-617-2410 10/5/1999 0:00:00 F
COR7531 Mary Beth Corbett 205 Cedar St Fairview OR 97030 503-674-0838 503-674-7712 7/26/2002 0:00:00 F
ECK7542 Mark Eckstein 12830 SW Trigger Dr Beaverton OR 97008 503-524-9610 503-646-8337 3/27/2001 0:00:00 M
FOR7548 Nicole Forrest 19210 SE Division St Portland OR 97266 503-256-2368 503-968-1275 10/24/2003 0:00:00 F
GAR7553 Brett Garver 17015 NW Holcomb Dr Portland OR 97229 503-690-8879 503-690-5951 2/4/2002 0:00:00 M
GIL7529 Aimee Gilbertson 11763 SE Reedway St Portland OR 97266 503-762-3027 503-762-1033 11/29/1998 0:00:00 F
GRE7502 Melissa Greco 1329 SE 135th Ave Portland OR 97233 503-256-4038 503-256-9117 9/13/2001 0:00:00 F
HAM7518 Akashi Hamada 130 Maple Ave Beaverton OR 97229 503-617-7433 503-617-1956 4/4/2000 0:00:00 M
HAV7535 Laurie Haverford 11286 SW Walnut St Portland OR 97223 541-563-7566 541-563-3904 12/2/2001 0:00:00 F
HIR7521 Erica Hirsch 655 Langley Rd Cornelius OR 97123 503-547-2553 503-547-5573 6/14/2000 0:00:00 F
KAL7530 Ansis Kalnajs 5504 SW 14th Ave Portland OR 97239 503-246-8864 503-246-6876 4/23/2000 0:00:00 M
LAM7537 Blake Lamont 14305 SE Powell Blvd Portland OR 97236 503-761-1430 503-761-8002 1/31/1999 0:00:00 M
LIM7553 Youngho Lim 14320 SW Barlow Rd Beaverton OR 97008 503-430-6218 503-430-1018 3/15/2000 0:00:00 M
MAK7556 Kim Maki 15500 SW Allen St Portland OR 97223 541-563-6639 541-563-9511 7/27/1999 0:00:00 F
MCE7551 Danny McElroy 1965 Alpine St Cornelius OR 97113 503-530-1269 503-530-7722 12/13/1998 0:00:00 M
MEH7551 Amrita Mehta 18615 Yamhill Circle Portland OR 97233 503-491-0559 503-491-6303 11/13/2002 0:00:00 F
MEN7541 James Mendoza 1347 Lancewood St Beaverton OR 97008 503-646-1155 503-646-8902 4/18/1997 0:00:00 M
MIL7512 Andy Miller 6168 NE Rosebay Dr Hillsboro OR 97124 503-681-3379 503-617-9245 2/16/1999 0:00:00 M
PAP7524 Teddy Pappas 78 Fairview Rd Beaverton OR 97007 503-672-6004 503-672-2790 6/16/2003 0:00:00 M
PEN7515 Dana Pennimore 4015 SE 149th Ave Portland OR 97236 503-761-8155 503-761-3581 11/20/1997 0:00:00 F
RIV7511 John Rivera 5436 NE Farmcrest St Hillsboro OR 97124 503-640-1517 503-640-0443 5/22/1999 0:00:00 M
ROC7545 Max Roche 2385 Overlook Dr Hillsboro OR 97124 503-617-3717 503-617-7984 3/23/1998 0:00:00 M
SHA7522 Stacey Shanahan 17440 Holcomb Dr Portland OR 97229 541-563-7998 541-563-7299 8/22/2002 0:00:00 F
SMI7538 Wilson Smith 1634 Marian St Gresham OR 97233 503-258-4232 503-258-0202 10/19/1998 0:00:00 M
TAN7549 Kendra Tang 2350 SE 157th Ave Portland OR 97233 503-761-7302 503-761-7819 6/6/2002 0:00:00 F
TEA7562 Jeff Tealey 265 Elm St Hillsboro OR 97124 503-617-1027 503-617-3388 10/14/2003 0:00:00 M
THO7505 Maddie Thorsten 60 Yearling Ct Beaverton OR 97008 503-524-2125 503-524-8842 7/24/1999 0:00:00 F
VAR7527 Kristin Vargas 11084 SE 63rd St Portland OR 97222 503-762-5928 503-968-1972 9/18/1998 0:00:00 F
YAM7535 Angie Yamamoto 8850 SW Burnham St Portland OR 97223 503-603-9451 503-603-8841 9/30/1996 0:00:00 F

Access1/Case2/Center.xlsx

Sheet1

MemberID ProgramID First Last Street City State Zip Phone DateJoined Expiration Status InitiationFeeWaived
1103 201 Joseph Eckler 29 Prospect Street Ashland VA 23005 804-550-3050 01/16/2013 01/16/2014 Active TRUE
1105 204 Barry Hassan 9 Harrington Avenue Richmond VA 23220 804-236-6717 03/02/2013 03/02/2015 Active FALSE
1106 202 Debbie Ward 18 Barton Street Richmond VA 23219 804-674-8462 04/22/2013 10/22/2013 Active TRUE
1110 201 Ashish Mittal 103 Hubbard Way Glen Allen VA 23058 804-553-4737 04/03/2013 04/03/2014 On Hold TRUE
1111 203 Liz Sorrento 134 Lincoln Road Chester VA 23831 804-751-1270 02/10/2013 08/20/2013 Active FALSE
1115 203 Michelle Kim 290 Brook Mill Road Bon Air VA 23235 804-323-0291 05/17/2013 05/17/2015 Active FALSE
1116 207 Robert DeCosta 35 Washington Street Richmond VA 23220 804-236-4121 08/04/2013 08/04/2014 Inactive TRUE
1117 203 Paul Novick 302 Great Road Ashland VA 23005 804-550-1164 09/20/2013 09/20/2015 Active FALSE
1120 202 Carmen Sanchez 1294 Monument Avenue Richmond VA 23219 804-674-5991 10/18/2013 09/25/2014 On Hold FALSE
1121 209 Kelly Smith 7 Lakeview Road Chester VA 23831 804-751-0466 07/18/2013 07/18/2014 Active FALSE
1125 203 Jessica Picard 17 Briarwood Lane Mechanicsville VA 23111 804-559-0909 06/22/2013 12/22/2013 Active FALSE
1126 204 Sam Bethel 258 Elm Street Mechanicsville VA 23111 804-559-1750 05/19/2013 05/19/2014 Active TRUE
1130 205 John Ziminsky 1702 Hunter Avenue Chester VA 23831 804-751-4052 10/05/2013 10/05/2015 On Hold FALSE
1131 207 Olivia Alexander 29 Newtown Circle Richmond VA 23220 804-236-0642 03/11/2013 03/11/2015 Active FALSE
1135 201 Tina Sun 682 Hickory Way Chester VA 23831 804-751-9111 06/03/2013 06/03/2014 Active FALSE
1136 212 Mary Grant 913 Main Street Chester VA 23831 804-751-8772 05/01/2013 05/01/2015 Active FALSE
1137 210 Alan Fraser 41 Carver Hill Road Mechanicsville VA 23111 804-559-5885 03/20/2013 03/20/2014 Active TRUE
1139 210 Peter Grigas 3 Pleasant Street Glen Allen VA 23058 804-553-1642 06/09/2013 06/09/2015 Inactive TRUE
1140 206 Ronald Cunningham 52 Putnam Road Ashland VA 23005 804-550-7732 02/04/2013 08/04/2013 Active FALSE
1142 207 Kye Nguyen 456 Harringont Avenue Richmond VA 23220 804-236-0325 02/20/2013 02/20/2015 On Hold FALSE
1143 206 Barry Feinberg 73 Endicott Avenue Chester VA 23831 804-751-1119 10/05/2013 10/05/2014 Active FALSE
1144 208 Colleen Murphy 47 Winter Street Mechanicsville VA 23111 804-559-1651 06/09/2013 06/09/2014 Active FALSE
1146 209 Marlene Halpin 75 Elm Boulevard Bon Air VA 23235 804-323-0346 07/17/2013 07/17/2015 On Hold FALSE
1147 210 Elijah Slomich 108 Roosevelt Avenue Mechanicsville VA 23111 804-559-5060 08/02/2013 08/02/2015 On Hold FALSE
1148 212 Todd Wolfe 18 Parker Avenue Richmond VA 23219 804-674-2140 09/20/2013 09/20/2014 Active TRUE
1150 203 Zach Adgate 92 Apple Blossom Lane Ashland VA 23005 804-550-6119 10/15/2013 10/15/2014 Active FALSE
1151 202 Isabella Cimino 429 South Street Ashland VA 23005 804-550-9870 08/02/2013 08/02/2014 Active FALSE
1153 212 Vinnie Tumbiolo 358 East Street Richmond VA 23219 804-674-1434 05/19/2013 05/29/2015 Inactive FALSE
1154 204 Jamal Asmal 9872 Turnpike Road Richmond VA 23220 804-236-2194 06/07/2013 06/07/2014 Active TRUE
1155 210 Juliette Beaumont 35 Walnut Street Glen Allen VA 23058 804-553-1275 08/01/2013 08/01/2014 Active FALSE
1156 208 Kurt Eisler 5 Bradford Circle Richmond VA 23220 804-236-8961 04/17/2013 04/17/2015 On Hold FALSE
1158 201 Pedro Fuente 9 Mockingbird Lane Chester VA 23831 804-751-6333 09/05/2013 09/05/2014 Active FALSE
1159 211 Maggie Hadley 6 Rose Court Ashland VA 23005 804-550-6103 03/19/2013 03/19/2014 Active TRUE
1160 212 Mark Reynolds 11 Pond Lane Mechanicsville VA 23111 804-559-4642 06/20/2013 06/20/2015 Active FALSE
1165 207 Shea McKiernan 780 Flint Street Ashland VA 23005 804-550-0107 07/13/2013 07/13/2014 Active TRUE
1166 203 Abigail Turner 99 Maple Road Richmond VA 23219 804-674-6807 09/01/2013 09/01/2015 On Hold TRUE
1167 204 George Krukonis 14 Collins Drive Richmond VA 23219 804-674-4333 05/05/2013 05/05/2014 Active TRUE
1169 211 Maria Gonzalez 100 Tower Drive Richmond VA 23220 804-236-6337 05/19/2013 05/19/2014 Active FALSE

Sheet2

Sheet3

Access1/Case2/Health.accdb

ProgramID ProgramType MonthlyFee PhysicalRequired
205 Adult1 Full (ages 26-35) ¤ 60.00 No
206 Adult1 Limited (ages 26-35) ¤ 45.00 No
207 Adult2 Full (ages 36-50) ¤ 60.00 No
208 Adult2 Limited (ages 36-50) ¤ 45.00 No
209 Senior1 Full (ages 51-65) ¤ 50.00 Yes
210 Senior1 Limited (ages 51-65) ¤ 35.00 Yes
211 Senior2 Full (ages 66 and over) ¤ 40.00 Yes
212 Senior2 Limited (ages 66 and over) ¤ 30.00 Yes

Access1/Case2/Weights.bmp

Access1/Case3/Agency.txt

N33 Daycare and Family Services Renee Baker 825 Manchester Rd Salina KS 67401 785-825-5402
N57 Disability Resources Bureau Amy Hoffman 203 N. Kansas Ave Salina KS 67401 785-825-0922
R15 Elder Services Division Ed Rindahl 102 Jefferson St Junction City KS 67441 785-210-7740
R31 Mental Health of Salina Wayne Althorp 305 N. Kansas Ave Salina KS 67401 785-825-5060
R86 Workforce Development Office Nina Williams 400 Main St Abilene KS 67410 785-263-4255
W22 Vocational Rehabilitation Kelly Kaysen 601 Midtown Rd McPherson KS 67460 620-241-0889
W43 Kansas Social Services Ray Showalter 900 Sheridan St Salina KS 67401 785-827-4939
Y68 After School Youth Linda Mercier 131 W. 18th St Junction City KS 67441 785-761-7147

Access1/Case3/Gifts.xlsx

Sheet1

DonationID DonorID AgencyID DonationDate Description DonationValue Pickup
2100 36001 K82 01/12/2013 Cash $30.00 FALSE
2103 36033 N57 06/02/2013 Small rugs $40.00 FALSE
2105 36001 K64 03/10/2013 Cash $40.00 FALSE
2108 36062 W22 05/17/2013 Computer equipment $225.00 TRUE
2110 36041 R31 09/07/2013 Cookware $35.00 FALSE
2112 36060 Y68 03/05/2013 Cash $100.00 FALSE
2115 36056 N57 03/19/2013 Cash $25.00 FALSE
2116 36001 K82 06/01/2013 Kitchen table and chairs $347.25 TRUE
2119 36051 W22 04/23/2013 Table saw $265.00 TRUE
2121 36058 K64 02/24/2013 Vacuum cleaner $84.00 FALSE
2124 36055 Y68 02/02/2013 Children's furniture $265.50 TRUE
2125 36077 R31 03/03/2013 Small appliances $180.00 FALSE
2126 36019 N57 04/04/2013 Cash $75.00 FALSE
2128 36065 R15 10/07/2013 Humidifier $65.00 FALSE
2129 36012 R86 08/30/2013 Business suits $150.00 FALSE
2131 36049 N33 01/03/2013 Snow blower $230.00 TRUE
2133 36042 W22 06/25/2013 Cash $50.00 FALSE
2136 36037 W43 01/31/2013 Table linens $45.00 FALSE
2137 36062 R31 11/01/2013 Desk lamps $78.00 FALSE
2142 36064 N33 08/26/2013 Bookshelves $238.75 TRUE
2144 36058 N57 11/12/2013 Sofa and chairs $560.00 TRUE
2145 36020 R15 05/10/2013 Cash $25.00 FALSE
2147 36032 R15 04/17/2013 Washer and dryer $225.00 TRUE
2148 36037 W22 03/10/2013 Cash $75.00 FALSE
2150 36073 Y68 05/28/2013 Office equipment $305.50 TRUE
2151 36037 N33 05/06/2013 Cash $35.00 FALSE
2153 36070 N57 02/02/2013 Linens $47.00 FALSE
2154 36025 R31 06/12/2013 Cash $50.00 FALSE
2155 36077 R31 07/01/2013 Sporting goods $267.85 TRUE
2157 36028 W22 07/18/2013 Cash $50.00 FALSE
2159 36041 K64 09/07/2013 Outdoor furniture $345.00 TRUE
2160 36032 W43 08/21/2013 Cash $45.00 FALSE
2163 36055 R86 05/29/2013 Cash $35.00 FALSE
2167 36037 W22 11/27/2013 Portable heaters $489.00 TRUE
2168 36033 Y68 06/02/2013 Sporting goods $167.00 FALSE
2170 36074 R31 03/10/2013 Office equipment $366.50 TRUE
2171 36056 W43 05/03/2013 Cash $50.00 FALSE
2172 36033 Y68 09/24/2013 Cash $35.00 FALSE
2175 36041 R15 12/12/2013 Cash $125.00 FALSE
2177 36019 W43 09/07/2013 Cutlery $67.00 FALSE
2179 36016 K64 04/11/2013 Small appliances $236.50 TRUE
2180 36037 K64 12/03/2013 Cash $50.00 FALSE
2181 36055 N33 09/07/2013 Linens $68.00 FALSE
2182 36012 N57 11/12/2013 Microwave oven $75.00 FALSE
2184 36020 Y68 08/28/2013 Computer equipment $497.00 TRUE
2185 36074 K82 06/11/2013 Cash $100.00 FALSE
2187 36070 W43 04/19/2013 Kitchen tools $40.00 FALSE
2188 36073 R31 10/30/2013 Painting supplies $135.40 FALSE
2190 36074 N57 10/14/2013 Dinnerware $127.00 FALSE
2191 36077 W43 07/01/2013 Cookware $85.75 FALSE
2192 36073 W22 11/02/2013 Welding tools $468.00 FALSE
2193 36042 N33 12/01/2013 Cash $100.00 FALSE
2195 36064 K64 10/15/2013 Sporting goods $246.00 FALSE
2196 36051 N33 06/04/2013 Bookshelves $168.90 TRUE
2197 36033 Y68 12/05/2013 Bicycles $225.00 FALSE
2200 36032 K82 12/04/2013 Books on tape $50.00 FALSE
2202 36051 W22 12/20/2013 Power tools $517.00 TRUE
2205 36056 N33 09/07/2013 Office equipment $347.00 TRUE
2210 36060 Y68 09/01/2013 Computer equipment $388.00 FALSE
2212 36077 R86 12/20/2013 Computer equipment $350.00 TRUE
2213 36055 W43 12/13/2013 Small appliances $276.00 FALSE
2215 36070 N33 11/12/2013 Bicycles $178.00 FALSE

Sheet2

Sheet3

Access1/Case3/Recycle.accdb

ID Agency Last Name First Name Phone Fax Number Mobile Phone Notes

Access1/Case3/Recycle.bmp

Access1/Case3/RRGroup.accdb

DonorID Title FirstName LastName Phone
36025 Mrs. Mary Durnen 785-598-0569
36028 Mr. Michael Carlucci 316-283-6334
36032 Mrs. Barbara Schmidt 785-827-9713
36033 Mr. Brian Park 620-663-1418
36037 Ms. Sherill Kussow 785-823-2284
36041 Mrs. Celia Brubaker 620-669-3970
36042 Mrs. Helen Taft 785-238-9451
36049 Mrs. Katharine Gardiner 785-826-2135
36051 Mr. Leland Jaeger 785-309-1655
36055 Ms. Tina Sun 785-827-2688
36056 Mr. Robert Parkinson 785-263-5896
36058 Mrs. Rebecca Lawry 785-825-5583
36060 Mrs. Dianne Corrigan 785-826-0063
36062 Mr. Wesley Tarkenton 316-282-2226
36064 Ms. Erika Lange 785-263-1054
36065 Mrs. Gayle Berkelee 785-309-3896
36070 Mrs. Ashley Willis 785-827-1862
36073 Mr. Gerald Persinger 620-241-2526
36074 Mrs. Maria Gonzalez 785-238-0337
36077 Mrs. Meredith Dellkamp 785-820-1521

Access1/Case4/Bookings.txt

503 209 3488 6/12/2013 0:00:00 6/19/2013 0:00:00 12 $2000.00
504 203 3529 3/11/2013 0:00:00 3/25/2013 0:00:00 6 $1500.00
507 225 3002 5/12/2013 0:00:00 5/19/2013 0:00:00 8 $1000.00
510 220 3107 5/1/2013 0:00:00 5/15/2013 0:00:00 6 $1000.00
511 201 3142 8/20/2013 0:00:00 8/27/2013 0:00:00 7 $700.00
512 211 3222 4/4/2013 0:00:00 4/11/2013 0:00:00 8 $1600.00
513 216 3007 7/20/2013 0:00:00 7/27/2013 0:00:00 20 $3800.00
515 202 3050 9/8/2013 0:00:00 9/22/2013 0:00:00 7 $1200.00
516 224 3179 4/21/2013 0:00:00 5/5/2013 0:00:00 10 $2500.00
520 215 3002 8/10/2013 0:00:00 8/17/2013 0:00:00 6 $800.00
521 206 3395 6/3/2013 0:00:00 6/10/2013 0:00:00 6 $750.00
522 230 3190 6/22/2013 0:00:00 7/6/2013 0:00:00 15 $3000.00
525 212 3010 7/11/2013 0:00:00 7/18/2013 0:00:00 16 $5000.00
530 229 3204 8/5/2013 0:00:00 8/12/2013 0:00:00 14 $2400.00
531 205 3515 11/16/2013 0:00:00 11/23/2013 0:00:00 11 $2700.00
535 221 3003 9/10/2013 0:00:00 9/17/2013 0:00:00 6 $800.00
536 222 3675 2/20/2013 0:00:00 2/27/2013 0:00:00 8 $2500.00
537 210 3611 8/4/2013 0:00:00 8/11/2013 0:00:00 10 $2000.00
540 211 3222 4/10/2014 0:00:00 4/17/2014 0:00:00 8 $1600.00
541 228 3628 5/20/2013 0:00:00 5/27/2013 0:00:00 6 $900.00
545 203 3529 3/15/2014 0:00:00 3/29/2014 0:00:00 5 $1500.00
548 212 3395 10/2/2013 0:00:00 10/16/2013 0:00:00 5 $700.00
550 229 3670 11/5/2013 0:00:00 11/12/2013 0:00:00 8 $1300.00

Access1/Case4/Overseas.accdb

PropertyID PropertyName PropertyType Location Country NightlyRate Bedrooms Sleeps Description VIP Program
3002 Chateau St. Antoine Castle Loire Valley France ¤ 1,000.00 5 9 17th century; classic architecture; extensive gardens false
3003 Manoir Rouy Manor Burgundy France ¤ 800.00 3 6 Rural location; breathtaking views; close to vineyards true
3007 Kilglen Castle Castle Inverness Scotland ¤ 3,800.00 10 20 Traditional sporting pursuits; hunting; golf; historic tours false
3010 Alberford Castle Castle Devon England ¤ 5,000.00 8 16 1100-acre sporting estate; hunting; fishing; historic tours false
3050 Riyad Primiere Villa Marrakesh Morocco ¤ 1,600.00 4 8 Central location; courtyard; pool; art museums false
3107 Villa Leopoldo Villa Tuscany Italy ¤ 1,300.00 4 8 Close to beach and designer boutiques; biking; boating false
3142 Clough Estate Manor Cork Ireland ¤ 700.00 4 7 Early 17th century; extensive gardens; lake views; fishing true
3179 Chateau Sur Mer Castle Cannes France ¤ 2,500.00 5 10 Views over the bay; private beach; heated pool; secure false
3190 Glenlow Castle Castle Dundee Scotland ¤ 3,000.00 9 18 16th century refurbished castle; golf; fishing; horseback riding true
3204 Hartfield Country Manor Manor Surrey England ¤ 2,400.00 7 14 Late Tudor 14-acre estate; cultural and historic tours; floral art false
3222 Casa Rosa Canina Villa Lake Como Italy ¤ 1,700.00 6 12 English style architecture and gardens; panoramic lake views true
3395 Villa San Vincenzo Villa Umbria Italy ¤ 750.00 3 6 Hillside location; breathtaking views; pool; olive groves false
3423 Castle Ballydare Castle Kerry Ireland ¤ 5,000.00 9 25 Mountain views; golf; fishing; hunting; horseback riding false
3488 Chateau du Boisvert Castle Provence France ¤ 2,000.00 11 18 17th century chateau; formal gardens; pool; chapel false
3515 Riyad Etoile Villa Marrakesh Morocco ¤ 3,000.00 8 16 Multiple courtyards and terraces; pool; cultural tours true
3529 La Amaranta Villa Valencia Spain ¤ 1,700.00 6 8 Ocean views; close to beach; pool; art and music festivals false
3611 Lumley Manor Manor Kent England ¤ 2,000.00 6 11 Renaissance style with Benedictine origins; naturalist tours false
3628 Kenyan Seaside Retreat Villa Mombasa Kenya ¤ 900.00 3 7 Spectacular sea views; pool; diving; snorkeling; sailing false
3670 Bellevue Villa Villa St. Tropez France ¤ 1,300.00 4 8 Close to beach; heated pool; tennis courts; gardens true
3675 Casa de Las Palmas Villa Mallorca Spain ¤ 2,500.00 4 8 Private estate; multiple terraces; beautiful sea views; pool false

Access1/Case4/Travel.accdb

GuestID GuestFirst GuestLast Address City State/Prov PostalCode Country Phone
209 Alex Neeley 308 Lakeside Dr Chicago IL 60601 USA 312-303-1290
210 Luiz Neto 8552 Main St Chicago IL 60602 USA 312-481-7053
211 Sarah Vanesse 35 Park Rd Crown Point IN 46307 USA 219-377-1882
212 Janet Froberg 433 Monroe St Aurora IL 60504 USA 630-788-3055
215 Brian Campbell 14 Spencer Blvd Gary IN 46402 USA 219-475-3044
216 Linda Gupta 130 Elm St Evanston IL 60202 USA 847-489-3339
217 Maddie Roux 443 Front Rd LaSalle ON N9J 2N7 Canada 519-734-0065
220 Alberto Azevedo 991 Crestview Dr Chicago IL 60601 USA 312-842-1183
221 Amy Shevlin 118 Forest Rd Hammond IN 46320 USA 219-334-1275
222 Lucas Kalnajs 3 March Rde Crown Point IN 46307 USA 219-377-0312
224 Robert Crawford 602 Pine Ridge Rd Tinley Park IL 60477 USA 708-292-0661
225 Kelly Skolnik 15 Tobin Dr Wilmington IL 60481 USA 815-339-1597
228 Chris Locke 4478 Howard Ave Windsor ON N8X 3Y8 Canada 519-966-9094
229 Paul Marchant 7533 Macleod Dr Chicago IL 60603 USA 312-783-2209
230 Susan Goetz 29 Evergreen Rd Aurora IL 60507 USA 630-442-4831

Access1/Case4/Villa.bmp

Access1/Review/Goods.xlsx

Goods

ProductID CompanyID ProductType Price Unit Color Material Size Weight Discount
5001 BAC200 Seesaw 1,394.00 Each Yellow Powder-coated steel 1.5 x 9 feet 112 No
5003 AND225 Small picnic table 830 Each Green Powder-coated steel 7 x 6 feet 299 No
5004 AND225 Large picnic table 990 Each Blue Powder-coated steel 9 x 6 feet 357 No
5006 BAC200 Spiderweb climber 1,722.00 Each Green Powder-coated steel 84 x 84 inches 146 No
5008 AND225 Small round table 575 Each Red Powder-coated steel 5 feet diameter 213 No
5009 AND225 Large round table 760 Each Black Powder-coated steel 6 feet diameter 257 No
5010 BAC200 Small play structure 4,960.00 Each Beige-blue Powder-coated steel 26 x 25 feet 790 No
5011 BAC200 Large play structure 12,750.00 Each Beige-green Powder-coated steel 33 x 34 feet 1890 No
5012 HOL207 Trash receptacle 672 Each Black Powder-coated steel 32 gallon 175 No
5014 BAC200 Double bay swing 3,740.00 Each Purple Powder-coated steel 23 x 6 feet 364 No
5015 AND225 Large bench 825 Each Green Powder-coated steel 15 x 2 feet 273 No
5018 AND225 Square tree grate 390 Each Black Powder-coated steel 4 feet square 114 No
5020 HOL207 Small bench with back 688 Each Redwood Redwood and iron 6 x 2 feet 197 No
5021 HOL207 Large bench with back 763 Each Redwood Redwood and iron 8 x 2 feet 275 No
5030 GRA231 Basketball backstop 1,245.00 Each White Aluminum 3 x 4 feet 458 No
5031 GRA231 Tennis posts 306 Pair Green Powder-coated steel 3 feet 69 No
5034 GRA231 Bicycle rack 486 Each Blue Powder-coated steel 5 feet 80 No
5100 PIN252 Small round table 551 Each Wood Teak 5 feet diameter 54 No
5101 PIN252 Large round table 980 Each Wood Teak 6 feet diameter 72 No
5105 PIN252 Side chair 250 Each Wood Teak 1.5 x 2 feet 17 No
5106 PIN252 Side chair with arms 425 Each Wood Teak 2 x 2 feet 24 No
5202 MIC268 Safety surface 9.6 Square foot Black Recycled rubber 22 gallon 58 No
5205 BES327 Matte paver 13 Each Ginger Precast concrete 1 square foot 21 No
5206 BES327 Granite paver 16.7 Each Granite Precast concrete 1 square foot 21 No
5207 BES327 Slate paver 19.9 Each Charcoal Precast concrete 1 square foot 21 No
5211 QUA331 Matte paver 9.65 Square foot Blue-grey Natural stone No
5212 QUA331 Limestone paver 9.33 Square foot Buff Natural stone No
5222 LAN348 Square paver 2.45 Square foot Light brown Precast concrete No
5223 LAN348 Rectangular paver 4.05 Square foot Light brown Precast concrete No
5227 LAN348 Retaining wall 10.35 Square foot Grey Precast concrete 1 x 1 foot No
5228 QUA331 Wall stone 7.63 Square foot Brown-grey Natural stone No
5230 BES327 Wall cap 8.5 Linear foot White Precast concrete 1 x 2 feet 40 No
5232 LAN348 Paver edging 1.95 Linear foot Black PVC 1 x 7 feet No
5301 BEL273 Mulch 24.4 Cubic yard Wood Flat wood chips Yes
5304 BEL273 Cypress mulch 20.45 Cubic yard Shredded cypress Yes
5305 GEN359 Cedar mulch 29 Cubic yard Reddish Cedar-pine blend Yes
5311 GEN359 Top soil 13.5 Cubic yard Screened top soil Yes
5313 GEN359 Potting soil 16 Cubic yard Sifted soil and compost Yes
5314 BEL273 Potting soil 16.5 Cubic yard Sifted soil and compost Yes
5315 NAT304 Chain link fencing 10.6 Linear foot Black Vinyl-coated chain link 3.5 feet high Yes
5317 BEL273 Top soil 13.5 Cubic yard Screen top soil Yes
5318 BEL273 Organic compost 14.45 Cubic yard Organic compost Yes
5322 NAT304 Short ornamental fence 48 Linear foot Black Powder-coated steel 2 feet high Yes
5323 NAT304 Tall ornamental fence 72 Linear foot Black Powder-coated steel 4 feet high Yes
5400 DUN284 Large pergola-round 17,830.00 Each White Vinyl 18 x 16 feet 2100 No
5401 DUN284 Large pergola-square 13,460.00 Each White Vinyl 18 x 16 feet 2100 No
5402 DUN284 Small pergola-round 9,455.00 Each White Vinyl 4 x 16 feet 700 No
5403 DUN284 Small pergola-square 7,526.00 Each White Vinyl 4 x 16 feet 700 No
5411 NAT304 Tennis court fencing 29.6 Linear foot Black Vinyl-coated chain link 10 feet high Yes
5502 MID312 Halide lamp 312 Each Bronze Bronze 8.5 x 15 feet No
5503 MID312 Lamp and post 1,007.00 Each Black Powder-coated aluminum 6 x .5 feet No
5504 MID312 Lighting system 1,272.00 Each Silver-grey Powder-coated aluminum 12 feet high No
5601 GEN359 Shade tree 250 Each 6-8 feet high Yes
5602 HOL292 Shade tree 245 Each 7-9 feet high Yes
5603 GEN359 Ornamental tree 135 Each 4-6 feet high Yes
5604 HOL292 Ornamental tree 130 Each 6-7 feet high Yes
5610 HOL292 Shrub 23.5 Each 3 gallon Yes
5612 GEN359 Shrub 24 Each 3 gallon Yes
5620 HOL292 Perennial 6.3 Each 1 gallon Yes
5622 GEN359 Perennial 6.4 Each 1 gallon Yes
5625 HOL292 Groundcover 3.25 Each 4 quart Yes
5628 GEN359 Groundcover 3.25 Each 4 quart Yes

Access1/Review/Provider.accdb

CompanyID Company Product Address City State Zip Phone ContactFirst ContactLast InitialContact
BEL273 Belmont Mulch Organic and recycled mulch 3044 Edgewater Dr Kalamazoo MI 49007 269-343-6618 Natalie Belmont 2012-06-17
DUN284 Dunn Rite Fence Fencing 502 Market Ave Grand Rapids MI 49503 616-456-0943 Mike Dunn 2012-02-25
GEN359 Genesis Garden Center Mulch and soil 901 Market Ave Grand Rapids MI 49503 616-456-2273 Dennis Jung 2012-05-07
GRA231 Grand Rapids Sports Sports equipment 8022 Adams St Grand Rapids MI 49503 616-392-1403 Larry Rudolph 2013-05-01
HOL207 Holland Yard and Patio Site furnishings 85 College Ave Holland MI 49424 616-355-4604 Pam Garvey 2012-03-28
LAN348 Lansing Building Supply Pavers and walls 624 Washington Ave Lansing MI 48901 517-482-4562 Ken Gratz 2012-10-01
MIC268 Michigan Surfaces Recreational surfacing 265 W 12th St Holland MI 49424 616-392-1317 Ted Silvers 2012-03-01
NAT304 National Fence Company Ornamental fencing 3502 State St Lansing MI 48917 517-487-1114 Bruce Dunleavy 2013-04-01
PIN252 Pinnacle Wood Furnishings Benches and tables 43 Linden Dr Lansing MI 48933 517-483-7786 Phyllis Walstead 2012-09-20
QUA331 Quarry Rock and Stone Stone materials 105 Colgate Hill Rd Holland MI 49423 616-396-6787 Craig Jensen 2013-10-11

Access1/Review/Tools.bmp

Access1/Tutorial/Customer.txt

11005 Owen Hawes 616-392-0622 102 Pineview Rd Holland MI 49423 [email protected]
11008 Melissa Caputo 269-985-1122 302 Main St Saint Joseph MI 49085 [email protected]
11014 Amol Mehta 616-396-1972 54 Lakeshore Ave Holland MI 49424 [email protected]
11015 John Weiss 616-637-7783 456 Winchester St South Haven MI 49090 [email protected]
11020 Battle Creek Dental Partners Harry Billings 269-963-0808 587 Longmeadow Rd Battle Creek MI 49014 [email protected]
11027 Karen O'Brien 517-483-9244 38 Langley Rd Lansing MI 48933 [email protected]
11030 Finn's on the Waterfront Devin Finnerty 616-393-1228 78 East 8th St Holland MI 49423 [email protected]
11031 Happy Haven Day Care Kathy Rowe 616-842-4603 29 Graham's Ln Grand Haven MI 49417 [email protected]
11032 Pam Wallner 269-857-1276 80 Cedar St Saugatuck MI 49453 [email protected]
11038 M. Grant Investment Company Alex Engber 517-482-1400 505 Washington Ave Lansing MI 48901 [email protected]
11040 RiverView Development Company Charles Nowak 616-988-0777 144 E Tower Ave Grand Rapids MI 49503 [email protected]
11042 Michael Ingram 269-337-9208 10 Lincoln Dr Kalamazoo MI 49007 [email protected]
11043 Monroe State College Rachel Kirk 616-988-1320 40 Monroe St Grand Rapids MI 49503 [email protected]
11045 Kalamazoo Neighborhood Development James Blackhawk 269-343-7509 3047 Millbrook Ave Kalamazoo MI 49007 [email protected]
11048 Olivia Pappas 616-637-6591 4 N Orchard St South Haven MI 49090 [email protected]
11049 Claire Boucher 269-983-2255 828 Turner St Saint Joseph MI 49085 [email protected]
11053 Hwan Tang 616-396-8401 283 Cottrell St Holland MI 49423 [email protected]
11054 Gilded Goose Gift Shop Taylor Wilson 616-355-3989 258 Briar Ln Holland MI 49424 [email protected]
11055 Fox and Hound Grille Steve Gorski 269-979-2004 1440 Beadle Lake Rd Battle Creek MI 49014 [email protected]
11058 Cherrywood Senior Center Lisa Hall 269-857-1771 77 Forest Hill Rd Saugatuck MI 49453 [email protected]
11059 G.R. Neighborhood Development Corp. Matthew Fraser 616-392-0015 8045 Jefferson Ave Grand Rapids MI 49503 [email protected]
11060 Jerome Smith 616-949-3862 75 Hillcrest St East Grand Rapids MI 49506 [email protected]
11064 Northwest Transit Station Henry Goldberg 517-487-4700 3572 Clinton Ave Lansing MI 48917 [email protected]
11065 Town of Holland Amber Ward 616-393-0403 24 Prospect St Holland MI 49423 [email protected]
11067 Blossom Day Care Center Christina Garrett 269-985-1992 333 Empire Ave Saint Joseph MI 49085 [email protected]
11068 Grand Rapids Housing Authority Jessica Ropiak 616-454-4002 5230 Fulton St Grand Rapids MI 49504 [email protected]
11070 Legacy Companies, LTD. Michael Faraci 616-456-7093 250 Market Ave Grand Rapids MI 49503 [email protected]
11071 Blue Star Mini Golf Vanetta Walker 269-857-4424 82 Mason St Saugatuck MI 49453 [email protected]
11072 Sierra Investment Company Rodrigo Valencia 269-337-8200 5049 Red Arrow Hwy Kalamazoo MI 49007 [email protected]
11073 Connor Riley 269-983-1116 11 Pleasant St Saint Joseph MI 49085 [email protected]
11075 Kim Architects, Inc. An Kim 517-482-9932 1015 Williamston Rd Lansing MI 48933 [email protected]
11079 Dept. of Neighborhood Development Sarah Russell 616-940-3380 722 Beechwood Dr East Grand Rapids MI 49506 [email protected]
11080 Three Tulips Café Jan Van Dousen 616-392-4629 249 W 11th St Holland MI 49424 [email protected]
11083 Hopedale State College John Williams 517-337-0990 1003 Albert Ave East Lansing MI 48823 [email protected]
11084 Cathy DeSantis 616-866-4882 78 Spring St Rockford MI 49341 [email protected]
11085 Edward Phillips 616-637-5408 39 Water St South Haven MI 49090 [email protected]
11087 Walker Investment Company Nancy Belanger 616-456-2710 4031 Barclay St Grand Rapids MI 49503 [email protected]
11088 Weston Community Parks Foundation Sam Kervin 616-454-3327 333 Pearl St Grand Rapids MI 49503 [email protected]

Access1/Tutorial/Invoices.xlsx

Invoices

InvoiceNum ContractNum InvoiceDate InvoiceItem InvoiceAmt InvoicePaid
2012 3011 05/10/2013 Planting Plan $2,500.00 Yes
2021 3012 02/25/2013 Consultation $300.00 Yes
2032 3020 08/19/2013 Landscape Planting $2,000.00 Yes
2033 3020 09/20/2013 Lighting Plan $2,000.00 Yes
2034 3020 10/20/2013 Permitting $1,000.00 Yes
2041 3015 04/01/2013 Schematic Plan $1,500.00 Yes
2051 3017 04/01/2013 Peer Plan Review $2,250.00 Yes
2061 3026 03/11/2014 Schematic Open Space Plan $35,000.00 Yes
2063 3026 07/11/2015 Construction Documents $70,000.00 No
2064 3026 04/04/2017 Construction Admin. & Observation $50,000.00 No
2071 3023 11/22/2013 Schematic Open Space Plan $9,000.00 Yes
2072 3023 07/22/2014 Planting Plan $20,000.00 Yes
2081 3025 07/23/2013 Schematic Plan $4,000.00 Yes
2082 3025 12/20/2013 Construction Documents $8,000.00 Yes
2083 3025 06/24/2014 Construction Observation $3,500.00 Yes
2091 3027 06/07/2013 Schematic Plan $1,250.00 Yes
2101 3022 07/14/2013 Schematic Plan $4,500.00 Yes
2102 3022 11/15/2013 Construction Documents $12,000.00 Yes
2103 3022 07/14/2014 Construction Observation $5,500.00 Yes
2111 3021 10/12/2013 Schematic Landscape Plan $4,500.00 Yes
2112 3021 11/12/2013 Permitting $3,000.00 Yes
2113 3021 09/02/2014 Construction Documents $12,000.00 No
2114 3021 09/05/2015 Construction Observation $8,500.00 No
2121 3034 09/28/2013 Community Meetings $3,500.00 Yes
2122 3034 12/28/2013 Schematic Design $5,500.00 Yes
2131 3035 10/18/2013 Community Meetings $4,500.00 Yes
2132 3035 03/28/2014 Schematic Design $6,000.00 Yes
2141 3031 02/03/2014 Schematic Open Space Plan $7,500.00 Yes
2142 3031 06/03/2014 Planting Plans $16,000.00 Yes
2143 3031 10/03/2014 Layout Plans $16,000.00 No
2144 3031 08/03/2015 Construction Observation $9,000.00 No
2151 3030 08/11/2013 Schematic Plan $1,500.00 Yes
2152 3030 10/15/2013 Construction Documents $2,250.00 Yes
2153 3030 03/30/2014 Construction Observation $1,500.00 Yes
2161 3032 09/10/2013 Schematic Plan $2,500.00 Yes
2162 3032 10/12/2013 Planting Plan $2,500.00 Yes
2163 3032 11/12/2013 Construction Details $1,500.00 Yes
2171 3037 02/22/2014 Community Meetings & Coordination $8,000.00 Yes
2172 3037 06/22/2014 Schematic Plan $15,000.00 Yes
2173 3037 02/24/2015 Construction Documents $30,000.00 No
2174 3037 03/20/2016 Construction Admin. & Observation $15,000.00 No
2181 3038 10/22/2013 Community Meetings $3,000.00 Yes
2182 3038 12/22/2013 Schematic Plan $8,000.00 Yes
2183 3038 06/23/2014 Construction Documents $15,000.00 Yes
2184 3038 04/27/2015 Construction Admin. & Observation $8,000.00 No
2191 3033 09/29/2013 Schematic Plan $2,250.00 Yes
2201 3040 01/12/2014 Schematic Landscape Plan $8,500.00 Yes
2202 3040 08/26/2014 Construction Documents $18,000.00 No
2203 3040 09/17/2015 Construction Admin. & Observation $12,000.00 No
2211 3043 01/11/2014 Schematic Landscape Plan $5,500.00 Yes
2212 3043 06/20/2014 Construction Documents $10,500.00 Yes
2213 3043 03/30/2015 Construction Observation $3,000.00 No
2221 3044 06/17/2014 Construction Documents $15,500.00 Yes
2222 3044 05/01/2015 Construction Admin. & Observation $10,000.00 No
2231 3045 12/22/2014 Schematic Plans $18,000.00 No
2232 3045 08/15/2015 Community Meetings $7,000.00 No
2241 3050 10/18/2013 Schematic Plan $1,000.00 Yes
2251 3046 09/09/2013 Consultation $300.00 Yes
2261 3053 09/22/2013 Consultation $375.00 Yes
2271 3048 12/28/2013 Schematic Design $1,500.00 Yes
2272 3048 02/28/2014 Permitting $1,000.00 Yes
2273 3048 06/30/2014 Landscape Planting & Lighting Plan $3,500.00 Yes
2274 3048 09/26/2014 Construction Observation $1,500.00 No
2281 3056 09/30/2014 Construction Documents $20,000.00 No
2282 3056 08/14/2015 Construction Admin. & Observation $12,500.00 No
2291 3057 01/31/2014 Schematic Design $4,000.00 Yes
2292 3057 06/30/2014 Construction Documents $8,000.00 Yes
2293 3057 03/30/2015 Construction Observation $3,500.00 No
2301 3051 03/07/2014 Schematic Landscape Plan $5,500.00 Yes
2302 3051 07/07/2014 Construction Documents $9,000.00 Yes
2303 3051 05/03/2015 Construction Observation $3,500.00 No
2311 3060 12/21/2013 Schematic Plan $1,500.00 Yes
2312 3060 05/27/2014 Planting & Materials Plan $2,500.00 Yes
2321 3061 06/28/2014 Schematic Open Space Plan $6,000.00 Yes
2322 3061 10/26/2014 Permitting $3,000.00 No
2323 3061 04/25/2015 Construction Documents $15,000.00 No
2324 3061 06/27/2016 Construction Observation $6,800.00 No
2331 3062 06/10/2014 Schematic Landscape Plan $6,000.00 Yes
2332 3062 11/14/2014 Construction Documents $10,000.00 No
2333 3062 05/11/2015 Construction Observation $4,000.00 No
2341 3063 03/21/2014 Schematic Plan $1,750.00 Yes
2351 3065 06/03/2014 Community Meetings $4,000.00 Yes
2352 3065 12/05/2014 Schematic Plan $9,500.00 No
2353 3065 08/03/2015 Construction Documents $15,000.00 No
2354 3065 08/01/2016 Construction Admin. & Observation $9,500.00 No
2361 3068 04/21/2014 Schematic Plan $1,500.00 Yes
2362 3068 07/07/2014 Planting & Materials Plan $3,000.00 Yes
2371 3069 06/09/2014 Schematic Plan $3,750.00 Yes
2372 3069 07/29/2014 Permitting $2,500.00 Yes
2373 3069 09/23/2014 Planting Plan $7,000.00 No
2374 3069 10/24/2014 Lighting Plans $2,500.00 No
2381 3070 09/06/2014 Community Meetings $3,500.00 No
2382 3070 01/03/2014 Schematic Plan $8,500.00 No
2383 3070 11/05/2015 Construction Documents $14,000.00 No
2384 3070 07/08/2016 Construction Observation $9,000.00 No
2391 3071 12/09/2014 Schematic Plan $8,500.00 No
2392 3071 03/12/2015 Community Meetings & Permitting $4,500.00 No
2393 3071 03/11/2015 Construction Documents $14,000.00 No
2394 3071 03/27/2017 Construction Observation $10,000.00 No
2401 3072 11/10/2014 Schematic Plan $12,000.00 No
2402 3072 09/13/2015 Construction Documents $30,000.00 No
2403 3072 09/26/2016 Construction Admin. & Observation $15,000.00 No
2411 3075 07/08/2014 Schematic Plan $5,000.00 Yes
2412 3075 04/09/2015 Construction Documents $8,000.00 No
2413 3075 09/27/2015 Construction Observation $3,500.00 No
2421 3076 06/08/2014 Peer Plan Review $5,000.00 Yes
2431 3080 08/03/2014 Schematic Design $6,000.00 Yes
2432 3080 09/14/2014 Permitting $1,500.00 No
2433 3080 02/15/2015 Planting Plan $13,000.00 No
2434 3080 08/15/2015 Lighting Plans $2,300.00 No
2441 3078 06/24/2014 Schematic Landscape Plan $3,750.00 Yes
2442 3078 10/24/2014 Construction Documents $7,500.00 No
2443 3078 06/25/2015 Construction Observation $2,500.00 No
2451 3073 09/05/2015 Schematic Open Space & Landscape Plan $45,000.00 No
2452 3073 05/06/2016 Community Meetings & Permitting $25,000.00 No
2453 3073 05/05/2017 Construction Documents $85,000.00 No
2454 3073 08/18/2018 Construction Admin. & Observation $50,000.00 No
2461 3081 10/11/2014 Schematic Landscape Plan $4,500.00 No
2462 3081 05/10/2015 Construction Documents $12,000.00 No
2463 3081 10/18/2015 Construction Observation $4,500.00 No
2471 3077 08/23/2014 Schematic Landscape Plan $6,500.00 Yes
2481 3082 08/01/2014 Schematic Plan $2,500.00 Yes
2482 3082 10/21/2014 Planting Plan $2,500.00 No
2491 3090 10/14/2014 Community Meetings $2,000.00 No
2492 3090 02/16/2015 Schematic Plan $5,500.00 No
2493 3090 11/16/2015 Construction Documents $12,000.00 No
2494 3090 09/09/2016 Construction Observation $6,000.00 No
2501 3085 02/23/2015 Schematic Landscape Plan $10,500.00 No
2502 3085 10/23/2015 Construction Documents $26,000.00 No
2503 3085 08/26/2016 Construction Observation $16,000.00 No
2511 3095 08/25/2014 Schematic Design $3,000.00 Yes
2512 3095 03/29/2015 Construction Documents $7,000.00 No
2513 3095 04/30/2016 Construction Observation $4,500.00 No
2521 3086 10/11/2014 Schematic Landscape Plan $4,750.00 No
2522 3086 03/12/2015 Construction Documents $8,500.00 No
2523 3086 10/04/2015 Construction Observation $4,000.00 No
2531 3098 12/15/2014 Schematic Landscape Plan $8,000.00 No
2532 3098 03/15/2015 Community Meetings $2,000.00 No
2533 3098 01/15/2016 Construction Documents $17,000.00 No
2534 3098 07/15/2016 Construction Observation $8,000.00 No
2541 3093 08/25/2014 Schematic Plan $2,000.00 Yes
2542 3093 02/27/2015 Planting Plan $3,000.00 No
2551 3099 12/23/2014 Schematic Landscape Design $6,500.00 No
2561 3094 08/25/2014 Schematic Plan $2,000.00 Yes
2562 3094 03/23/2015 Planting Plan $3,000.00 No
2571 3104 09/28/2014 Schematic Plan $2,000.00 No
2572 3104 01/27/2015 Planting & Materials Plan $3,500.00 No
2581 3097 10/03/2014 Schematic Plan $2,000.00 No
2582 3097 12/02/2014 Landscape Layout & Planting Plan $4,000.00 No
2583 3097 04/20/2015 Construction Observation $2,500.00 No
2591 3108 01/06/2015 Schematic Landscape Plan $12,000.00 No
2592 3108 04/13/2015 Community Meetings $3,000.00 No
2593 3108 02/15/2016 Construction Documents $25,000.00 No
2594 3108 03/31/2017 Construction Observation $10,000.00 No
2601 3100 03/08/2015 Schematic Landscape Design $10,500.00 No
2611 3103 08/17/2015 Schematic Open Space & Landscape Plan $45,000.00 No
2612 3103 08/16/2016 Community Meetings & Permitting $25,000.00 No
2613 3103 12/17/2017 Construction Documents $105,000.00 No
2614 3103 09/30/2019 Construction Admin. & Observation $77,000.00 No
2621 3109 04/18/2015 Schematic Plan $8,000.00 No
2622 3109 10/18/2015 Construction Documents $18,000.00 No
2623 3109 09/23/2016 Construction Admin. & Observation $15,000.00 No
2631 3101 11/28/2014 Schematic Plan $2,500.00 No
2632 3101 12/28/2014 Permitting $1,500.00 No
2633 3101 03/14/2015 Planting Plan $4,000.00 No
2634 3101 05/15/2015 Lighting Plans $1,500.00 No
2641 3105 10/24/2014 Schematic Plan $2,000.00 No
2642 3105 05/25/2015 Planting Plan $3,000.00 No
2651 3110 12/23/2014 Community Meetings $4,000.00 No
2652 3110 02/24/2015 Schematic Plan $9,500.00 No
2653 3110 12/21/2015 Construction Documents $15,000.00 No
2654 3110 05/01/2017 Construction Admin. & Observation $9,500.00 No

Access1/Tutorial/Landscape.bmp

Access1/Tutorial/Oren.accdb

ContractNum CustomerID ContractAmt SigningDate ContractType
3027 11008 ¤ 1,250.00 2013-04-07 Schematic plan for back yard, residential
3030 11042 ¤ 5,250.00 2013-06-11 Landscape plan for residential site
3031 11070 ¤ 48,500.00 2013-06-03 Landscape design for multi-family housing
3032 11014 ¤ 6,500.00 2013-06-22 Residential landscape plan
3033 11005 ¤ 2,250.00 2013-07-08 Residential landscape plan for front yard
3034 11088 ¤ 8,500.00 2013-05-28 Neighborhood park, nonprofit developer
3035 11088 ¤ 10,500.00 2013-05-28 Neighborhood park, nonprofit developer
3037 11045 ¤ 68,000.00 2013-06-22 Renovation of an existing city park
3038 11045 ¤ 34,000.00 2013-06-22 Renovation of an existing playground at a city park
3040 11068 ¤ 38,500.00 2013-07-27 Renovation of open space around public housing site
3043 11083 ¤ 19,000.00 2013-08-11 Landscape design of open space around new campus building
3044 11075 ¤ 25,500.00 2013-08-19 Handicap accessibility upgrades to public housing site
3045 11064 ¤ 25,000.00 2013-08-20 Open space corridor planning at new transit station
3046 11048 ¤ 300.00 2013-09-02 Consultation for back yard, residential
3048 11030 ¤ 7,500.00 2013-09-23 Landscape design for restaurant site
3050 11015 ¤ 1,000.00 2013-08-27 Schematic plan for back yard, residential
3051 11032 ¤ 18,000.00 2013-10-05 Site layout and landscape design for residential site
3053 11049 ¤ 375.00 2013-09-15 Consultation for front yard, residential
3056 11075 ¤ 32,500.00 2013-09-30 Handicap accessibility upgrades to public housing site
3057 11075 ¤ 15,500.00 2013-09-30 Handicap accessibility upgrades to public housing site
3060 11005 ¤ 4,000.00 2013-11-30 Front walk and drive design, residential
3061 11070 ¤ 30,800.00 2013-12-28 Landscape design for multi-family housing development
3062 11053 ¤ 20,000.00 2014-01-11 Site layout and landscape design for residential site
3063 11015 ¤ 1,750.00 2014-01-20 Landscape plan for front yard, residential
3065 11079 ¤ 38,000.00 2014-02-03 Renovation of playground at elementary school
3068 11049 ¤ 4,500.00 2014-02-07 Front walk and drive design, residential
3069 11030 ¤ 15,750.00 2014-02-24 Landscape design for restaurant site
3070 11079 ¤ 35,000.00 2014-03-03 Renovation of playground at elementary school
3071 11059 ¤ 37,000.00 2014-03-11 Landscape design for affordable housing site
3072 11059 ¤ 46,000.00 2014-03-11 Landscape design for affordable housing site
3073 11072 ¤ 205,000.00 2014-05-05 Landscape plans for large-scale housing development
3075 11067 ¤ 16,500.00 2014-04-08 Design of a playground for a daycare center
3076 11065 ¤ 5,000.00 2014-04-08 Peer plan review for town
3077 11058 ¤ 6,500.00 2014-05-17 Schematic landscape design for senior center
3078 11020 ¤ 13,750.00 2014-04-25 Landscape design for business property
3080 11030 ¤ 22,800.00 2014-04-14 Landscape design and site plan for restaurant site
3081 11071 ¤ 21,000.00 2014-05-10 Landscape design for business property
3082 11060 ¤ 5,000.00 2014-06-01 Residential landscape plan
3085 11068 ¤ 52,500.00 2014-06-23 Open space & playground design for public housing site
3086 11054 ¤ 17,250.00 2014-07-11 Landscape design for commercial property
3090 11079 ¤ 25,500.00 2014-06-14 Renovation of playground at elementary school
3093 11085 ¤ 5,000.00 2014-07-25 Residential landscape plan
3094 11015 ¤ 5,000.00 2014-07-26 Front walk and drive design, residential
3095 11045 ¤ 14,500.00 2014-06-29 Handicap accessibility upgrades to public housing site
3097 11080 ¤ 8,500.00 2014-08-02 Landscape design for renovation of restaurant front entry
3098 11065 ¤ 35,000.00 2014-07-15 Design of a small town park
3099 11067 ¤ 6,500.00 2014-07-25 Schematic landscape design for daycare center
3100 11031 ¤ 10,500.00 2014-08-08 Schematic landscape design for daycare center
3101 11030 ¤ 9,500.00 2014-08-24 Landscape design for renovation of a restaurant site
3103 11087 ¤ 252,000.00 2014-08-17 Landscape plans for large-scale housing development
3104 11073 ¤ 6,500.00 2014-07-28 Front walk and drive design, residential
3105 11084 ¤ 5,000.00 2014-08-24 Residential landscape plan
3108 11045 ¤ 50,000.00 2014-08-02 Design of a small city park
3109 11059 ¤ 41,000.00 2014-08-18 Landscape design for affordable housing site
3110 11079 ¤ 38,000.00 2014-08-25 Renovation of playground at elementary school

Access1/Tutorial/Sarah.accdb

CustomerID Company Last First Phone FaxNumber Email County Web Page Notes