Access Homework--Helloworld

profilesirian1973
training.accdb
Home>Information Systems homework help>Access Homework--Helloworld
MemberID ProgramID FirstName LastName Street City State Zip Phone JoinDate ExpirationDate MembershipStatus
1103 201 Spencer Buckmiller 29 Prospect Street Ashland VA 23005 8045503050 1/16/13 1/16/14 Active
1105 204 Barry Hassan 9 Harrington Avenue Richmond VA 23220 8042366717 3/2/13 3/2/15 Active
1106 202 Debbie Ward 18 Barton Street Richmond VA 23219 8046748462 4/22/13 10/22/13 Active
1110 201 Ashish Mittal 103 Hubbard Way Glen Allen VA 23058 8045537986 4/3/13 4/3/14 On Hold
1111 203 Liz Sorrento 134 Lincoln Road Chester VA 23831 8047511270 2/10/13 8/20/13 Active
1115 203 Michelle Kim 290 Brook Mill Road Bon Air VA 23235 8043230291 5/17/13 5/17/15 Active
1116 207 Robert DeCosta 35 Washington Street Richmond VA 23220 8042364121 8/4/13 8/4/14 Inactive
1117 203 Paul Novick 302 Great Road Ashland VA 23005 8045501164 9/20/13 9/20/15 Active
1120 202 Carmen Sanchez 1294 Monument Avenue Richmond VA 23219 8046745991 10/18/13 9/25/14 On Hold
1121 209 Kelly Smith 7 Lakeview Road Chester VA 23831 8047510466 7/18/13 7/18/14 Active
1125 203 Jessica Picard 17 Briarwood Lane Mechanicsville VA 23111 8045590909 6/22/13 12/22/13 Active
1126 204 Sam Bethel 258 Elm Street Mechanicsville VA 23111 8045591750 5/19/13 5/19/14 Active
1131 207 Olivia Alexander 29 Newtown Circle Richmond VA 23220 8042360642 3/11/13 3/11/15 Active
1135 201 Tina Sun 682 Hickory Way Chester VA 23831 8047519111 6/3/13 6/3/14 Active
1136 212 Mary Grant 913 Main Street Chester VA 23831 8047518772 5/1/13 5/1/15 Active
1137 210 Alan Fraser 41 Carver Hill Road Mechanicsville VA 23111 8045595885 3/20/13 3/20/14 Active
1139 210 Peter Grigas 3 Pleasant Street Glen Allen VA 23058 8045531642 6/9/13 6/9/15 Inactive
1140 206 Ronald Cunningham 52 Putnam Road Ashland VA 23005 8045507732 2/4/13 8/4/13 Active
1142 207 Kye Nguyen 456 Harringont Avenue Richmond VA 23220 8042360325 2/20/13 2/20/15 On Hold
1143 206 Barry Feinberg 73 Endicott Avenue Chester VA 23831 8047511119 10/5/13 10/5/14 Active
1144 208 Colleen Murphy 47 Winter Street Mechanicsville VA 23111 8045591651 6/9/13 6/9/14 Active
1146 209 Marlene Halpin 75 Elm Boulevard Bon Air VA 23235 8043230346 7/17/13 7/17/15 On Hold
1147 210 Elijah Slomich 108 Roosevelt Avenue Mechanicsville VA 23111 8045595060 8/2/13 8/2/15 On Hold
1148 212 Todd Wolfe 18 Parker Avenue Richmond VA 23219 8046742140 9/20/13 9/20/14 Active
1150 203 Zach Adgate 92 Apple Blossom Lane Ashland VA 23005 8045506119 10/15/13 10/15/14 Active
1151 202 Isabella Cimino 429 South Street Ashland VA 23005 8045509870 8/2/13 8/2/14 Active
1153 212 Vinnie Tumbiolo 358 East Street Richmond VA 23219 8046741434 5/19/13 5/29/15 Inactive
1154 204 Jamal Asmal 9872 Turnpike Road Richmond VA 23220 8042362194 6/7/13 6/7/14 Active
1155 210 Juliette Larsen 35 Walnut Street Glen Allen VA 23058 8045531275 8/1/13 8/1/14 Active
1156 208 Kurt Eisler 5 Bradford Circle Richmond VA 23220 8042368961 4/17/13 4/17/15 On Hold
1158 201 Pedro Fuente 89 Mockingbird Lane Chester VA 23831 8047511847 9/5/13 9/5/14 Active
1159 211 Maggie Hadley 6 Rose Court Ashland VA 23005 8045506103 3/19/13 3/19/14 Active
1160 212 Mark Reynolds 11 Pond Lane Mechanicsville VA 23111 8045594642 6/20/13 6/20/15 Active
1165 207 Shea McKiernan 780 Flint Street Ashland VA 23005 8045500107 7/13/13 7/13/14 Active
1166 203 Abigail Turner 99 Maple Road Richmond VA 23219 8046746807 9/1/13 9/1/15 On Hold
1167 204 George Krukonis 14 Collins Drive Richmond VA 23219 8046744333 5/5/13 5/5/14 Active
1169 211 Maria Gonzalez 100 Tower Drive Richmond VA 23220 8042366337 5/19/13 5/19/14 Active
1170 210 Ed Curran 25 Fairway Drive Bon Air VA 23235 8043236824 10/18/13 12/3/13 Active
1172 206 Tung Lin 40 Green Boulevard Richmond VA 23220 8046740227 11/16/13 11/26/14 Active
ProgramID ProgramType MonthlyFee PhysicalRequired
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
205 Young Adult Special (ages 18-25) ¤ 20.00 false
206 Adult1 Limited (ages 26-35) ¤ 40.00 false
207 Adult2 Full (ages 36-50) ¤ 55.00 false
208 Adult2 Limited (ages 36-50) ¤ 40.00 false
209 Senior1 Full (ages 51-65) ¤ 45.00 true
210 Senior1 Limited (ages 51-65) ¤ 30.00 true
211 Senior2 Full (ages 66 and over) ¤ 35.00 true
212 Senior2 Limited (ages 66 and over) ¤ 25.00 true
213 Senior2 Special (ages 66 and over) ¤ 15.00 true
PARAMETERS __ProgramID Value; SELECT DISTINCTROW * FROM tblMember AS frmProgramsAndMembers WHERE ([__ProgramID] = ProgramID);
SELECT DISTINCTROW * FROM tblMember;
SELECT DISTINCTROW * FROM tblProgram;
SELECT DISTINCTROW * FROM tblProgram;
SELECT DISTINCTROW * FROM tblProgram;
SELECT [tblProgram].[ProgramID], [tblProgram].[ProgramType], [tblProgram].[MonthlyFee], [tblMember].[MemberID], [tblMember].[FirstName], [tblMember].[LastName], [tblMember].[City], [tblMember].[Phone], [tblMember].[JoinDate] FROM tblProgram INNER JOIN tblMember ON tblProgram.ProgramID=tblMember.ProgramID;
SELECT Max(tblProgram.MonthlyFee) AS MaximumFee, Min(tblProgram.MonthlyFee) AS MinimumFee, Avg(tblProgram.MonthlyFee) AS AverageFee FROM tblProgram;
SELECT tblMember.City, Max(tblProgram.MonthlyFee) AS MaximumFee, Min(tblProgram.MonthlyFee) AS MinimumFee, Avg(tblProgram.MonthlyFee) AS AverageFee FROM tblProgram INNER JOIN tblMember ON tblProgram.ProgramID = tblMember.ProgramID GROUP BY tblMember.City;
SELECT tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.JoinDate, tblProgram.ProgramType, tblProgram.MonthlyFee FROM tblProgram INNER JOIN tblMember ON tblProgram.ProgramID = tblMember.ProgramID WHERE (((tblMember.JoinDate) Between #6/1/2013# And #6/30/2013#));
SELECT tblMember.FirstName, tblMember.LastName, tblMember.JoinDate, tblProgram.MonthlyFee, tblProgram.PhysicalRequired FROM tblProgram INNER JOIN tblMember ON tblProgram.ProgramID = tblMember.ProgramID WHERE (((tblProgram.PhysicalRequired)=Yes)) ORDER BY tblMember.JoinDate DESC;
SELECT tblProgram.ProgramID, tblProgram.ProgramType, tblProgram.MonthlyFee, tblProgram.PhysicalRequired FROM tblProgram;
SELECT tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.JoinDate FROM tblMember WHERE (((tblMember.City)="Richmond") AND ((tblMember.MembershipStatus)="On Hold")) ORDER BY tblMember.LastName;
SELECT tblMember.City, tblMember.FirstName, tblMember.LastName, tblProgram.MonthlyFee, tblMember.Phone, tblMember.MembershipStatus FROM tblProgram INNER JOIN tblMember ON tblProgram.ProgramID = tblMember.ProgramID WHERE (((tblMember.City)="Bon Air" Or (tblMember.City)="Glen Allen")) ORDER BY tblMember.City, tblProgram.MonthlyFee DESC;