2 parts see guideline do access and excel

profilefishman001
finalexam_donorsdata.xlsx
Home>Information Systems homework help>2 parts see guideline do access and excel

people

PersonID LastName FirstName MiddleInitial Street City State Zip HomePhone
1112 Wills Grover C 3244 S. Henderson Indianapolis IN 47405 8123252343
1113 McGee Jim D 323 S. Dobson Indianapolis IN 47854 8123326569
1114 Mullet Graver J 4489 Crescent Ct. Indianapolis IN 47401 8123574564
1115 du Plessis Adriaan W 1 Iota Ln. Indianapolis IN 47405 8123350489
1116 Strauss Levi P 1209 Borrodale Rd. Indianapolis IN 47405 8123432342
1117 Botha Piet W 33 Kyle Drive Indianapolis IN 47401 8123321357
1118 Smit John A 1967 Judge St. Indianapolis IN 47402 8123376574
1119 Smith John Q 487 W. Broadway Indianapolis IN 47402 8123377788
1120 Hidey Sally D 123 East St. Indianapolis IN 47402 8123374564
1121 Scott Robyn L 280 Z St. Indianapolis IN 47405 8123371232
1122 Levitt Quincy D 8C Borrodale Rd. Indianapolis IN 47402 8123327678
1213 Friedman Susan V 2500 S. Leonard Springs Indianapolis IN 47854 8123325734
1214 Lockly Henry O 556 Thompson Bvd. Indianapolis IN 47405 8123338888
1215 Brown Gordy W 3349 Long Dr. Indianapolis IN 47402 8123232234
1216 Cameron Dave G 10 Downing St. Indianapolis IN 47405 8123453454
1217 Thatcher Meg N 100 Iron Ave. Indianapolis IN 47403 8123376999
1218 Young Neal S 17 Candana St. Indianapolis IN 47402 8123229222
1219 Carter Sean L 96 Marcy St. Indianapolis IN 47401 8123372333
1220 Flowers Brandon P 2097 W. Nevada St. Indianapolis IN 47403 8123667366
1221 Spektor Regina Q 4432 S. Oak Ave. Indianapolis IN 47401 8123322565
1222 Williams Hank K 1953 W. Virignia Indianapolis IN 47403 8123373788
1223 Berry Chuck E 1926 Goode Ln. Indianapolis IN 47405 8123577636
1224 Warwick Bill D 233 Euclid Indianapolis IN 47405 8123370009
1225 Nguyen Windy K 998 Main St. Indianapolis IN 47402 8123358156
1226 Mbeki Thabo G 2346 W. Top St. Indianapolis IN 47405 8123326571
1227 de Klerk Frederik W 4344 W. Cape Indianapolis IN 47402 8123252343
1228 Smuts Jan C 1939 2nd St. Indianapolis IN 47854 8123326569
1229 Khama Seretse P 89 N. Top Ave. Indianapolis IN 47405 8123574564
1230 Manuel Trevor R 5776 E. 3rd St. Indianapolis IN 47402 8123350489
1231 Kaunda Ken B 2234 St. Claire Indianapolis IN 47405 8123432342
1232 Botha Louis T 997 Hyper Ave. Indianapolis IN 47403 8123321357
1233 Willems Jacobus J 4889 Sweet St. Indianapolis IN 47402 8123376574
1234 Fischer Bram T 3344 Finley Dr. Indianapolis IN 47401 8123377788
1235 Luthuli Albert N 7764 W. Woodgrove Indianapolis IN 47401 8123374564
1236 Slovo Joe C 9907 S. Red St. Indianapolis IN 47405 8123371232
1237 Livingstone David E 1855 Victoria Falls Indianapolis IN 47405 8123327678
1238 Nkomo Josh M 7746 Elm St. Indianapolis IN 47402 8123325734
1239 Radner Carl R 965 Grimes Indianapolis IN 47405 8123338888
1256 Favret Jan J 145 S. Park Indianapolis IN 47403 8123232234
2192 Creager Lisa S 2345 W. 2nd St. Indianapolis IN 47401 8123453454
4543 Lunts David A 410 W. Seventh St. Indianapolis IN 47854 8123376999
4545 Janks Elmer N 322 Faculty Indianapolis IN 47401 8123229222
4624 Shaw Henry I 423 Woodlawn Indianapolis IN 47405 8123372333
5145 Schwartz Rupert A 622 S. Fess Indianapolis IN 47405 8123667366
5555 Downes Joe H 435 S. Washington Indianapolis IN 47401 8123322565
5789 Burns Lucy B 1215 S. Grant St. Indianapolis IN 47402 8123373788
5790 Nestor Terry G 1256 International Bvd. Indianapolis IN 47405 8123577636
5791 Jonhson Josh J 2219 N. Meridian St. Indianapolis IN 47402 8123370009
5792 Richards Kim H 377 Union Cr. Indianapolis IN 47405 8123358156
5793 Mullens Heather R 744 Bad Road Indianapolis IN 47403 8123326571
5794 North Victor D 9442 S State Rd. Indianapolis IN 47402 8123252343
5795 Degelow George P 902 N State. Rd. Indianapolis IN 47401 8123326569
5796 Richardson Alistair S 5432 Laurent Dr. Indianapolis IN 47401 8123574564
5797 Sweeny Lilian C 706 Red Ln. Indianapolis IN 47405 8123350489
5798 Drake Winston P 3429 E. Washington St. Indianapolis IN 47405 8123432342
6376 Smith Willard M 56 Belgravia Indianapolis IN 47402 8123321357
6745 Einstein Frank K 876 Crystal Ln. Indianapolis IN 47402 8123376574
6770 Winnie Jennifer E 1323 S. Henderson Indianapolis IN 47405 8123377788
6789 Quine Chris Y 810 S. Washington Indianapolis IN 47402 8123374564
6876 Ramsey Betty W 242 Popcorn Rd. Indianapolis IN 47405 8123371232
6877 Underforth Henrietta H 12 N. Oxford St. Indianapolis IN 47401 8123327678
6878 Grant Neville B 780 Kessler Bvld. Indianapolis IN 47401 8123325734
6879 Berry Milton O 2998 W. Matchbox St. Indianapolis IN 47405 8123338888
6880 Kipling Oliver S 5778 Southeastern Indianapolis IN 47405 8123232234
6881 Williams Will A 8742 S. Nova Scotia Indianapolis IN 47402 8123453454
6882 Mathers Marshall M 9912 S. Uttica Rd. Indianapolis IN 47405 8123376999
6883 Kerouac Ivor L 459 E. Madison St. Indianapolis IN 47403 8123229222
6884 Moriarty Dean N 806 W. Kentucky Ave. Indianapolis IN 47401 8123372333
6885 Paredes Carlos V 2000 Memory Ln. Indianapolis IN 47854 8123667366
6886 Morales Vicente M 30 E. Beachfront Ave. Indianapolis IN 47401 8123322565
6887 Joneeees Terrance W 3588 N. Poplar Dr. Indianapolis IN 47405 8123373788
7087 Allison Mark H 122 S. Grant St. Indianapolis IN 47403 8123577636
7356 Gardner Bertrand L 744 Bad Road Indianapolis IN 47402 8123370009
7357 Jameson Hector P 99 Alma St. Indianapolis IN 47402 8123358156
7358 Evora Nicole F 17 S. Rodeo Dr. Indianapolis IN 47402 8123326571
7359 Zimmerman Florence S 3875 Arizona St. Indianapolis IN 47405 8123252343
7360 Stephens Gabby J 5488 Red Ln. Indianapolis IN 47402 8123326569
7361 Whiskers Peter T 789 Sunlight Ave. Indianapolis IN 47405 8123574564
7362 Valentine Max M 1776 Independence St. Indianapolis IN 47401 8123350489
7363 Prufrock Alfred J 18 Corro Grotto Indianapolis IN 47401 8123432342
7364 Victoria Alexander I 9167 N. Allisonville Rd. Indianapolis IN 47405 8123321357
7365 Masterford Leonard A 887 Fall Creek Bvd. Indianapolis IN 47405 8123376574
7366 Pinkerton Josiah G 1567 Binford Bvd. Indianapolis IN 47402 8123377788
7611 Obeng Patrick B 23 E. 1st St. Indianapolis IN 47405 8123374564
7665 Roberts Gwendolyn G 767 W. 5th Indianapolis IN 47403 8123371232
7721 Lunts Albert F 4333 Silver Ct. Indianapolis IN 47401 8123327678
7897 James Rebecca P 654 S. Lincoln Indianapolis IN 47403 8123325734
7898 Martinez Holly E 201 Posh Pl. Indianapolis IN 47401 8123338888
7899 Longsworth Gustav P 421 Victoria Ave. Indianapolis IN 47854 8123232234
7900 Lin Julie M 863 E. Claymore St. Indianapolis IN 47401 8123453454
7901 Kuznetsov Vladimir P 9998 Main St. Indianapolis IN 47405 8123376999
7902 Wen Charles C 2143 S. Maxwell Indianapolis IN 47403 8123229222
7903 Choe Joe D 2897 E. McCarty Indianapolis IN 47402 8123372333
7904 Petrov Alexy A 567 N. Deleware St. Indianapolis IN 47402 8123667366
7905 Schneider Heinrich A 3119 W. Tibbs Indianapolis IN 47402 8123322565
7906 Papadopoulos Paul D 84 Pickadilly Ln. Indianapolis IN 47405 8123373788
7907 MacDougal Dennis L 2166 Industrial Dr. Indianapolis IN 47402 8123577636
7957 Feng Hillary Q 124 Cottage Grove Indianapolis IN 47405 8123370009
8098 Russell Carol X 7114 Smithville Rd. Indianapolis IN 47401 8123358156
8099 McCormick Cyrus F 1 Reaper St. Indianapolis IN 47408 8123326571
9999 Your Last Name Your First Name 501 E. Delray St. Indianapolis IN 47401 8123348563

donations

DonationID PersonID Amount DonationDate Donation_Type_ID
1 1237 200 2009-02-15 1
2 5145 250 2009-02-15 1
3 5796 500 2009-02-15 1
4 6876 175 2009-02-15 1
5 6880 200 2009-02-15 1
6 7361 250 2009-02-15 1
7 7901 450 2009-02-15 1
8 7957 300 2009-02-15 1
9 1116 200 2009-02-15 1
10 1117 350 2009-02-15 1
11 1223 3500 2009-02-15 1
12 1227 450 2009-02-15 1
13 2192 200 2009-02-15 1
14 5791 275 2009-02-15 1
15 5794 325 2009-02-15 1
16 6885 500 2009-02-15 1
17 6880 50 2009-03-17 1
18 7361 50 2009-03-17 1
19 7901 50 2009-03-17 1
20 7957 50 2009-03-17 1
21 1116 50 2009-03-17 2
22 1117 50 2009-03-18 2
23 1223 500 2009-03-18 2
24 1227 50 2009-03-19 2
25 5794 50 2009-03-19 2
26 6885 50 2009-03-19 2
27 1217 50 2009-03-19 2
28 1224 50 2009-03-21 2
29 6882 50 2009-03-21 2
30 6884 50 2009-03-21 2
31 7087 50 2009-03-21 2
32 7898 50 2009-03-21 2
33 1115 50 2009-03-21 2
34 5789 50 2009-03-21 2
35 6886 50 2009-03-21 2
36 7665 50 2009-03-21 2
37 7906 50 2009-03-21 2
38 1122 50 2009-03-21 2
39 1122 50 2009-09-10 2
40 1237 50 2009-09-10 2
41 5145 50 2009-09-10 3
42 5796 50 2009-09-10 3
43 6876 50 2009-09-10 3
44 6880 50 2009-09-10 3
45 7361 50 2009-09-10 3
46 7901 50 2009-09-10 3
47 7957 250 2009-09-10 3
48 1116 50 2009-09-10 3
49 1117 50 2009-09-10 3
50 1223 100 2009-09-12 3
51 1227 50 2009-09-12 3
52 2192 50 2009-09-12 3
53 5791 50 2009-09-12 3
54 5794 150 2009-09-12 3
55 6885 50 2009-09-12 3
56 7665 25 2009-09-13 3
57 7906 50 2009-09-13 3
58 1217 200 2009-09-13 3
59 1224 200 2009-09-14 3
60 6882 50 2009-09-14 3
61 6884 50 2009-09-14 4
62 7087 50 2009-09-14 4
63 7898 50 2009-09-14 4
64 1115 150 2009-09-14 4
65 5789 50 2009-09-14 4
66 6886 50 2009-09-14 4
67 1237 100 2010-03-18 4
68 5145 200 2010-03-18 4
69 5796 350 2010-03-18 4
70 6876 100 2010-03-18 4
71 6880 50 2010-03-18 4
72 7361 250 2010-03-18 4
73 7901 300 2010-03-18 4
74 7957 500 2010-03-18 4
75 1116 150 2010-03-18 4
76 9999 200 2010-03-18 4
77 1223 200 2010-03-18 4
78 1227 450 2010-03-19 4
79 2192 150 2010-03-19 4
80 5791 175 2010-03-19 4
81 5794 200 2010-03-19 5
82 6885 250 2010-03-19 5
83 6882 300 2010-03-19 5
84 6884 500 2010-03-20 5
85 7087 150 2010-03-20 5
86 7898 200 2010-03-20 5
87 7903 350 2010-03-20 5
88 1122 100 2010-09-14 5
89 5145 100 2010-09-14 5
90 5796 100 2010-09-14 5
91 6876 100 2010-09-14 5
92 6880 100 2010-09-14 5
93 7361 100 2010-09-15 5
94 7901 250 2010-09-15 5
95 7957 100 2010-09-15 5
96 1116 100 2010-09-15 5
97 1117 100 2010-09-15 5
98 1223 100 2010-09-15 5
99 1227 100 2010-09-15 5
100 2192 200 2010-09-15 5
101 5791 100 2010-09-15 6
102 7665 100 2010-09-15 6
103 7906 100 2010-09-15 6
104 1217 500 2010-09-15 6
105 1224 100 2010-09-15 6
106 6884 50 2010-09-15 6
107 7087 100 2010-09-15 6
108 7898 100 2010-09-16 6
109 1115 350 2010-09-16 6
110 5789 100 2010-09-16 6
111 6886 150 2010-09-16 6
112 7903 200 2010-09-16 6
113 1232 250 2010-09-16 6
114 1237 100 2010-09-16 6
115 6885 300 2010-09-16 6
116 9999 600 2010-09-16 6

participation

EventID PersonID
1 9999
1 1116
1 1117
1 1122
1 1214
1 1223
1 1227
1 1232
1 1237
1 1239
1 2192
1 5145
1 5791
1 5794
1 5796
1 5797
1 6770
1 6876
1 6880
1 6882
1 6884
1 6885
1 7087
1 7357
1 7358
1 7361
1 7611
1 7665
1 7901
1 7906
1 7957
2 1116
2 1117
2 1122
2 1214
2 1223
2 1227
2 1232
2 1237
2 2192
2 5145
2 5791
2 5794
2 5796
2 6876
2 6880
2 7361
2 7901
2 7957
3 1122
3 1214
3 1227
3 1232
3 1237
3 9999
3 2192
3 5145
3 5796
3 6876
3 6880
4 1113
4 1116
4 1117
4 1214
4 1217
4 1218
4 1219
4 1223
4 1224
4 1227
4 1230
4 1232
4 1237
4 1239
4 2192
4 5145
4 5791
4 5794
4 5796
4 5797
4 6770
4 6876
4 6880
4 6882
4 6884
4 6885
4 7087
4 7357
4 7358
4 7361
4 7362
4 7363
4 7611
4 7665
4 7898
4 7901
4 7903
4 7906
4 7957
4 8099
5 1115
5 1122
5 1214
5 1222
5 1230
5 1232
5 1237
5 1239
5 5145
5 5796
5 5797
5 6770
5 6876
5 6880
5 6882
5 6884
5 7087
5 7357
5 7361
5 7362
5 7363
5 7901
5 7957
6 1113
6 1116
6 1117
6 1122
6 1214
6 1217
6 1218
6 1219
6 1222
6 1223
6 1224
6 1227
6 1230
6 1232
6 1237
6 1239
6 2192
6 5145
6 5791
6 5794
6 5796
6 5797
6 6770
6 6880
6 6882
6 6884
6 6885
6 7087
6 7357
6 7358
6 7361
6 7362
6 7363
6 7611
6 7665
6 7898
6 7901
6 7903
6 7906
6 9999
6 7957
6 8098
6 8099
7 1115
7 1119
7 1122
7 1214
7 1232
7 1235
7 1237
7 5145
7 6876
7 6880
7 7361
7 7957
8 1119
8 1214
8 1222
8 1232
8 1235
8 1237
8 1239
8 5145
8 5796
8 5797
8 6770
8 6876
8 6880
8 6882
8 6884
8 7087
8 7357
8 7361
8 7362
8 7363
8 7898
8 7901
8 7904
8 7957
9 1113
9 1122
9 1214
9 1217
9 1218
9 1232
9 1237
9 2192
9 5145
9 5794
9 5796
9 6876
9 6880
9 6885
9 7357
9 7358
9 7361
9 7362
9 7611
9 7665
9 7901
9 7906
9 7957
9 8098
10 1113
10 1115
10 1116
10 1117
10 1119
10 1122
10 1214
10 1217
10 1218
10 1219
10 1222
10 1223
10 1224
10 1227
10 1230
10 1232
10 1235
10 1237
10 1239
10 2192
10 5145
10 5789
10 5791
10 5794
10 5796
10 5797
10 6770
10 6876
10 6880
10 6882
10 6884
10 6885
10 6886
10 7087
10 7357
10 7358
10 7361
10 7362
10 7363
10 7611
10 7665
10 7721
10 7898
10 7901
10 7903
10 7904
10 7906
10 7907
10 7957
10 8098
10 8099
10 9999

volunteershift

ShiftID PersonID ShiftDate Hours
1 1112 2009-02-15 2
2 1113 2009-02-15 5
3 1114 2009-02-15 4
4 1115 2009-02-15 2
5 1116 2009-02-15 2
6 1117 2009-02-15 5
7 1118 2009-02-15 2.5
8 1220 2009-02-15 10
9 1221 2009-02-15 2.3
10 1222 2009-02-15 2.5
11 1223 2009-02-15 7
12 1224 2009-02-15 4
13 1225 2009-02-15 2
14 1226 2009-02-15 1
15 1115 2009-02-15 0.5
16 1116 2009-02-15 1.7
17 1117 2009-03-17 1.5
18 1118 2009-03-17 1.3
19 1220 2009-03-17 1.8
20 1221 2009-03-17 10
21 1222 2009-03-17 8
22 1234 2009-03-18 9
23 1238 2009-03-18 4
24 1239 2009-03-19 5
25 1256 2009-03-19 6
26 2192 2009-03-19 2
27 4543 2009-03-19 3
28 4545 2009-03-21 4.5
29 4624 2009-03-21 2.3
30 5145 2009-03-21 2
31 5555 2009-03-21 5
32 5789 2009-03-21 4
33 5790 2009-03-21 2
34 5791 2009-03-21 2
35 4545 2009-03-21 5
36 4624 2009-03-21 2.5
37 5145 2009-03-21 10
38 5555 2009-03-21 2.3
39 5789 2009-09-10 2.5
40 5790 2009-09-10 7
41 5791 2009-09-10 4
42 5791 2009-09-10 2
43 5795 2009-09-10 1
44 5796 2009-09-10 0.5
45 5797 2009-09-10 1.7
46 5798 2009-09-10 1.5
47 6376 2009-09-10 1.3
48 6745 2009-09-10 1.8
49 6770 2009-09-10 10
50 6789 2009-09-12 8
51 6876 2009-09-12 9
52 6877 2009-09-12 4
53 6878 2009-09-12 5
54 6879 2009-09-12 6
55 6880 2009-09-12 2
56 6881 2009-09-13 3
57 6882 2009-09-13 4.5
58 6883 2009-09-13 2.3
59 6884 2009-09-14 2
60 6885 2009-09-14 5
61 6886 2009-09-14 4
62 6887 2009-09-14 2
63 7087 2009-09-14 2
64 7356 2009-09-14 5
65 7357 2009-09-14 2.5
66 7358 2009-09-14 10
67 7359 2010-03-18 2.3
68 7360 2010-03-18 2.5
69 7361 2010-03-18 7
70 7362 2010-03-18 4
71 7363 2010-03-18 2
72 7364 2010-03-18 1
73 7365 2010-03-18 0.5
74 7366 2010-03-18 1.7
75 7611 2010-03-18 1.5
76 7665 2010-03-18 1.3
77 7721 2010-04-17 1.8
78 7897 2010-05-17 10
79 7898 2010-06-16 8
80 7899 2010-07-16 9
81 7900 2010-08-15 4
82 7901 2010-09-14 5
83 7902 2010-10-14 6
84 7903 2010-11-13 2
85 7904 2010-12-13 3
86 7905 2011-01-12 4.5
87 7906 2011-02-11 2.3
88 7907 2011-03-13 2
89 7957 2011-03-16 5
90 8098 2011-03-19 4
91 8099 2011-03-22 2
92 7897 2011-03-25 2
93 7898 2011-03-28 5
94 7899 2011-03-31 2.5
95 7900 2011-04-03 10
96 7901 2011-04-06 2.3
97 7902 2011-04-09 2.5
98 7903 2011-04-12 7
99 7904 2011-04-15 4
100 7905 2011-04-18 2
101 7906 2011-04-21 1
102 7907 2011-04-24 0.5
103 1115 2011-04-27 1.7
104 1116 2011-04-30 1.5
105 1117 2011-05-03 1.3
106 1118 2011-05-06 1.8
107 1220 2011-05-09 10
108 1221 2011-05-12 8
109 1222 2011-05-15 9
110 1115 2011-05-18 4
111 1116 2011-05-21 5
112 1117 2011-05-24 6
113 1118 2011-05-27 2
114 1220 2011-05-30 3
115 1221 2011-06-02 4.5
116 1222 2011-06-05 2.3
117 7905 2011-06-08 2
118 7906 2011-06-11 5
119 7907 2011-06-14 4
120 7957 2011-06-17 2
121 8098 2011-06-20 2
122 5145 2011-06-23 5
123 5555 2011-06-26 2.5
124 5789 2011-06-29 10
125 5791 2011-07-02 2.3
126 5795 2011-07-05 2.5
127 5796 2011-07-08 7
128 5797 2011-07-11 4
129 5798 2011-07-14 2
130 6376 2011-07-17 1
131 6745 2011-07-20 0.5
132 6770 2011-07-23 1.7
133 6789 2011-07-26 1.5
134 6876 2011-07-29 1.3
135 1223 2011-08-01 1.8
136 1227 2011-08-04 10
137 2192 2011-08-07 8
138 5791 2011-08-10 9
139 5794 2011-08-13 4
140 6885 2011-08-16 5
141 7358 2011-08-19 6
142 7611 2011-08-22 2
143 7665 2011-08-25 3
144 7906 2011-08-28 4.5
145 1239 2011-08-31 2.3
146 5797 2011-09-03 2
147 6770 2011-09-06 5
148 6882 2011-09-09 4
149 6884 2011-09-12 2
150 7087 2011-09-15 2
151 7357 2011-09-18 5
152 1122 2011-09-21 2.5
153 1214 2011-09-24 10
154 1232 2011-09-27 2.3
155 1237 2011-09-30 2.5
156 5145 2011-10-03 7
157 5796 2011-10-06 4
158 6876 2011-10-09 2
159 6880 2011-10-12 1
160 7361 2011-10-15 0.5
161 7901 2011-10-18 1.7
162 7957 2011-10-21 1.5
163 1116 2011-10-24 1.3

events

EventID Name EventDate
1 Community Action Day 2009-01-14
2 Annual Appeal 2009-06-30
3 Clothing Drive 2009-09-01
4 Barn Dance 2009-10-31
5 Volunteer Appreciation 2009-12-01
6 Pledge Drive 2010-02-14
7 Planting Day 2010-04-01
8 Kid's Night 2010-05-25
9 End of Summer Party 2010-07-20
10 Food Drive 2010-08-04

donation_type

Donation_Type_ID Donation_Type_Name
1 Cash
2 Pledge
3 In_Kind
4 Durable_Goods
5 Property
6 Memorial or Honorary Gift