access homework

profileashkan951
alkuabiy_ali_crn41261_access_lab2.zip_1.accdb
Home>Computer Science homework help>access homework
MemberID ProgramID First Last Street City State Zip Phone DateJoined Expiration Status
1103 201 Joseph Eckler 29 Prospect Street Ashland VA 23005 804-550-3050 1/16/13 1/16/14 Active
1105 204 Barry Hassan 9 Harrington Avenue Richmond VA 23220 804-236-6717 3/2/13 3/2/15 Active
1106 202 Debbie Ward 18 Barton Street Richmond VA 23219 804-674-8462 4/22/13 10/22/13 Active
1110 201 Ashish Mittal 103 Hubbard Way Glen Allen VA 23058 804-553-4737 4/3/13 4/3/14 On Hold
1111 203 Liz Sorrento 134 Lincoln Road Chester VA 23831 804-751-1270 2/10/13 8/20/13 Active
1115 203 Michelle Kim 290 Brook Mill Road Bon Air VA 23235 804-323-0291 5/17/13 5/17/15 Active
1116 207 Robert DeCosta 35 Washington Street Richmond VA 23220 804-236-4121 8/4/13 8/4/14 Inactive
1117 203 Paul Novick 302 Great Road Ashland VA 23005 804-550-1164 9/20/13 9/20/15 Active
1120 202 Carmen Sanchez 1294 Monument Avenue Richmond VA 23219 804-674-5991 10/18/13 9/25/14 On Hold
1121 209 Kelly Smith 7 Lakeview Road Chester VA 23831 804-751-0466 7/18/13 7/18/14 Active
1125 203 Jessica Picard 17 Briarwood Lane Mechanicsville VA 23111 804-559-0909 6/22/13 12/22/13 Active
1126 204 Sam Bethel 258 Elm Street Mechanicsville VA 23111 804-559-1750 5/19/13 5/19/14 Active
1131 207 Olivia Alexander 29 Newtown Circle Richmond VA 23220 804-236-0642 3/11/13 3/11/15 Active
1135 201 Tina Sun 682 Hickory Way Chester VA 23831 804-751-9111 6/3/13 6/3/14 Active
1136 212 Mary Grant 913 Main Street Chester VA 23831 804-751-8772 5/1/13 5/1/15 Active
1137 210 Alan Fraser 41 Carver Hill Road Mechanicsville VA 23111 804-559-5885 3/20/13 3/20/14 Active
1139 210 Peter Grigas 3 Pleasant Street Glen Allen VA 23058 804-553-1642 6/9/13 6/9/15 Inactive
1140 206 Ronald Cunningham 52 Putnam Road Ashland VA 23005 804-550-7732 2/4/13 8/4/13 Active
1142 207 Kye Nguyen 456 Harringont Avenue Richmond VA 23220 804-236-0325 2/20/13 2/20/15 On Hold
1143 206 Barry Feinberg 73 Endicott Avenue Chester VA 23831 804-751-1119 10/5/13 10/5/14 Active
1144 208 Colleen Murphy 47 Winter Street Mechanicsville VA 23111 804-559-1651 6/9/13 6/9/14 Active
1146 209 Marlene Halpin 75 Elm Boulevard Bon Air VA 23235 804-323-0346 7/17/13 7/17/15 On Hold
1147 210 Elijah Slomich 108 Roosevelt Avenue Mechanicsville VA 23111 804-559-5060 8/2/13 8/2/15 On Hold
1148 212 Todd Wolfe 18 Parker Avenue Richmond VA 23219 804-674-2140 9/20/13 9/20/14 Active
1150 203 Zach Adgate 92 Apple Blossom Lane Ashland VA 23005 804-550-6119 10/15/13 10/15/14 Active
1151 202 Isabella Cimino 429 South Street Ashland VA 23005 804-550-9870 8/2/13 8/2/14 Active
1153 212 Vinnie Tumbiolo 358 East Street Richmond VA 23219 804-674-1434 5/19/13 5/29/15 Inactive
1154 204 Jamal Asmal 9872 Turnpike Road Richmond VA 23220 804-236-2194 6/7/13 6/7/14 Active
1155 210 Juliette Beaumont 35 Walnut Street Glen Allen VA 23058 804-553-1275 8/1/13 8/1/14 Active
1156 208 Kurt Eisler 5 Bradford Circle Richmond VA 23220 804-236-8961 4/17/13 4/17/15 On Hold
1158 201 Pedro Fuente 89 Mockingbird Lane Chester VA 23831 804-751-1847 9/5/13 9/5/14 Active
1159 211 Maggie Hadley 6 Rose Court Ashland VA 23005 804-550-6103 3/19/13 3/19/14 Active
1160 212 Mark Reynolds 11 Pond Lane Mechanicsville VA 23111 804-559-4642 6/20/13 6/20/15 Active
1165 207 Shea McKiernan 780 Flint Street Ashland VA 23005 804-550-0107 7/13/13 7/13/14 Active
1166 203 Abigail Turner 99 Maple Road Richmond VA 23219 804-674-6807 9/1/13 9/1/15 On Hold
1167 204 George Krukonis 14 Collins Drive Richmond VA 23219 804-674-4333 5/5/13 5/5/14 Active
1169 211 Maria Gonzalez 100 Tower Drive Richmond VA 23220 804-236-6337 5/19/13 5/19/14 Active
1170 210 Ed Curran 25 Fairway Drive Bon Air VA 23235 804-323-6824 3/6/10 3/12/10 Active
1172 206 Tung Lin 40 Green Blvd Richmond VA 23220 804-674-0227 11/16/10 11/16/10 Active
Program ID Program Type Monthly Fee Physical Required
201 Junior Full (ages 13-17) ¤ 35.00 true
202 Junior Limited (ages 13-17) ¤ 25.00 true
203 Young Adult Full (ages 18-25) ¤ 45.00 false
204 Young Adult Limited (ages 18-25) ¤ 30.00 false
206 Adult1 Limited (ages 26-35) ¤ 45.00 false
207 Adult2 Full (ages 36-50) ¤ 60.00 false
208 Adult2 Limited (ages 36-50) ¤ 45.00 false
209 Senior1 Full (ages 51-65) ¤ 50.00 true
210 Senior1 Limited (ages 51-65) ¤ 35.00 true
211 Senior2 Full (ages 66 and over) ¤ 40.00 true
212 Senior2 Limited (ages 66 and over) ¤ 30.00 true
SELECT DISTINCTROW * FROM [ProgramTable-ClairMason];
SELECT DISTINCTROW * FROM [Physicals Needed-AliAlkuabiy];
SELECT DISTINCTROW * FROM [Physicals Needed-AliAlkuabiy];
SELECT [ProgramTable-ClairMason].[Program ID], [ProgramTable-ClairMason].[Program Type], [ProgramTable-ClairMason].[Monthly Fee], [ProgramTable-ClairMason].[Physical Required] FROM [ProgramTable-ClairMason];