Microsoft Access 2013

job.accdb

Home >Computer Science homework help >Microsoft Access 2013

MemberID	CardNum	ExpDate
1202	9876-5432-1234-5678	3/4/17
1207	8642-0975-3196-3083	10/3/18
1215	3055-2529-8786-6812	9/4/17
1223	6334-4300-1000-7219	7/3/19

MemberID	PlanID	FirstName	LastName	Street	City	State	Zip	Phone	DateJoined	Expiration	MemberComments	MemberStatus
1200	311	Student First	Student Last	45 Lakeview Dr	Boulder	CO	80301	303-559-1238	11/1/15	2/1/16	buy groceries	active
1201	304	Denis	Davidson	286 Cheyenne Ave	Louisville	CO	80027	303-550-6119	11/15/16	11/15/17		active
1202	312	Bess	Hanson	103 Hubbard St	Boulder	CO	80305	303-236-6717	12/1/15	3/1/16		active
1205	312	Ava	Poirier	462 Rambler Rd	Boulder	CO	80302	303-559-5060	12/3/15	3/3/16		active
1207	304	Rick	Reynolds	320 Great Rd	Westminster	CO	80030	720-559-4642	12/20/15	12/20/16		active
1208	304	Kara	Murray	302 Pond Ln	Boulder	CO	80301	303-559-1651	1/9/16	1/9/17		on hold
1209	312	Lucy	Xiong	56 Tuckerman St	Boulder	CO	80302	303-323-0291	1/17/16	4/17/16		on hold
1210	312	Todd	Grant	6 Rosebriar Rd	Erie	CO	80516	303-674-2140	1/20/16	4/20/16		inactive
1211	308	Marg	Hadley	128 Follins Rd	Lafayette	CO	80026	303-550-6103	2/1/16	8/1/16		inactive
1214	302	Elizabeth	Griswold	350 Elm St	Jamestown	CO	80455	303-751-8772	2/1/16	2/1/17		on hold
1215	301	Keely	Ward	1294 Monument Ave	Boulder	CO	80305	303-674-8462	2/22/16	2/22/17		active
1216	305	Abella	Montaz	2200 Douglas St	Arvada	CO	80003	720-236-1794	2/25/16	8/25/16		active
1218	307	Maria	Turner	78 Flint St	Boulder	CO	80301	303-674-6807	3/1/16	9/1/16		active
1220	301	Federico	Medina	100 Hill Tower Dr	Boulder	CO	80302	303-559-5885	3/1/16	3/1/17		active
1221	312	Joseph	Albert	52 Fairway Dr	Boulder	CO	80305	303-550-3051	3/12/16	6/12/16		active
1223	310	Kurt	Fletcher	2 Wilber Ln	Boulder	CO	80302	303-236-8961	3/20/16	6/20/16		active
1224	310	Louisa	Sanchez	551 Harrington Ave	Boulder	CO	80304	303-674-5991	4/1/16	7/1/16		active
1225	308	Jamela	Picard	8 Calico Ct	Boulder	CO	80304	720-559-0909	4/1/16	10/1/16		active
1226	303	Maria	Duarte	74 Winter St	Boulder	CO	80304	303-550-0107	4/13/16	4/13/17		active
1228	308	Eric	Larsen	852 Winslow Rd	Boulder	CO	80302	303-553-1275	4/22/16	10/22/16		active
1230	305	Lisbeth	Sorrento	921 Prospect St	Erie	CO	80516	720-751-1270	4/25/16	10/25/16		active
1231	306	Marco	Krukonis	514 Collins Dr	Arvada	CO	80002	720-674-4333	5/5/16	11/5/16		active
1232	305	Marlene	Parker	64 Alderman Rd	Boulder	CO	80305	303-323-0346	5/20/16	11/20/16		active
1235	306	Jamal	Asmal	81 Barton St	Louisville	CO	80027	303-236-2194	5/28/16	11/28/16		active
1236	303	Rita	Smith	94 Newtown Ct	Boulder	CO	80301	720-751-0466	6/1/16	6/1/17		active
1237	310	Mary	Cunningham	742 Southbridge St	Boulder	CO	80305	303-550-7732	6/1/16	9/1/16		active
1239	303	Michael	DeCosta	163 Jeremiah Ave	Arvada	CO	80002	303-236-4121	6/3/16	6/3/17		active
1240	304	Mike	Nguyen	972 Turnpike Rd	Boulder	CO	80303	303-236-0325	6/14/16	6/14/17		active
1242	302	Olivia	Pedicini	58 Santos Rd	Boulder	CO	80302	303-236-0642	6/27/16	6/27/17		on hold
1245	309	Marla	Gonzalez	33 Pleasant St	Lafayette	CO	80026	303-236-6337	7/1/16	10/1/16		active
1246	306	Peter	Horovitz	7 Fort Union St	Louisville	CO	80027	303-553-1642	7/9/16	1/9/17		active
1247	307	Ramone	Reyes	456 Harris Ave	Boulder	CO	80301	303-559-1750	7/19/16	1/19/17		active
1249	307	Vincent	Tumbiolo	55 Johnson Blvd	Arvada	CO	80002	303-674-1434	8/1/16	2/1/17		active
1250	312	Min	Kim	66 Carver Rd	Boulder	CO	80302	303-550-1164	8/1/16	11/1/16		active
1251	302	Steven	Curran	13 Lincoln Rd	Louisville	CO	80027	303-674-0227	8/15/16	8/15/17		active
1254	312	Tomas	Vargas	111 Rocky Mountain Ave	Boulder	CO	80301	720-751-1119	8/18/16	11/18/16		inactive
1255	310	Amartya	Krishna	88 Green Blvd	Boulder	CO	80304	303-751-1847	9/5/16	12/5/16		on hold
1256		Tina	Louis	25 Putnam Rd	Jamestown	CO	80455	303-751-9111	9/12/16	12/12/16		inactive
1258	303	Kristi	Culberson	98 Lark Ln	Boulder	CO	80303	303-553-7986	9/20/16	9/20/17		on hold
1260	307	Arietta	Cimino	71 Beechwood St	Erie	CO	80516	303-550-9870	9/25/16	3/25/17		active

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

TaskID	ClassDay	StartTime	TaskLength
300	MW	12/30/99	12/30/99
301	MW	12/30/99	12/30/99
302	MW	12/30/99	12/30/99
303	MW	12/30/99	12/30/99
304	MW	12/30/99	12/30/99
305	TH	12/30/99	12/30/99
306	TH	12/30/99	12/30/99
307	TH	12/30/99	12/30/99
308	TH	12/30/99	12/30/99
309	TH	12/30/99	12/30/99
310	TH	12/30/99	12/30/99
311	TH	12/30/99	12/30/99
312	TH	12/30/99	12/30/99
313	TH	12/30/99	12/30/99
314	TH	12/30/99	12/30/99
315	TH	12/30/99	12/30/99
316	TH	12/30/99	12/30/99
317	TH	12/30/99	12/30/99

TaskID	MemberID
300	1200
300	1202
300	1221
300	1232
300	1239
301	1220
301	1230
302	1205
302	1207
302	1216
306	1225
306	1231
306	1246
306	1251
307	1205
307	1224
307	1237
307	1245
307	1250
311	1225
311	1251
313	1200
313	1223
313	1240
314	1247
315	1201
315	1215
315	1218
315	1226
315	1228
315	1235
315	1249
315	1260
316	1215
316	1226
316	1236

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

SELECT DISTINCTROW * FROM tblPlan;

TRANSFORM Sum(tblPlan.[PlanCost]) AS SumOfPlanCost SELECT tblPlan.[PlanDescription], Sum(tblPlan.[PlanCost]) AS [Total Of PlanCost] FROM tblPlan GROUP BY tblPlan.[PlanDescription] PIVOT tblPlan.[FeeWaived];

SELECT [tblPlan].[PlanID], [tblPlan].[PlanDescription], [tblPlan].[PlanCost], [tblPlan].[FeeWaived] FROM tblPlan LEFT JOIN tblMember ON [tblPlan].[PlanID] = [tblMember].[PlanID] WHERE ([tblMember].[PlanID] Is Null);

SELECT tblPlan.PlanID, tblPlan.FeeWaived, tblPlan.PlanDescription, tblPlan.PlanCost, tblMember.FirstName, tblMember.LastName FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID ORDER BY tblPlan.PlanID, tblPlan.FeeWaived, tblMember.LastName;

SELECT DISTINCTROW * FROM tblMember;

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

SELECT DISTINCTROW * FROM tblPlan;

SELECT DISTINCTROW * FROM tblMember;

SELECT DISTINCTROW * FROM tblPlan;