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

 Required Homework Assignments

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Tutorial 1Tutorial 2TutorialTutorialCase Problem 2Case Problem 2 

Access1/Case1/Lessons.xlsx

Sheet1

ContractID
StudentID
TeacherID
StartDate
EndDate
LessonType
LessonLength
LessonCost
RentalCost

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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
ohawes7@milocal123.com

11008

Melissa
Caputo
269-985-1122
302 Main St
Saint Joseph
MI
49085
mcaputo12@milocal123.com

11014

Amol
Mehta
616-396-1972
54 Lakeshore Ave
Holland
MI
49424
amehta3@milocal123.com

11015

John
Weiss
616-637-7783
456 Winchester St
South Haven
MI
49090
jweiss72@milocal123.com

11020
Battle Creek Dental Partners
Harry
Billings
269-963-0808
587 Longmeadow Rd
Battle Creek
MI
49014
hbillings1@bcdp77.com

11027

Karen
O’Brien
517-483-9244
38 Langley Rd
Lansing
MI
48933
kobrien4@milocal123.com

11030
Finn’s on the Waterfront
Devin
Finnerty
616-393-1228
78 East 8th St
Holland
MI
49423
dfinnerty1@finns78.com

11031
Happy Haven Day Care
Kathy
Rowe
616-842-4603
29 Graham’s Ln
Grand Haven
MI
49417
krowe47@hhdc123.com

11032

Pam
Wallner
269-857-1276
80 Cedar St
Saugatuck
MI
49453
pwallner2@milocal123.com

11038
M. Grant Investment Company
Alex
Engber
517-482-1400
505 Washington Ave
Lansing
MI
48901
aengber2@mgrant5.com

11040
RiverView Development Company
Charles
Nowak
616-988-0777
144 E Tower Ave
Grand Rapids
MI
49503
cnowak45@rvdc3.com

11042

Michael
Ingram
269-337-9208
10 Lincoln Dr
Kalamazoo
MI
49007
mingram8@milocal123.com

11043
Monroe State College
Rachel
Kirk
616-988-1320
40 Monroe St
Grand Rapids
MI
49503
rkirk9@msc25.edu

11045
Kalamazoo Neighborhood Development
James
Blackhawk
269-343-7509
3047 Millbrook Ave
Kalamazoo
MI
49007
jblackhawk7@knd89.gov

11048

Olivia
Pappas
616-637-6591
4 N Orchard St
South Haven
MI
49090
opappas2@milocal123.com

11049

Claire
Boucher
269-983-2255
828 Turner St
Saint Joseph
MI
49085
cboucher5@milocal123.com

11053

Hwan
Tang
616-396-8401
283 Cottrell St
Holland
MI
49423
htang3@milocal123.com

11054
Gilded Goose Gift Shop
Taylor
Wilson
616-355-3989
258 Briar Ln
Holland
MI
49424
twilson1@gggs1.com

11055
Fox and Hound Grille
Steve
Gorski
269-979-2004
1440 Beadle Lake Rd
Battle Creek
MI
49014
sgorski3@fhg1.com

11058
Cherrywood Senior Center
Lisa
Hall
269-857-1771
77 Forest Hill Rd
Saugatuck
MI
49453
lhall10@csc77.com

11059
G.R. Neighborhood Development Corp.
Matthew
Fraser
616-392-0015
8045 Jefferson Ave
Grand Rapids
MI
49503
mfraser22@grndc8.org

11060

Jerome
Smith
616-949-3862
75 Hillcrest St
East Grand Rapids
MI
49506
jsmith327@milocal123.com

11064
Northwest Transit Station
Henry
Goldberg
517-487-4700
3572 Clinton Ave
Lansing
MI
48917
hgoldberg23@nwts55.org

11065
Town of Holland
Amber
Ward
616-393-0403
24 Prospect St
Holland
MI
49423
award1@holland33.org

11067
Blossom Day Care Center
Christina
Garrett
269-985-1992
333 Empire Ave
Saint Joseph
MI
49085
cgarrett2@bdcc25.com

11068
Grand Rapids Housing Authority
Jessica
Ropiak
616-454-4002
5230 Fulton St
Grand Rapids
MI
49504
jropiak2@grha34.org

11070
Legacy Companies, LTD.
Michael
Faraci
616-456-7093
250 Market Ave
Grand Rapids
MI
49503
mfaraci8@legacy29.com

11071
Blue Star Mini Golf
Vanetta
Walker
269-857-4424
82 Mason St
Saugatuck
MI
49453
vwalker1@bsmg3.com

11072
Sierra Investment Company
Rodrigo
Valencia
269-337-8200
5049 Red Arrow Hwy
Kalamazoo
MI
49007
rvalencia1@sic99.com

11073

Connor
Riley
269-983-1116
11 Pleasant St
Saint Joseph
MI
49085
criley5@milocal123.com

11075
Kim Architects, Inc.
An
Kim
517-482-9932
1015 Williamston Rd
Lansing
MI
48933
akim3@kai82.com

11079
Dept. of Neighborhood Development
Sarah
Russell
616-940-3380
722 Beechwood Dr
East Grand Rapids
MI
49506
srussell3@dnd57.org

11080
Three Tulips Café
Jan
Van Dousen
616-392-4629
249 W 11th St
Holland
MI
49424
jvdousen2@tulips3.com

11083
Hopedale State College
John
Williams
517-337-0990
1003 Albert Ave
East Lansing
MI
48823
jwilliams94@hsc7.edu

11084

Cathy
DeSantis
616-866-4882
78 Spring St
Rockford
MI
49341
cdesantis9@milocal123.com

11085

Edward
Phillips
616-637-5408
39 Water St
South Haven
MI
49090
ephillips8@milocal123.com

11087
Walker Investment Company
Nancy
Belanger
616-456-2710
4031 Barclay St
Grand Rapids
MI
49503
nbelanger4@wic88.com

11088
Weston Community Parks Foundation
Sam
Kervin
616-454-3327
333 Pearl St
Grand Rapids
MI
49503
skervin3@wcpf47.org

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

Still stressed from student homework?
Get quality assistance from academic writers!

Order your essay today and save 25% with the discount code LAVENDER