Microsoft Access Assignment

task.accdb

Home >Information Systems homework help >Microsoft Access Assignment

MemberID	PlanID	FirstName	LastName	Street	City	State	Zip	Phone	DateJoined	Expiration
1201	304	Denis	Davidson	286 Cheyenne Ave	Louisville	CO	80027	3035506119	11/15/16	11/15/17
1202	312	Bess	Hanson	103 Hubbard St	Boulder	CO	80305	3032366717	12/1/15	3/1/16
1205	312	Ava	Poirier	462 Rambler Rd	Boulder	CO	80302	3035595060	12/3/15	3/3/16
1207	304	Rick	Reynolds	320 Great Rd	Westminster	CO	80030	7205594642	12/20/15	12/20/16
1208	304	Kara	Murray	302 Pond Ln	Boulder	CO	80301	3035591651	1/9/16	1/9/17
1209	312	Lucy	Xiong	56 Tuckerman St	Boulder	CO	80302	3033230291	1/17/16	4/17/16
1210	312	Todd	Grant	6 Rosebriar Rd	Erie	CO	80516	3036742140	1/20/16	4/20/16
1211	308	Marg	Hadley	128 Follins Rd	Lafayette	CO	80026	3035506103	2/1/16	8/1/16
1214	302	Elizabeth	Griswold	350 Elm St	Jamestown	CO	80455	3037518772	2/1/16	2/1/17
1215	301	Keely	Ward	1294 Monument Ave	Boulder	CO	80305	3036748462	2/22/16	2/22/17
1216	305	Abella	Montaz	2200 Douglas St	Arvada	CO	80003	7202361794	2/25/16	8/25/16
1218	307	Maria	Turner	78 Flint St	Boulder	CO	80301	3036746807	3/1/16	9/1/16
1220	301	Federico	Medina	100 Hill Tower Dr	Boulder	CO	80302	3035595885	3/1/16	3/1/17
1221	312	Joseph	Albert	52 Fairway Dr	Boulder	CO	80305	3035503051	3/12/16	6/12/16
1223	310	Kurt	Fletcher	2 Wilber Ln	Boulder	CO	80302	3032368961	3/20/16	6/20/16
1224	310	Louisa	Sanchez	551 Harrington Ave	Boulder	CO	80304	3036745991	4/1/16	7/1/16
1225	308	Jamela	Picard	8 Calico Ct	Boulder	CO	80304	7205590909	4/1/16	10/1/16
1226	303	Maria	Duarte	74 Winter St	Boulder	CO	80304	3035500107	4/13/16	4/13/17
1228	308	Eric	Larsen	852 Winslow Rd	Boulder	CO	80302	3035531275	4/22/16	10/22/16
1230	305	Lisbeth	Sorrento	921 Prospect St	Erie	CO	80516	7207511270	4/25/16	10/25/16
1231	306	Marco	Krukonis	514 Collins Dr	Arvada	CO	80002	7206744333	5/5/16	11/5/16
1232	305	Marlene	Parker	64 Alderman Rd	Boulder	CO	80305	3033230346	5/20/16	11/20/16
1235	306	Jamal	Asmal	81 Barton St	Louisville	CO	80027	3032362194	5/28/16	11/28/16
1236	303	Rita	Smith	94 Newtown Ct	Boulder	CO	80301	7207510466	6/1/16	6/1/17
1237	310	Mary	Cunningham	742 Southbridge St	Boulder	CO	80305	3035507732	6/1/16	9/1/16
1239	303	Michael	DeCosta	163 Jeremiah Ave	Arvada	CO	80002	3032364121	6/3/16	6/3/17
1240	304	Mike	Nguyen	972 Turnpike Rd	Boulder	CO	80303	3032360325	6/14/16	6/14/17
1242	302	Olivia	Pedicini	58 Santos Rd	Boulder	CO	80302	3032360642	6/27/16	6/27/17
1245	309	Marla	Gonzalez	33 Pleasant St	Lafayette	CO	80026	3032366337	7/1/16	10/1/16
1246	306	Peter	Horovitz	7 Fort Union St	Louisville	CO	80027	3035531642	7/9/16	1/9/17
1247	307	Ramone	Reyes	456 Harris Ave	Boulder	CO	80301	3035591750	7/19/16	1/19/17
1249	307	Vincent	Tumbiolo	55 Johnson Blvd	Arvada	CO	80002	3036741434	8/1/16	2/1/17
1250	312	Min	Kim	66 Carver Rd	Boulder	CO	80302	3035501164	8/1/16	11/1/16
1251	302	Steven	Curran	13 Lincoln Rd	Louisville	CO	80027	3036740227	8/15/16	8/15/17
1254	312	Tomas	Vargas	111 Rocky Mountain Ave	Boulder	CO	80301	7207511119	8/18/16	11/18/16
1255	310	Amartya	Krishna	88 Green Blvd	Boulder	CO	80304	3037511847	9/5/16	12/5/16
1256		Tina	Louis	25 Putnam Rd	Jamestown	CO	80455	3037519111	9/12/16	12/12/16
1258	303	Kristi	Culberson	98 Lark Ln	Boulder	CO	80303	3035537986	9/20/16	9/20/17
1260	307	Arietta	Cimino	71 Beechwood St	Erie	CO	80516	3035509870	9/25/16	3/25/17
1200	311	Muhammed	Aslan	45 Lakeview Dr	Boulder	CO	80301	3035591238	11/1/15	2/1/16

PlanID	PlanDescription	PlanCost	FeeWaived
301	20 tasks per month for 12 months	¤ 6,000.00	true
302	18 tasks per month for 12 months	¤ 5,400.00	true
303	15 tasks per month for 12 months	¤ 4,500.00	true
304	10 tasks per month for 12 months	¤ 3,000.00	true
305	18 tasks per month for 6 months	¤ 2,700.00	true
306	15 tasks per month for 6 months	¤ 2,250.00	true
307	10 tasks per month for 6 months	¤ 1,800.00	false
308	8 tasks per month for 6 months	¤ 1,500.00	false
309	15 tasks per month for 3 months	¤ 1,125.00	false
310	12 tasks per month for 3 months	¤ 900.00	false
311	10 tasks per month for 3 months	¤ 750.00	false
312	8 tasks per month for 3 months	¤ 600.00	false

SELECT tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.DateJoined, tblPlan.PlanDescription, tblPlan.PlanCost FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID WHERE (((tblMember.DateJoined) Between #4/1/2016# And #4/30/2016#));

SELECT Min(tblPlan.PlanCost) AS [Lowest Cost], Max(tblPlan.PlanCost) AS [Highest Cost], Avg(tblPlan.PlanCost) AS [Average Cost] FROM tblPlan;

SELECT tblMember.City, Min(tblPlan.PlanCost) AS [Lowest Cost], Max(tblPlan.PlanCost) AS [Highest Cost], Avg(tblPlan.PlanCost) AS [Average Cost] FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID GROUP BY tblMember.City;

SELECT DISTINCTROW * FROM tblMember;

PARAMETERS __PlanID Value; SELECT DISTINCTROW * FROM Member AS frmMembersByPlan WHERE ([__PlanID] = PlanID);

SELECT tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.Phone, tblMember.Expiration FROM tblMember WHERE (((tblMember.Expiration)>=#1/1/2017#) AND ((tblMember.City)="Louisville")) ORDER BY tblMember.LastName;

SELECT tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.Phone, tblMember.City, tblMember.Expiration FROM tblMember WHERE (((tblMember.Expiration)>=#1/1/2017#)) OR (((tblMember.City)="Louisville")) ORDER BY tblMember.City;

SELECT tblMember.FirstName, tblMember.LastName, tblMember.DateJoined, tblPlan.PlanCost FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID WHERE (((tblPlan.FeeWaived)=Yes)) ORDER BY tblMember.DateJoined DESC;

SELECT tblPlan.PlanID, tblPlan.PlanDescription, tblPlan.PlanCost FROM tblPlan;

SELECT DISTINCTROW * FROM tblPlan;

SELECT DISTINCTROW * FROM tblMember;

SELECT DISTINCTROW * FROM tblPlan;

SELECT tblPlan.PlanID, tblPlan.PlanDescription, tblPlan.PlanCost, tblPlan.FeeWaived, tblMember.MemberID, tblMember.FirstName, tblMember.LastName, tblMember.City, tblMember.Phone, tblMember.DateJoined, tblMember.Expiration FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID;

SELECT DISTINCTROW * FROM tblPlan;