Microsoft Access 2013

access_assignment.zip

Home >Computer Science homework help >Microsoft Access 2013

Access Assignment/Assignment/Tutorial 10 Case 1.JPG

Access Assignment/Assignment/Tutorial 11 Case 1.JPG

Access Assignment/Data files for assignment/Case1/Job.accdb

MemberID	CardNum	ExpDate
1202	9876-5432-1234-5678	2017-03-04
1207	8642-0975-3196-3083	2018-10-03
1215	3055-2529-8786-6812	2017-09-04
1223	6334-4300-1000-7219	2019-07-03

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

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;

Access Assignment/Data files for assignment/Case1/NewTasks.accdb

TaskID	TaskDesc
101	Grocery Shopping
102	Painting
103	Rake Leaves
104	Shovel Snow
105	Shopping
106	Cooking
107	House Cleaning
108	Errands
109	Clean Windows
110	Dusting
111	Wash Floors
112	Walking
113	Driving
114	Swimming
115	Hiking
116	Clean Shed
117	Gardening
118	Prune Trees
119	Medical Appointment
120	Computer Assistance
121	Friendly Visit

Access Assignment/Data files for assignment/Case2/.DS_Store

Access Assignment/Data files for assignment/Case2/Amy_Hawkins_Associate_Degree.docx

Joseph Brant Community College

THIS CERTIFIES THAT

amy hawkins

has successfully completed the required course of study approved by the Board of Education for the State of Michigan, and is therefore awarded this

Associate Degree

Dated this 29th day of May, 2011

Pamela Lee		Roger Samuels
President		Vice Principal Academic

image1.png

Access Assignment/Data files for assignment/Case2/Amy_Hawkins_Bachelor_Degree.pdf

ORANGE GROVE UNIVERSITY

THIS CERTIFIES THAT

AMY HAWKINS

has successfully completed the required course of study approved by the Board of Education for

the State of Michigan, and is therefore awarded this

BACHELOR DEGREE

Dated this 5th day of May, 2008

Richard Meaden

Theo Yan President Vice Principal Academic

Access Assignment/Data files for assignment/Case2/Lesson.accdb

ContractID	StudentID	TutorID	ContractDate	SessionType	Length	NumSessions	Cost	Assessment
5100	CAR8059	31-1200	2015-08-01	Group	4	6	¤ 960.00	true
5101	DEN8042	33-0122	2015-09-18	Group	3	6	¤ 720.00	true
5102	NUN8084	69-2254	2015-09-30	Semi-private	2	8	¤ 800.00	true
5103	AND8009	27-0505	2015-12-01	Private	2	8	¤ 960.00	true
5105	GOS8029	51-7070	2015-12-15	Group	3	8	¤ 960.00	false
5107	WOO8071	88-0022	2015-12-15	Semi-private	3	12	¤ 1,800.00	true
5108	HEC8018	69-2254	2015-12-17	Semi-private	3	6	¤ 900.00	true
5110	YEN8035	43-4006	2016-01-07	Group	4	8	¤ 1,280.00	true
5113	ZWI8066	31-1200	2016-01-10	Group	3	8	¤ 960.00	false
5115	PAP8024	33-0122	2016-01-15	Group	4	6	¤ 960.00	false
5117	MUE8041	51-7070	2016-01-15	Private	3	8	¤ 1,440.00	false
5118	COL8031	55-1234	2016-01-20	Group	3	12	¤ 1,440.00	true
5121	ROC8025	50-3390	2016-01-25	Group	4	6	¤ 960.00	true
5123	OAT8010	88-0022	2016-01-26	Private	3	8	¤ 1,440.00	true
5125	GUS8002	69-2254	2016-01-28	Group	3	6	¤ 720.00	true
5126	NAS8012	79-0678	2016-02-01	Group	3	8	¤ 960.00	false
5128	SPE8022	66-5010	2016-02-01	Private	2	8	¤ 960.00	true
5130	BAT8045	68-8234	2016-02-10	Group	3	8	¤ 960.00	true
5131	HIN8040	55-1234	2016-03-01	Group	3	8	¤ 960.00	true
5133	TUR8005	68-8234	2016-03-01	Group	4	8	¤ 1,280.00	false
5135	BIE8000	19-3726	2016-03-14	Semi-private	3	12	¤ 1,800.00	true
5136	STI8038	51-7070	2016-03-15	Private	2	6	¤ 720.00	true
5138	VAR8027	71-1698	2016-04-03	Private	3	6	¤ 1,080.00	true
5140	BAL8033	19-3726	2016-04-16	Group	4	8	¤ 1,280.00	true
5141	SHE8090	55-1234	2016-05-03	Group	4	12	¤ 1,920.00	false
5143	MAS8056	31-1200	2016-05-08	Group	4	6	¤ 960.00	true
5146	YEN8035	50-3390	2016-06-22	Private	2	12	¤ 1,440.00	false
5148	ZWI8066	79-0678	2016-07-07	Private	2	8	¤ 960.00	true
5149	PAP8024	66-5010	2016-07-10	Private	3	6	¤ 1,080.00	false
5151	ROC8025	33-0122	2016-07-11	Group	3	8	¤ 960.00	true
5154	MOS8053	68-8234	2016-07-12	Group	4	8	¤ 1,280.00	false
5158	CAR8059	36-1664	2016-07-15	Semi-private	2	12	¤ 1,200.00	true
5159	MAH8053	27-0505	2016-07-16	Private	2	6	¤ 720.00	true
5161	DEN8042	66-5010	2016-08-01	Semi-private	2	8	¤ 800.00	true
5163	MCS8051	36-1664	2016-08-01	Semi-private	2	8	¤ 800.00	false
5166	RIV8011	19-3726	2016-08-10	Private	3	6	¤ 1,080.00	false
5167	ENR8055	43-4006	2016-08-23	Group	3	8	¤ 960.00	true
5168	LUF8037	68-8234	2016-08-30	Group	3	12	¤ 1,440.00	true
5169	TAR8049	88-0022	2016-08-30	Group	3	6	¤ 720.00	true
5170	TAR8050	88-0022	2016-08-30	Group	3	6	¤ 720.00	true
5171	PLU8015	36-1664	2016-09-09	Private	3	8	¤ 1,440.00	false
5172	GOS8029	71-1698	2016-09-07	Private	2	6	¤ 720.00	true
5174	GUS8002	69-2254	2016-09-10	Semi-private	3	6	¤ 900.00	true
5175	NAS8012	79-0678	2016-09-12	Semi-private	2	8	¤ 800.00	true
5176	TUR8005	50-3390	2016-09-15	Private	3	8	¤ 1,440.00	true
5177	DRO8048	27-0505	2016-09-15	Private	2	6	¤ 720.00	true
5178	VAR8027	71-1698	2016-09-20	Private	2	8	¤ 960.00	true

StudentID	FirstName	LastName	Address	City	State	Zip	CreditRelationship	CreditCardNum
AYO8022	Rebecca	Ayotte	880 Northern Ave	South Bend	IN	46613	Mother	1357-2468-9753-8642
BIE8000	Allison	Biega	122 Chestnut St	Mishawaka	IN	46544	Mother	8908-9999-9999-9999
DEN8042	Adam	DeNardo	283 Tulane Dr	South Bend	IN	46617	Father	7890-8888-8888-8888
GUS8002	Samantha	Gustafson	329 Murphy Ave	Oscela	IN	46561	Mother	4989-7777-7777-7777
KAV8030	Alexa	Kavik	504 Windemere Ave	Mishawaka	IN	46544	Student	1908-6666-6666-6666
MAS8056	Weldon	Mase	550 Allanville St	Oscela	IN	46561	Father	2196-5555-5555-5555
PAP8024	Ben	Pappas	781 Merchants Rd	South Bend	IN	46619	Father	6736-4444-4444-4444
SPE8022	Leslie	Vargas	1220 Holcomb Dr	South Bend	IN	46637	Mother	2217-3333-3333-3333

EquipmentNum	Equipment	MonthlyRentalCost
19	Calculator	¤ 5.00
20	Calculator	¤ 5.00
21	Tablet computer	¤ 25.00
22	Tablet computer	¤ 30.00
23	Tablet computer	¤ 25.00
24	Microscope	¤ 30.00
25	Microscope	¤ 30.00
26	Microscope	¤ 30.00
27	Laptop computer	¤ 45.00
28	Laptop computer	¤ 30.00
29	Laptop computer	¤ 50.00
30	Desktop computer	¤ 75.00
31	Desktop computer	¤ 90.00
32	Desktop computer	¤ 75.00
33	Tablet computer	¤ 35.00
34	Tablet computer	¤ 35.00
35	Tablet computer	¤ 35.00
36	Laptop computer	¤ 35.00
37	Laptop computer	¤ 35.00
39	Laptop computer	¤ 35.00
40	Laptop computer	¤ 35.00
41	Laptop computer	¤ 35.00

EquipmentNum	ContractID
19	5117
19	5154
20	5110
21	5140
24	5117
25	5101
25	5138
26	5108
28	5115
29	5133
30	5101
32	5148
32	5149
33	5130
34	5141
36	5121
36	5161
37	5128
39	5151
40	5175

StudentID	FirstName	LastName	Address	City	State	Zip	HomePhone	CellPhone	BirthDate	Gender
AND8009	Student First	Student Last	5678 Wayside Ct	New Carlisle	IN	46552	574-654-2245	574-654-0091	2002-10-10	F
AYO8022	Andrea	Ayotte	880 Northern Ave	South Bend	IN	46613	574-204-2227	574-472-2308	2002-11-28	F
BAL8033	Sean	Balise	462 Main St	South Bend	IN	46614	574-210-5326	574-485-1045	2001-06-12	M
BAT8045	Gerta	Batchelder	87 Calvin Ct	Mishawaka	IN	46544	574-252-4409	574-252-4932	2000-08-20	F
BIE8000	Joshua	Biega	122 Chestnut St	Mishawaka	IN	46544	574-252-1135	574-527-0219	2001-01-12	M
CAR8059	Carol	Carlson	1213 Winter St	South Bend	IN	46613	574-220-8410	574-220-9625	2001-09-24	F
CHA8034	Henry	Chang	1401 Lauren Dr	Oscela	IN	46561	574-607-3045	574-674-2410	1999-10-05	M
COL8031	Morris	Coldwell	205 Cinder St	Mishawaka	IN	46544	574-254-0838	574-527-7712	2002-07-26	M
DEN8042	David	DeNardo	283 Tulane Dr	South Bend	IN	46617	574-245-9610	574-514-8337	2001-03-27	M
DRO8048	Emma	Drouin	1910 Davidson St	Oscela	IN	46561	574-607-2368	574-674-1275	2001-10-24	F
ELL8065	Jack	Ellis	16 Court St	South Bend	IN	46637	574-228-3663	574-228-6540	2001-10-20	M
ENR8055	Bess	Enright	1715 Honeycomb Dr	New Carlisle	IN	46552	574-654-8879	574-654-5951	2002-02-04	F
GOS8029	Haley	Gosnold	1763 Ryan Ct	Mishawaka	IN	46544	574-255-3027	574-520-1033	2001-11-29	F
GUS8002	Michael	Gustafson	329 Murphy Ave	Oscela	IN	46561	574-674-4038	574-256-9117	2001-09-13	M
HEC8018	Eric	Hecht	30 Calico St	South Bend	IN	46617	574-234-7433	574-564-1956	2000-04-04	M
HIN8040	Erica	Hinkle	55 Shepley Rd	Oscela	IN	46561	574-675-2553	574-547-5573	2000-06-14	F
KAV8030	Alexa	Kavik	504 Windemere Ave	Mishawaka	IN	46544	574-675-8864	574-675-6876	2000-04-23	F
LUF8037	Greg	Luff	145 Powell Blvd	New Carlisle	IN	46552	574-654-1430	574-654-8002	2002-01-31	M
MAH8053	Albert	Mahlau	1012 Barlow Rd	South Bend	IN	46637	574-217-6218	574-564-1018	2000-03-15	M
MAS8056	Kimberly	Mase	550 Allanville St	Oscela	IN	46561	574-679-6639	574-563-9511	1999-07-27	F
MCS8051	Lauren	McShea	195 Utah St	Oscela	IN	46561	574-607-1269	574-530-7722	2002-12-13	F
MOS8053	Anesha	Mosychuk	185 Sammy Ln	South Bend	IN	46637	574-217-0559	574-485-6303	2002-11-13	F
MUE8041	Bart	Mueller	1347 Lance Rd	Oscela	IN	46561	574-651-1155	574-646-8902	2001-04-18	M
NAS8012	Andre	Nastasia	668 Nora Dr	Oscela	IN	46561	574-651-3379	574-617-9245	2000-02-16	M
NUN8084	Rodrigo	Nunez	140 Lower County Rd	South Bend	IN	46637	574-232-3156	574-514-8882	2000-10-13	M
OAT8010	Kyle	Oates	45 Sebastian Rd	South Bend	IN	46619	574-232-4828	574-232-5228	2001-07-06	M
PAP8024	Zach	Pappas	781 Merchants Rd	South Bend	IN	46619	574-259-6004	574-232-2790	2001-06-16	M
PLU8015	Dana	Plummer	405 Palmer Ave	New Carlisle	IN	46552	574-645-8155	574-654-3581	2001-11-20	F
RIV8011	Marco	Rivera	4321 Farmcrest St	Oscela	IN	46561	574-607-1517	574-640-0443	2001-05-22	M
ROC8025	Daniel	Roche	2385 Vista Dr	South Bend	IN	46613	574-220-3717	574-617-7984	2002-03-23	M
SHE8090	Marci	Sheppard	135 Bradford Pl	South Bend	IN	46614	574-232-4221	574-232-5322	2000-08-23	F
SPE8022	Ross	Spence	1220 Holcomb Dr	South Bend	IN	46637	574-233-7998	574-514-7299	2001-08-22	M
STI8038	Lily	Stiefel	164 Maris St	Oscela	IN	46561	574-675-4232	574-258-0202	2002-10-19	F
TAR8049	Isabella	Tartaglia	5 Ryebrook Ave	Mishawaka	IN	46544	574-256-7302	574-536-7819	2001-10-14	F
TAR8050	Donato	Tartaglia	5 Ryebrook Ave	Mishawaka	IN	46544	574-256-7302	574-536-7899	2001-10-14	M
TUR8005	Lynne	Turner	6 Crowell Ct	South Bend	IN	46614	574-245-2125	574-245-8842	2002-07-24	F
VAR8027	Vera	Vargas	37 Great Western Rd	South Bend	IN	46617	574-220-5928	574-245-1972	2002-09-18	F
WOO8071	Jon	Woodburn	445 Avalon Dr	South Bend	IN	46613	574-228-9284	574-204-9284	2001-06-20	M
YEN8035	Lila	Yen	1220 Burkhill St	Oscela	IN	46561	574-607-9451	574-607-8841	1999-09-30	F
ZWI8066	Robert	Zwicker	68 King St	Mishawaka	IN	46545	574-256-2148	574-527-2479	2001-05-01	M

SubjectID	Subject	MonthlyCost
19	Math1	¤ 50.00
20	Math1	¤ 50.00
21	Bio1	¤ 25.00
22	Bio1	¤ 30.00
23	Bio1	¤ 25.00
24	History1	¤ 30.00
25	History1	¤ 30.00
26	History1	¤ 30.00
27	History1	¤ 45.00
28	History1	¤ 30.00
29	History1	¤ 50.00
30	Math2	¤ 75.00
31	Math2	¤ 90.00
32	Math2	¤ 75.00
33	Chem1	¤ 35.00
34	Chem1	¤ 35.00
35	Chem1	¤ 35.00
36	Math3	¤ 35.00
37	Math3	¤ 35.00
39	Math3	¤ 35.00
40	Math3	¤ 35.00
41	Math3	¤ 35.00
50	Math4	¤ 50.00
51	Math4	¤ 50.00
52	Bio2	¤ 25.00
53	Bio2	¤ 30.00
54	Bio2	¤ 25.00
55	History2	¤ 30.00
56	History2	¤ 30.00

TutorID	FirstName	LastName	Degree	School	HireDate	Groups	Coordinator
19-3726	Melissa	Michau	BA	Robert Frost State College	2015-01-06	false	27-0505
27-0505	Michaela	Jellinek	MS	Kilderry College	2016-06-20	false
31-1200	Student First	Student Last	BA	Pierre University	2015-08-02	true	27-0505
33-0122	Amy	Hawkins	BS	Rosebriar College	2015-08-04	true	27-0505
36-1664	Youngho	Lim	EdD	Weisser Technical Institute	2016-04-01	false	55-1234
43-4006	Lori	Burns	BA	University of Reedsville	2016-03-03	true	69-2254
50-3390	Deborah	Nowak	BA	Guilford-Grant College	2015-06-03	false	27-0505
51-7070	Alameda	Sarracino	MA	Edgar Lee University	2016-03-22	false	69-2254
55-1234	Samuel	Glick	BA	Manoog College	2016-07-23	true
66-5010	Jacques	LaFarge	MA	College of the North West	2016-01-25	false	27-0505
68-8234	Caitlin	Shea	MS	Towns University	2016-01-05	true	55-1234
69-2254	Sachi	Hatanaka	MA	Wyman College	2015-03-23	false
71-1698	Richard	Keating	PhD	Hobert University	2015-05-03	false	27-0505
79-0678	Riley	Andoval	BS	University of Piperstown	2015-09-05	false	69-2254
88-0022	Len	Onida	BS	Tomason College	2015-02-17	false	69-2254

SELECT [tblStudent].[StudentID], [tblStudent].[LastName], [tblStudent].[FirstName] FROM tblStudent ORDER BY [LastName], [FirstName];

SELECT [tblContract].[ContractID] FROM tblContract;

SELECT [tblTutor].[TutorID], [tblTutor].[FirstName], [tblTutor].[LastName] FROM tblTutor ORDER BY [LastName];

SELECT DISTINCTROW * FROM tblContract;

SELECT tblTutor.TutorID, [tblTutor]![FirstName] & " " & [tblTutor]![LastName] AS TutorName, tblTutor.Degree, tblTutor.School, tblTutor.HireDate, tblTutor.Groups FROM tblTutor ORDER BY tblTutor.LastName, tblTutor.FirstName;

SELECT tblTutor.LastName, tblTutor.FirstName, tblContract.SessionType, tblStudent.FirstName, tblStudent.LastName, tblContract.NumSessions, tblContract.Cost FROM tblStudent INNER JOIN (tblTutor INNER JOIN tblContract ON tblTutor.TutorID = tblContract.TutorID) ON tblStudent.StudentID = tblContract.StudentID ORDER BY tblTutor.LastName, tblTutor.FirstName, tblContract.SessionType;

SELECT tblContract.StudentID, tblContract.ContractDate, tblContract.SessionType, tblContract.Length, tblContract.Cost FROM tblTutor INNER JOIN tblContract ON tblTutor.TutorID = tblContract.TutorID;

SELECT DISTINCTROW * FROM tblTutor;

Access Assignment/Data files for assignment/Case2/Room.accdb

RoomNum	RentalCost	RoomType
6	¤ 15.00	Semi-Private
7	¤ 15.00	Semi-Private
8	¤ 40.00	Group
9	¤ 20.00	Semi-Private
10	¤ 55.00	Group

Access Assignment/Data files for assignment/Case3/Pet.accdb

AnimalID	AnimalName	AnimalAge	AnimalGender	AnimalType	AnimalDesc	ArrivalDate	AdoptionDate	Adopted	PatronID
A23	Missy	7	Female	Cat	Brown with white spots	2016-05-09	2016-06-08	true	30490
A29	Rolf	3	Male	Dog	Beagle mix	2016-08-23		false
A34	Daisy	4	Female	Dog	Beagle mix	2016-02-03		false
A43	Neo	7	Female	Cat	white with a stubby tail	2016-05-04	2016-07-08	true	33104
A49	Tabby	4	Female	Cat	Long hair, white	2016-03-05		false
A55	Penny	8	Female	Dog	Lab mix	2016-05-02	2016-05-14	true	33287
A58	Whiskers	9	Male	Cat	Long hair, white and black	2016-04-23		false
A73	Sammy	5	Female	Cat	Calico mix, short hair	2016-04-14		false
B24	Casey	2	Female	Cat	Calico mix, short hair	2016-03-04	2016-05-22	true	30490
B33	Jack	4	Male	Dog	Terrier mix	2016-03-04	2016-04-22	true	33227
B35	Cutie	2	Female	Cat	Black with white spots	2016-05-23	2016-07-22	true	33902
B45	Gizmo	12	Male	Dog	Hound mix	2016-03-06		false
B55	Oliver	2	Male	Dog	Terrier mix	2016-03-16	2016-04-22	true	36032
C27	Bonnie	9	Male	Cat	Bengal mix	2016-08-04		false
C28	Sophie	4	Female	Cat	Long hair, white, blue eyes	2016-03-14	2016-04-22	true	49484
C29	Tiger	4	Female	Cat	White and orange	2016-07-15		false
C33	Midnight	3	Male	Cat	Black, short hair	2016-03-04		false
C44	Sparky	2	Female	Dog	Long hair, white	2016-03-01		false
C58	Maggy	3	Female	Cat	Calico mix, short hair	2016-04-03	2016-05-04	true	30490
C74	Ginger	4	Female	Cat	Orange with white patches	2016-04-05		false
C92	Wiskers	8	Male	Cat	White, long hair	2016-03-04	2016-06-05	true	48483
D21	Toby	7	Male	Dog	Shepherd mix	2016-05-03	2016-06-01	true	45797
D22	Sparky	3	Male	Dog	medium size, mixed breed	2016-06-18		false
D23	Babar	6	Male	Dog	Shepherd mix, stubby tail	2016-04-09		false
D34	Tommy	5	Female	Dog	Shepherd mix	2016-04-17	2016-04-22	true	48483
D42	Wynn	12	Male	Dog	Short hair, black with white spots, small	2016-02-22	2016-03-04	true	33104
D44	Randy	5	Male	Dog	Hound mix	2016-04-11	2016-04-22	true	47183
D48	Max	6	Male	Dog	Newfoundland mix	2016-04-20		false
D83	Hunter	4	Male	Dog	Lab mix, black, long hair	2016-05-14		false
F14	Sam	5	Male	Dog	Hound mix	2016-03-04		false
F29	Bonzo	2	Male	Dog	Beagle mix	2016-02-09	2016-04-22	true	36051
G23	Tina	2	Female	Dog	Beagle mix	2016-06-03		false
G28	Ginger	2	Female	Cat	Persian mix	2016-04-13		false
G29	Mango	3	Female	Cat	Orange with white spots	2016-05-14	2016-05-27	true	36574
G36	Sarah	3	Female	Cat	White with black and brown spots, short hair	2016-05-03	2016-08-20	true	38985
G45	Molly	5	Female	Dog	Lab mix	2016-04-14	2016-05-22	true	36703
G48	Fluffy	9	Female	Cat	Black with white patches	2016-05-03		false
G56	Haley	2	Female	Dog	Beagle mix	2016-05-18	2016-06-04	true	36062
H04	Pandora	1	Male	Cat	Savannah mix	2016-06-19	2016-07-07	true	36058
H21	Sammy	2	Male	Dog	Retriever mix, golden	2016-06-15	2016-06-22	true	36077
H34	Smokey	4	Male	Cat	Grey, long hair	2016-06-20		false
J28	Marmaduke	8	Male	Dog	Lab mix	2016-03-05	2016-03-22	true	42511
J29	Benny	2	Male	Dog	Retriever mix, large	2016-04-12	2016-05-28	true	41038
J37	Penny	2	Female	Dog	Shepherd mix	2016-02-17		false
K23	Tabby	4	Female	Cat	Calico mix, short hair	2016-04-04		false
K24	Precious	2	Female	Dog	Long hair, brown and white, small	2016-05-03	2016-06-20	true	43097
K25	Scooter	8	Male	Dog	Long hair, brown, medium size	2016-03-08	2016-05-12	true	41630
K33	Spot	2	Female	Dog	Black with white spots	2016-02-05	2016-02-22	true	48127
K34	Sonny	6	Male	Cat	Calico mix	2016-03-19		false
K38	Rusty	4	Female	Cat	Long hair, orange with white patches	2016-04-07		false
K39	Lawrence	2	Male	Dog	Beagle mix	2016-08-14		false
K43	Kitty	3	Female	Cat	Calico mix, long hair	2016-04-03	2016-04-22	true	47767
K48	Pepper	3	Female	Dog	Black and brown	2016-03-18	2016-03-25	true	34525
K94	Carmen	3	Male	Dog	Beagle mix	2016-05-03		false
L45	Jiggles	4	Male	Dog	Brown with white spots, large	2016-07-14		false
M23	Princess	2	Female	Dog	Long hair, black and white, small	2016-04-14		false
M48	Bandit	5	Female	Dog	Border Collie mix	2016-03-12		false
M49	Buster	4	Male	Cat	Brown and white, long hair	2016-02-03		false
M77	Spike	5	Male	Dog	Pug mix	2016-04-06		false
N34	Shadow	3	Male	Cat	Black	2016-04-19		false
N35	Patches	5	Male	Cat	White with black spots	2016-02-03		false
N37	Misty	8	Male	Cat	Grey, long hair	2016-04-12	2016-06-21	true	35511
N43	Jake	12	Male	Dog	Hound mix	2016-03-12	2016-03-24	false
N82	Rudy	7	Male	Dog	Lab mix, golden	2016-06-08		false
N84	Singer	9	Male	Dog	Beagle mix	2016-03-04	2016-04-09	true	36001
N94	Duke	3	Male	Dog	Shepherd mix	2016-06-06		false
P34	Skylar	4	Female	Dog	Lab mix	2016-04-11		false
P38	Patch	6	Male	Dog	Black with brown around the left eye	2016-05-15	2016-06-21	true	36012
P39	Zoey	4	Female	Dog	Pug mix	2016-05-11	2016-05-18	true	33902
P48	Butch	7	Male	Cat	Short hair, black	2016-06-18	2016-08-24	true	36016
R22	Rio	4	Male	Cat	Calico mix, long hair	2016-09-14		false
R27	Spike	4	Male	Dog	Shepherd mix	2016-06-04	2016-06-22	true	36037
R29	Gabby	6	Female	Dog	Brown with black spots above the eyes	2016-03-14	2016-05-02	true	36070
R33	Randy	4	Male	Dog	Beagle mix	2016-04-17	2016-06-25	true	36703
R34	Snooker	6	Male	Dog	Lab mix, golden	2016-04-19		false
R38	Shadow	8	Female	Cat	Black and grey mix	2016-05-03	2016-06-17	true	37223
R39	Simba	3	Female	Cat	Siamese	2016-04-12	2016-05-14	true	38398
R43	Lucky	3	Male	Dog	Collie mix	2016-05-03		false
R45	Molly	7	Female	Cat	Calico mix, long hair	2016-03-04	2016-04-25	true	36070
R55	Spike	5	Male	Dog	Black with brown and white patches, medium	2016-03-04		false
R59	Barky	5	Male	Dog	Sheepdog mix	2016-03-12	2016-05-22	true	38014
R98	Gus	2	Male	Dog	Beagle mix	2016-04-18		false
S31	Charger	4	Female	Cat	Calico mix, long hair	2016-03-15		false
S35	Roggie	8	Male	Cat	Siamese	2016-05-10		false
T23	Fanny	4	Female	Cat	Calico short hair	2016-07-03		false
T32	Buddy	8	Male	Dog	Border Collie mix	2016-05-19		false
T75	Stormy	10	Female	Dog	Grey/brown, medium	2016-03-28		false
V84	Max	8	Male	Dog	Lab mix, black	2016-05-17		false
V98	Chow	3	Male	Dog	Husky mix	2016-06-12		false
W15	Rocky	4	Male	Dog	Husky mix	2016-02-06	2016-06-14	true	38985
W22	Whiskers	3	Female	Cat	Persian mix	2016-03-05		false
W23	Buddy	1	Male	Dog	Beagle mix	2016-06-01	2016-06-08	true	40900
W29	Jenny	2	Female	Cat	Long hair, brown	2016-04-14		false
W52	Sammy	2	Female	Cat	Calico mix	2016-04-19		false
W73	Joselin	3	Female	Cat	White, long hair	2016-03-12		false
Y24	Gini	4	Female	Dog	Hound mix	2016-04-03		false
Y29	Jenny	2	Male	Dog	Beagle mix	2016-04-04	2016-04-12	true	45350
Y33	Sam	2	Male	Cat	Black, long hair	2016-07-07		false
Y35	Spot	9	Female	Dog	Hound mix, small	2016-05-12		false
Y98	Rocky	6	Male	Dog	Black, large	2016-04-29		false

AnimalID	StorageID
A23	1
A29	5
A34	6
A43	2
A49	3
A55	4
A58	1
A73	2
B24	3
B33	5
B35	1
B45	6
B55	5
C27	2
C28	3
C29	1
C33	2
C44	4
C58	2
C74	3
C92	1
D21	5
D22	6
D23	4
D34	5
D42	6
D44	5
D48	4
D83	5
F14	6
F29	5
G23	4
G28	1
G29	2
G36	3
G45	5
G48	1
G56	4
H04	1
H21	4
H34	2
J28	5
J29	6
J37	5
K23	3
K24	6
K25	5
K33	4
K34	2
K38	2
K39	5
K43	1
K48	6
K94	5
L45	4
M23	5
M48	6
M49	2
M77	6
N34	3
N35	3
N37	2
N43	5
N82	4
N84	5
N94	5
P34	6
P38	4
P39	5
P48	1
R22	1
R27	6
R29	4
R33	5
R34	5
R38	2
R39	3
R43	5
R45	1
R55	4
R59	5
R98	6
S31	2
S35	3
T23	1
T32	6
T75	5
V84	4
V98	6
W15	5
W22	1
W23	4
W29	2
W52	3
W73	3
Y24	5
Y29	6
Y33	2
Y35	5
Y98	4

DonationID	PatronID	DonationDate	DonationDesc	DonationTypeID	DonationValue
2100	30490	2016-02-02	Cash donation	C	117
2101	30607	2016-02-06	Cash donation	C	119
2102	30753	2016-02-08	Cash donation	C	245
2103	30891	2016-02-10	Cash donation	C	152
2104	31087	2016-02-12	Dog Food	F	247
2105	32107	2016-02-14	Cash donation	C	289
2108	32810	2016-02-20	Cages	E	120
2109	33046	2016-02-22	Cash donation	C	65
2111	33190	2016-02-26	Cages	E	203
2112	34642	2016-02-28	Dog Food	F	50
2113	33765	2016-03-01	Cat Food	F	135
2114	33765	2016-03-03	Cash donation	C	189
2116	34642	2016-03-07	Pet toys	E	254
2118	34642	2016-03-11	Food Bowls	E	121
2119	34894	2016-03-13	Cat Food	F	186
2120	35105	2016-03-15	Cash donation	C	89
2121	35665	2016-03-17	Cash donation	C	251
2122	35665	2016-03-19	Cash donation	C	72
2123	35828	2016-03-21	Cash donation	C	194
2124	35895	2016-03-23	Dog Food	F	64
2125	36002	2016-03-25	Cash donation	C	223
2126	36002	2016-03-27	Cash donation	C	276
2127	36019	2016-03-29	Cash donation	C	253
2130	36020	2016-04-04	Leashes	E	88
2131	36023	2016-04-06	Cash donation	C	59
2132	36025	2016-04-08	Cash donation	C	270
2133	36028	2016-04-10	Dog Food	F	91
2134	36056	2016-04-12	Cash donation	C	283
2135	36033	2016-04-14	Cash donation	C	87
2136	36041	2016-04-16	Cash donation	C	262
2137	36041	2016-04-18	Cash donation	C	203
2139	36049	2016-04-22	Cages	E	59
2140	36056	2016-04-24	Cash donation	C	122
2141	36055	2016-04-26	Cash donation	C	273
2142	36056	2016-04-28	Cash donation	C	91
2143	36058	2016-04-30	Cat Food	F	271
2145	36073	2016-05-04	Cash donation	C	80
2146	36064	2016-05-06	Cash donation	C	226
2147	36073	2016-05-08	Cash donation	C	269
2148	36073	2016-05-10	Dog Food	F	154
2149	36074	2016-05-12	Dog Food	F	178
2150	36077	2016-05-14	Cash donation	C	54
2151	36183	2016-05-16	Cash donation	C	174
2152	36574	2016-05-18	Cash donation	C	116
2154	37223	2016-05-22	Pet toys	E	299
2155	37454	2016-05-24	Cash donation	C	167
2156	37774	2016-05-26	Cash donation	C	205
2157	40905	2016-05-28	Cash donation	C	68
2158	38154	2016-05-30	Dog Food	F	262
2159	40905	2016-06-01	Dog Food	F	152
2160	38635	2016-06-03	Cash donation	C	57
2161	38848	2016-06-05	Cash donation	C	264
2162	38955	2016-06-07	Cash donation	C	79
2163	40905	2016-06-09	Cash donation	C	104
2164	39007	2016-06-11	Cat Food	F	142
2165	39387	2016-06-13	Cash donation	C	279
2166	39610	2016-06-15	Cash donation	C	163
2167	39619	2016-06-17	Cash donation	C	160
2169	40372	2016-04-14	Pet toys	E	63
2170	40900	2016-04-16	Cash donation	C	78
2171	40905	2016-04-18	Dog Food	F	86
2172	39387	2016-04-20	Cash donation	C	117
2173	39610	2016-04-22	Cash donation	C	256
2175	39644	2016-04-26	Cages	E	258
2176	43685	2016-04-28	Cash donation	C	56
2177	45061	2016-04-30	Cash donation	C	267
2178	45350	2016-05-02	Cash donation	C	229
2179	45797	2016-05-04	Dog Food	F	165
2182	46410	2016-05-10	Cages	E	98
2183	46751	2016-05-12	Cash donation	C	80
2184	46968	2016-05-14	Cash donation	C	248
2185	46997	2016-05-16	Dog Food	F	222
2186	47183	2016-05-18	Cash donation	C	213
2188	47767	2016-03-03	Pet toys	E	81
2189	47984	2016-03-05	Cash donation	C	229
2190	49206	2016-03-07	Cash donation	C	81
2191	48151	2016-03-09	Cat Food	F	62
2192	48372	2016-03-11	Cash donation	C	185
2193	49206	2016-03-13	Dog Food	F	89
2194	49039	2016-03-15	Cash donation	C	253
2195	49115	2016-03-17	Cash donation	C	117
2196	49177	2016-04-12	Dog Food	F	170
2197	49206	2016-04-14	Cash donation	C	196
2198	49206	2016-04-16	Cash donation	C	149
2199	49905	2016-04-18	Cash donation	C	101

FacilityID	FacilityName
A01	Cramer Storage
A02	Oakview Building

PatronID	Title	FirstName	LastName	Phone
30490		Student First	Student Last	770-427-9300
30607	Mr.	Randolph	Kramer	770-528-7835
30753	Ms.	Cynthia	Crosby	678-444-2676
30891	Mrs.	Kelsey	Mayo	678-528-9994
31087	Dr.	Al	Higgins	678-528-2363
32107	Dr.	Tim	Iordan	770-528-7108
32154	Mr.	Paul	Lee	770-528-5466
32189	Mrs.	Gini	Smith	770-499-2775
32810	Mrs.	Sharon	Welch	770-419-2229
33046	Ms.	Marie	Ortega	770-444-6643
33104	Ms.	Cynthia	French	770-528-3396
33190	Mrs.	Diane	Byrd	770-419-4993
33227	Mrs.	Sam	Mueller	678-528-4385
33287	Dr.	Ali	Haddad	770-528-8973
33765	Mrs.	Mandy	Sohar	678-528-5407
33803	Mrs.	Penelope	Stephenson	678-419-6412
33902	Mr.	Ron	Lam	770-528-3387
34525	Mr.	Jim	Murphy	770-499-1074
34642	Mr.	Joe	Giacomelli	678-499-8847
34894	Mrs.	Susan	Lowe	678-444-3454
35105	Mrs.	Beth	Kumar	678-444-1085
35511	Ms.	Amandeep	Patel	770-528-7378
35665	Mrs.	Jenny	Bates	770-444-8885
35828	Mr.	Bob	Jeffreys	770-528-8258
35895	Ms.	Corinne	Graham	678-819-8625
36001	Dr.	Angela	Harris	678-452-8736
36002	Dr.	Brian	Crane	678-277-8767
36012	Mr.	Joe	Martinson	678-823-9275
36016	Mr.	Doug	Fuller	770-793-8477
36019	Ms.	Connie	Delacruz	678-452-1178
36020	Mrs.	JoAnn	McGee	678-309-6540
36023	Ms.	Carole	Walsh	770-771-9152
36025	Mrs.	Mary	Moses	678-598-0569
36028	Mr.	Michael	Carlucci	678-283-6334
36032	Mrs.	Barbara	Schmidt	678-827-9713
36033	Mr.	Brian	Ewing	770-663-1418
36037	Ms.	Sherill	Kussow	678-823-2284
36041	Mrs.	Celia	Brubaker	678-669-3970
36042	Mrs.	Helen	Mullins	678-238-9451
36049	Mrs.	Katharine	Gardiner	678-826-2135
36051	Mr.	Leland	Jaeger	678-309-1655
36055	Ms.	Tina	Sun	678-827-2688
36056	Mr.	Robert	Parkinson	678-263-5896
36058	Mrs.	Rebecca	Lawry	678-825-5583
36060	Mrs.	Dianne	Corrigan	678-826-0063
36062	Mr.	Wesley	Tarkenton	770-282-2556
36064	Ms.	Erika	Lange	678-263-1054
36070	Mrs.	Ashley	Willis	678-827-1862
36073	Mr.	Gerald	Persinger	678-241-2526
36074	Mrs.	Maria	Gonzalez	678-238-0337
36077	Mrs.	Meredith	Dellkamp	678-820-1521
36183	Dr.	Sandy	Velez	770-528-4966
36574	Mrs.	Nellie	Wong	770-819-3399
36703	Ms.	Christine	Weaver	678-419-3174
37223	Mr.	Neil	Cummings	770-419-9968
37454	Ms.	Ramona	Freeman	678-528-1133
37774	Mr.	Bob	Rasmussen	678-528-4981
38014	Mrs.	Fong	Yang	770-427-5977
38154	Mrs.	Simranjeet	Patel	678-819-8112
38398	Mrs.	Cheryl	Jensen	678-528-1743
38635	Mr.	Ken	Phelps	678-528-9991
38848	Mrs.	Mary	Ratliff	770-444-2334
38955	Mrs.	Nadine	Rosales	770-819-2156
38985	Mr.	Jose	Salinas	770-444-5730
39007	Mr.	Roger	Vargas	678-528-2733
39387	Mrs.	Jennifer	Jensen	770-528-3163
39610	Mrs.	Sally	Bruch	770-427-6391
39619	Mr.	Jasjeet	Singh	678-528-4730
39644	Mr.	Amanbir	Singh	770-427-6950
40372	Ms.	Jenny	Webster	770-528-2715
40900	Mr.	Jaspreet	Singh	770-528-3542
40905	Mr.	Albert	Turner	770-528-7227
41038	Ms.	Janet	Wong	770-528-5760
41630	Mr.	Tim	Wallace	770-528-9884
42511	Mrs.	Fong	Chin	770-499-8549
43097	Ms.	Sue	Diaz	770-419-4660
43685	Mr.	Tony	Silva	678-528-4293
45061	Mrs.	Amanda	Bolstad	770-528-8492
45350	Ms.	Linda	Reilly	770-499-6019
45797	Dr.	Susan	Greene	770-499-8386
46260	Mr.	Roger	Hanson	770-528-6771
46342	Dr.	Samantha	Kriby	770-419-8194
46410	Mr.	Steven	Holder	770-819-6729
46751	Ms.	Cheryl	Johns	678-427-7938
46968	Mr.	Albert	Ross	770-819-5092
46997	Ms.	Kathy	Garrett	770-528-7177
47183	Mrs.	Maureen	Lew	770-528-2539
47631	Ms.	Lynn	Lowe	770-528-4155
47767	Mr.	Leslie	Mays	770-528-3626
47984	Mrs.	Marie	Alvarez	770-528-5643
48127	Mrs.	Denise	Farrell	770-819-8838
48151	Mrs.	Janice	Dalton	770-528-5565
48372	Mrs.	Fanny	Stanford	770-528-9637
48483	Mrs.	Diane	Lee	678-499-9356
49039	Dr.	Neil	Santiago	770-528-6084
49115	Ms.	Marie	Holloway	770-528-7048
49177	Ms.	Amanda	Ghomeshi	770-528-1689
49206	Mrs.	Lily	Yee	678-528-4091
49484	Mr.	Arnold	Morton	770-427-2033
49905	Mr.	Jim	Sloan	770-427-1855

StorageID	Location	FacilityID
1	Room 140	A01
2	Room 141	A01
3	Room 142	A01
4	Suite 225	A02
5	Suite 240	A02
6	Suite 250	A02

SELECT DISTINCTROW * FROM tblPatron;

SELECT tblAnimal.AnimalName, tblAnimal.AnimalGender, tblAnimal.AnimalType, tblAnimal.AdoptionDate, tblAnimal.Adopted FROM tblAnimal WHERE (((tblAnimal.AnimalType)="dog") AND ((tblAnimal.Adopted)=Yes)) ORDER BY tblAnimal.AnimalName;

SELECT tblDonation.DonationDesc, tblDonation.DonationDate, tblDonation.DonationValue, tblPatron.FirstName, tblPatron.LastName FROM (tblPatron INNER JOIN tblAnimal ON tblPatron.PatronID = tblAnimal.PatronID) INNER JOIN tblDonation ON tblPatron.PatronID = tblDonation.PatronID ORDER BY tblDonation.DonationDate, tblPatron.LastName;

SELECT [tblPatron].[PatronID] FROM tblPatron;

PARAMETERS __PatronID Text; SELECT DISTINCTROW * FROM [SELECT [tblDonation].[DonationID], [tblDonation].[PatronID], [tblDonation].[DonationDate], [tblDonation].[DonationDesc], [tblDonation].[DonationTypeID], [tblDonation].[DonationValue] FROM tblDonation]. AS frmPatronDonations WHERE ([__PatronID] = PatronID);

SELECT DISTINCTROW * FROM tblPatron;

Access Assignment/Data files for assignment/Case3/Receipt2100.xlsx

Sheet1

Receipt for purchase: 2100
Dog food	$ 412.85
Tax	$ 49.54
Total	$ 462.39

Access Assignment/Data files for assignment/Case3/Receipt2101.xlsx

Sheet1

Receipt for purchase: 2101
Cat food	$ 96.24
Tax	$ 11.55
Total	$ 107.79

Access Assignment/Data files for assignment/Case3/Rescuers.accdb

DriverID	FirstName	LastName
1	Sam	Hoang
2	Pat	Linden
3	Terry	Benson
4	Maria	Nunez

Access Assignment/Data files for assignment/Case4/.DS_Store

Access Assignment/Data files for assignment/Case4/Leary_1.txt

Medical document certifying Edward Leary had his flu vaccine has been verified.

Access Assignment/Data files for assignment/Case4/Leary_2.txt

Medical document certifying Edward Leary had his meningitis vaccine has been verified.

Access Assignment/Data files for assignment/Case4/Vacation.accdb

GuestID	GuestFirst	GuestLast	Address	City	StateProv	PostalCode	Country	Phone
401	Student First	Student Last	10 Winter Ave	Boise	ID	83702	USA	208-344-0975
402	Ingrid	Schmidt	340 Riverside Dr East	Calgary	AB	T1Y 3N4	Canada	403-226-8577
403	Brian	Anderson	5003 Grant Blvd	Great Falls	MT	59401	USA	406-761-4515
405	Leo	Nelson	34 King St	Hamilton	ON	L9C 2T9	Canada	905-388-1212
406	Li	Zhu	3406 Lakeshore Dr	Great Falls	MT	59406	USA	406-761-8109
407	Anna	Martinez	17 Western Ave	Pocatello	ID	83201	USA	208-705-3847
409	Suzanne	Marceaux	734 Great Rd	Cheyenne	WY	82001	USA	314-556-1290
410	Luiz	Neto	8552 Main St	Cheyenne	WY	82002	USA	314-556-7053
411	Sarah	Vanesse	312 Park Rd	Butte	MT	59701	USA	406-782-1882
412	Olivia	Froberg	433 Madison St	Boise	ID	83702	USA	208-344-3055
415	Jose	Gonzales	14 Spencer Blvd	Pocatello	ID	83201	USA	208-705-3044
416	Sushil	Gupta	150 Maple St	Boise	ID	83702	USA	208-344-3339
417	Isabelle	Rouy	227 Front Ln	Calgary	AB	T1Y 2N7	Canada	403-226-0065
419	Patrick	Higgins	2120 W Gable Rd	Pocatello	ID	83711	USA	208-232-1672
420	Alberto	Lopez	991 Crestview Dr	Butte	MT	59701	USA	406-782-1183
421	Amy	DuBrava	118 Forest Rd	Cheyenne	WY	82001	USA	314-556-1275
422	Ansis	Kalnajs	3 March St	Butte	MT	59701	USA	406-782-0312
425	Kelly	Skolnik	15 Tobin Dr	Red Deer	AB	T4N 3D5	Canada	403-755-1597
428	Jacques	Portier	4478 Queen Ave	Windsor	ON	N8X 3Y8	Canada	519-966-9094
429	Paul	Barry	7533 Conant Dr	Butte	MT	59701	USA	406-782-2209
430	Susan	Davis	463 Evergreen Rd	Pocatello	ID	83201	USA	208-705-5943

PersonID	FirstName	LastName	JobTitle	Manager
CH2468	Catherine	Higgins	Tour Manager
CM2222	Christopher	Murphy	Tour Manager
EJ7531	Elizabeth	Jackson	Tour Manager
EJ8888	Edward	Leary	Tour Guide	CH2468
RC1111	Robert	Crane	Tour Guide	EJ7531
SL3333	Susan	Lawrence	Tour Guide	CM2222
TD5555	Thomas	Digby	Tour Guide	EJ7531
TP8642	Theodore	Paine	Tour Guide	CM2222
VW9751	Victoria	Watson	Tour Guide	CH2468

ReservationID	GuestID	StartDate	People	TourID	TourGuide
503	409	2016-06-12	2	3488	EJ8888
504	403	2016-07-11	3	3010	VW9751
507	425	2016-05-12	2	3002	RC1111
510	420	2016-05-01	4	3107	EJ8888
511	401	2016-08-20	2	3142	SL3333
512	411	2016-04-04	3	3222	TP8642
513	416	2016-07-20	8	3007	VW9751
515	402	2016-09-08	1	3050	EJ8888
520	415	2016-08-10	3	3002	TD5555
521	406	2016-06-03	4	3395	RC1111
522	430	2016-06-22	5	3190	SL3333
525	412	2016-07-11	6	3010	EJ8888
530	429	2016-08-05	2	3204	TP8642
531	405	2016-07-11	2	3010	TD5555
535	421	2016-09-10	2	3003	SL3333
536	422	2016-07-20	2	3007	EJ8888
537	410	2016-05-01	3	3107	VW9751
540	411	2016-04-10	2	3222	TD5555
541	428	2016-09-10	4	3003	TP8642
545	403	2016-08-20	1	3142	EJ8888
548	412	2016-10-02	1	3395	SL3333
550	429	2016-10-02	6	3395	RC1111

TourID	TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
3002	Galapagos Wildlife	Galapagos Islands	Ecuador	¤ 5,500.00	¤ 1,200.00	Boat	11	Island beauty; diverse wildlife; boating
3003	Madagascar Photo Expedition	Madagascar	Madagascar	¤ 6,500.00	¤ 1,100.00	Hiking	13	Exotic animals; stunning landscape; hiking
3007	South American Expedition	Pantanal	Brazil	¤ 6,000.00	¤ 1,250.00	Jeep	8	Jaguars; Macaw; Savannah
3010	Amazon River Tour	Manaus	Brazil	¤ 4,500.00	¤ 800.00	Boat	6	River wildlife; native villages; cruise
3050	Inca Trail	Cusco	Peru	¤ 3,800.00	¤ 600.00	Hiking	4	Ancient structures; hiking
3107	Machu Picchu Hike	Cusco	Peru	¤ 4,300.00	¤ 650.00	Hiking	5	Ancient structures; hiking
3142	Petra Desert Tour	Jerusalem	Israel	¤ 4,800.00	¤ 700.00	Jeep	4	Ancient structures; desert; 4x4 jeep
3179	Everglades Kayaking Tour	Miami	U.S.	¤ 800.00	¤ 0.00	Kayak	1	Day trip; kayak; wildlife
3190	Chambok Community Volunteer	Chambok	Cambodia	¤ 6,500.00	¤ 1,200.00	Hiking	12	National Park; Volunteer in the community; Ox cart transportation
3204	Cambodian Agricultural Development	Battambang	Cambodia	¤ 4,500.00	¤ 900.00	Jeep	10	Work on a farm; wildlife; hiking; 4x4 jeep
3222	Malaysian Rainforest Tour	Gunung Mulu National Park	Malaysia	¤ 2,800.00	¤ 500.00	Hiking	6	Walk along the canopy; wildlife; hiking
3395	Himalayan Hike	Trisul	India	¤ 5,600.00	¤ 1,500.00	Hiking	6	Trek around Roopkund Lake; glacier; hiking
3423	India Wildlife Safari	Delhi	India	¤ 6,200.00	¤ 1,800.00	Hiking	10	Tigers; exotic plants; hiking
3488	Birding Adventure	Almaty	Kazakhstan	¤ 2,800.00	¤ 600.00	Hiking	8	Bird watching; hiking

ReservationID	PersonID
503	EJ8888
504	VW9751
507	RC1111
510	EJ8888
511	SL3333
512	TP8642
513	VW9751
515	EJ8888
520	TD5555
521	RC1111
522	SL3333
525	EJ8888
530	TP8642
531	TD5555
535	SL3333
536	EJ8888
537	VW9751
540	TD5555
541	TP8642
545	EJ8888
548	SL3333
550	RC1111

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Galapagos Relaxation	Galapagos Islands	Equador	4200	1000	Boat	7	Island beauty; spa; diverse wildlife
Madagascar Wildlife	Madagascar	Madagascar	5500	800	Hiking	8	Exotic animals; stunning landscape; hiking
South American Adventure	Pantanal	Brazil	4500	800	Hiking	8	Exotic wildlife; hiking; Savannah
Amazon River Adventure Tour	Manaus	Brazil	6800	1200	Boat	12	River wildlife; native villages; cruise; hiking
Inca Trail and Machu Picchu	Cusco	Peru	7800	1800	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	6800	1200	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	1200	300	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	14500	1800	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	3800	800	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Inca Trail and Machu Picchu	Cusco	Peru	7800	1800	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	6800	1200	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	1200	300	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	14500	1800	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	3800	800	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Inca Trail and Machu Picchu	Cusco	Peru	7800	1800	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	6800	1200	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	1200	300	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	14500	1800	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	3800	800	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Galapagos Relaxation	Galapagos Islands	Equador	4200	1000	Boat	7	Island beauty; spa; diverse wildlife
Madagascar Wildlife	Madagascar	Madagascar	5500	800	Hiking	8	Exotic animals; stunning landscape; hiking
South American Adventure	Pantanal	Brazil	4500	800	Hiking	8	Exotic wildlife; hiking; Savannah
Amazon River Adventure Tour	Manaus	Brazil	6800	1200	Boat	12	River wildlife; native villages; cruise; hiking

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Galapagos Relaxation	Galapagos Islands	Equador	4200	1000	Boat	7	Island beauty; spa; diverse wildlife
Madagascar Wildlife	Madagascar	Madagascar	5500	800	Hiking	8	Exotic animals; stunning landscape; hiking
South American Adventure	Pantanal	Brazil	4500	800	Hiking	8	Exotic wildlife; hiking; Savannah
Amazon River Adventure Tour	Manaus	Brazil	6800	1200	Boat	12	River wildlife; native villages; cruise; hiking

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Inca Trail and Machu Picchu	Cusco	Peru	7800	1800	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	6800	1200	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	1200	300	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	14500	1800	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	3800	800	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Galapagos Relaxation	Galapagos Islands	Equador	¤ 4,200.00	¤ 1,000.00	Boat	7	Island beauty; spa; diverse wildlife
Madagascar Wildlife	Madagascar	Madagascar	¤ 5,500.00	¤ 800.00	Hiking	8	Exotic animals; stunning landscape; hiking
South American Adventure	Pantanal	Brazil	¤ 4,500.00	¤ 800.00	Hiking	8	Exotic wildlife; hiking; Savannah
Amazon River Adventure Tour	Manaus	Brazil	¤ 6,800.00	¤ 1,200.00	Boat	12	River wildlife; native villages; cruise; hiking
Inca Trail and Machu Picchu	Cusco	Peru	¤ 7,800.00	¤ 1,800.00	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	¤ 6,800.00	¤ 1,200.00	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	¤ 1,200.00	¤ 300.00	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	¤ 14,500.00	¤ 1,800.00	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	¤ 3,800.00	¤ 800.00	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

TourName	Location	Country	TourPricePerPerson	SingleSupplement	TourType	Nights	Description
Galapagos Relaxation	Galapagos Islands	Equador	4200	1000	Boat	7	Island beauty; spa; diverse wildlife
Madagascar Wildlife	Madagascar	Madagascar	5500	800	Hiking	8	Exotic animals; stunning landscape; hiking
South American Adventure	Pantanal	Brazil	4500	800	Hiking	8	Exotic wildlife; hiking; Savannah
Amazon River Adventure Tour	Manaus	Brazil	6800	1200	Boat	12	River wildlife; native villages; cruise; hiking
Inca Trail and Machu Picchu	Cusco	Peru	7800	1800	Hiking	10	Ancient structures; hiking
Petra Desert Adventure	Jerusalem	Israel	6800	1200	Jeep	7	Ancient structures; desert; 4x4 jeep
Everglades Adventure	Miami	U.S.	1200	300	Kayak	4	kayak; wildlife; hiking
Chambok Community Volunteer Extended	Chambok	Cambodia	14500	1800	Hiking	21	National Park; Volunteer in the community; Ox cart transportation
Malaysian Rainforest Adventure	Gunung Mulu National Park	Malaysia	3800	800	Jeep	10	Walk along the canopy; wildlife; 4x4 jeep

SELECT DISTINCTROW * FROM tblGuest;

SELECT [tblGuest].[GuestID] FROM tblGuest;

SELECT DISTINCTROW * FROM tblGuest;

SELECT tblGuest.GuestID, tblGuest.GuestFirst, tblGuest.GuestLast, tblGuest.Address, tblGuest.City, tblGuest.StateProv, tblGuest.PostalCode, tblGuest.Country, tblGuest.Phone, tblReservation.ReservationID, tblReservation.TourID, tblReservation.StartDate, tblReservation.People FROM tblGuest INNER JOIN tblReservation ON tblGuest.GuestID = tblReservation.GuestID;

SELECT tblTour.TourName, tblTour.Country, tblGuest.StateProv, tblReservation.StartDate, tblReservation.People FROM tblTour INNER JOIN (tblGuest INNER JOIN tblReservation ON tblGuest.GuestID = tblReservation.GuestID) ON tblTour.TourID = tblReservation.TourID ORDER BY tblTour.TourName, tblGuest.StateProv, tblReservation.StartDate;

SELECT DISTINCTROW * FROM tblGuest;

Access Assignment/Data files for assignment/Review/Ads.accdb

AdNum	AdDate	AdCost	Placed
1	2016-07-18	¤ 850.00	Social media
2	2016-07-31	¤ 235.56	Newspaper
3	2016-08-10	¤ 391.42	Flyer
4	2016-08-10	¤ 375.00	Email blast
5	2016-08-31	¤ 300.00	Flyer
6	2016-08-31	¤ 235.56	Newspaper

Access Assignment/Data files for assignment/Review/Autoclave.xlsx

Sheet1

Autoclave Specifications
Chamber Dimensions:	10" diameter
Volume of Chamber:	23L
Number of Sterilization trays:	4
Shipping Weight:	95 lbs

Access Assignment/Data files for assignment/Review/Autoclave_Specification_Sheet.pdf

Autoclave Specifications

Chamber Dimensions: 10" diameter

Volume of Chamber: 23L

Number of Sterilization trays: 4

Shipping Weight: 95 lbs

Access Assignment/Data files for assignment/Review/Product.accdb

InvoiceID	SupplierID	InvoiceDate	InvoiceAmt
1	ARE318	2016-10-11	¤ 8,345.98
2	ARM321	2016-10-11	¤ 475.00
3	BAN299	2016-11-09	¤ 956.30
4	BAR297	2016-11-09	¤ 1,051.45
5	CAN374	2016-10-11	¤ 848.84
6	CAR446	2016-10-11	¤ 5,237.58
7	COU392	2016-10-11	¤ 5,657.81
8	CRO403	2016-11-09	¤ 4,090.06
9	DUR368	2016-11-09	¤ 1,814.97
10	GRE364	2016-10-11	¤ 2,210.00
11	GSE420	2016-10-11	¤ 6,000.52
12	HAL348	2016-10-11	¤ 996.58
13	KER425	2016-11-09	¤ 565.90
14	MCH439	2016-11-09	¤ 3,325.95
15	SAN481	2016-10-11	¤ 1,516.24
16	STA374	2013-10-11	¤ 13,555.00
17	STE472	2016-11-09	¤ 5,685.14
18	STR449	2016-10-11	¤ 2,847.80

InvoiceID	PaymentID	PaymentAmt
1	1	¤ 3,550.00
1	21	¤ 3,550.00
1	23	¤ 564.00
2	2	¤ 200.00
3	3	¤ 700.00
4	4	¤ 300.00
4	5	¤ 700.00
6	6	¤ 2,940.00
6	19	¤ 2,000.81
6	20	¤ 123.99
7	7	¤ 1,528.15
7	8	¤ 3,000.00
8	8	¤ 920.00
9	10	¤ 1,417.00
10	9	¤ 1,487.00
10	10	¤ 723.00
11	11	¤ 4,168.00
11	17	¤ 1,832.52
12	12	¤ 930.00
13	13	¤ 565.90
14	14	¤ 2,409.76
15	14	¤ 367.24
15	15	¤ 1,149.00
16	16	¤ 6,885.27
17	17	¤ 3,395.48
18	18	¤ 946.94

PaymentID	PaymentDate	PaymentAmt
1	2013-10-26	¤ 3,550.00
2	2013-10-26	¤ 200.00
3	2013-11-22	¤ 700.00
4	2013-11-22	¤ 300.00
5	2013-10-26	¤ 700.00
6	2013-10-26	¤ 2,940.00
7	2013-10-26	¤ 1,528.15
8	2013-11-22	¤ 3,920.00
9	2013-11-22	¤ 1,487.00
10	2013-10-26	¤ 2,140.00
11	2013-10-26	¤ 4,168.00
12	2013-10-26	¤ 930.00
13	2013-11-22	¤ 565.90
14	2013-11-22	¤ 2,777.00
15	2013-10-26	¤ 1,149.00
16	2013-10-26	¤ 6,885.27
17	2013-11-22	¤ 5,228.00
18	2013-10-26	¤ 946.94
19	2013-11-22	¤ 2,000.81
20	2013-12-10	¤ 123.99
21	2013-11-22	¤ 3,550.00
23	2013-12-10	¤ 564.00

Price	ProductID	ProductName	Weight	Units	TempControlled	Sterile	SupplierID
¤ 25.50	AI569	Ammonia inhalants (smelling salts)	3.0	100	false	false	COU392
¤ 15.00	AL487	Alcohol wipes	12.0	1000	true	true	COU392
¤ 5,000.00	AU490	Autoclave	85.0		false	false	MCH439
¤ 3.50	BA130	Bandages, 1x3 adhesive strips	5.0	100	false	true	COU392
¤ 70.00	BB211	Butterfly blood collection needle set - 21g	7.0	50	false	true	DUR368
¤ 70.00	BB231	Butterfly blood collection needle set - 23g	8.0	50	false	true	DUR368
¤ 70.00	BB251	Butterfly blood collection needle set - 25g	9.0	50	false	true	DUR368
¤ 250.00	BC021	Blood collection needle - 21g x 1"	10.0	100	false	true	GRE364
¤ 250.00	BC023	Blood collection needle - 23g x 1"	12.0	100	false	true	GRE364
¤ 250.00	BC025	Blood collection needle - 25g x 1"	14.0	100	false	true	GRE364
¤ 250.00	BC212	Blood collection needle - 21g x 1.25"	11.0	100	false	true	GRE364
¤ 250.00	BC232	Blood collection needle - 23g x 1.25"	13.0	100	false	true	GRE364
¤ 250.00	BC252	Blood collection needle - 25g x 1.25"	15.0	100	false	true	GRE364
¤ 10.00	BH001	Blood collection needle tube holder	5.0	250	false	false	DUR368
¤ 40.00	BH002	Blood collection needle tube holder - bulk	20.0	1000	false	false	DUR368
¤ 365.00	BI250	Biological waste processing - per ton			false	false	CAR446
¤ 6.25	BL293	Blankets	12.0	6	false	false	KER425
¤ 3.95	CB392	Cotton balls	4.0	1000	false	true	SAN481
¤ 300.00	CB469	Citrate blood collection tube, 4 ml draw, blue top	25.0	500	true	false	GSE420
¤ 450.00	CB623	Citrate blood collection tube, 6 ml draw, blue top	26.0	500	true	false	GSE420
¤ 5,000.00	CE573	Centrifuge	50.0		false	false	MCH439
¤ 10.00	CO398	Cover slips	0.5	100	false	false	SAN481
¤ 2.50	DG409	Dressing gowns	15.0	25	false	false	HAL348
¤ 5.50	EG397	Non-Latex exam gloves	2.0	100	false	false	COU392
¤ 4,000.00	EK597	EKG machine	45.0		false	false	MCH439
¤ 85.00	GA404	Gauze pads, 4x4"	13.0	1200	false	true	COU392
¤ 70.00	GA413	Gauze rolls, 4x131"	12.0	72	false	true	COU392
¤ 300.00	HE439	Heparin blood collection tube, 4 ml draw, green top	25.0	500	true	false	GSE420
¤ 450.00	HE620	Heparin blood collection tube, 6 ml draw, green top	26.0	500	true	false	GSE420
¤ 79.00	HP420	H.Pylori Quick Test	0.25	1	true	false	CAN374
¤ 280.00	HY853	Cryogenic sample storage - monthly			false	false	CRO403
¤ 875.00	IN107	Insulin - 10 ml vial	4.0	10	true	true	STR449
¤ 150.00	IS281	Insulin syringe, 28g x 1cc	18.0	100	false	true	KER425
¤ 14.98	LC490	Lab coats	1.0	1	false	false	STR449
¤ 575.00	LS893	Linen service - monthly			false	false	STE472
¤ 3,000.00	MI497	Microscope	15.0		false	false	MCH439
¤ 45.00	MO269	Mononucleosis test	0.25	1	true	false	CAN374
¤ 25.00	PE329	Pediatric tube holder	2.0	50	false	false	ARE318
¤ 2.50	PG530	Pregnancy hGc cassette test	0.25	1	true	false	CAN374
¤ 85.00	PI370	Pipettes, 3ml	2.0	500	false	false	SAN481
¤ 3.00	PL875	Pillows	1.0	1	false	false	KER425
¤ 10.00	PT101	Paper tape roll, 1"	2.0	6	false	false	COU392
¤ 250.00	SB438	Serum blood collection tube, 4 ml draw, red top	25.0	500	true	false	GSE420
¤ 300.00	SB693	Serum blood collection tube, 6 ml draw, red top	26.0	500	true	false	GSE420
¤ 1.75	SD730	Surgical drapes	30.0	50	false	false	HAL348
¤ 8.50	SL283	Slides	0.5	72	false	false	SAN481
¤ 2.98	SM589	Surgical masks	8.0	100	false	false	HAL348
¤ 40.00	SP101	Sharps container - 1 qt	23.0	20	false	false	BAR297
¤ 20.00	SP103	Sharps container - 3 gallon	2.0	1	false	false	BAR297
¤ 65.00	SS582	Stethoscopes	1.0	1	false	false	DUR368
¤ 4.00	SU395	Suture removal kit	0.5	1	false	false	HAL348
¤ 24.00	SU593	Sutures, plain gut, w/needle	1.0	12	false	true	HAL348
¤ 7.50	SW493	Swabs	3.0	100	false	true	SAN481
¤ 10.50	TD583	Tongue depressors	7.0	1000	false	false	CAN374
¤ 55.00	TD947	Disposable thermometer covers	5.0	100	false	true	MCH439
¤ 98.00	TH930	Digital thermometer	1.0	1	true	false	MCH439
¤ 75.00	TQOO3	Tourniquet, latex free	5.0	500	false	false	COU392
¤ 1,800.00	UC834	Ultrasonic cleaner	12.0		false	false	MCH439
¤ 50.00	UR270	Urine collection cup	15.0	200	false	false	BAR297
¤ 470.00	UT496	Urine test strips	3.0	1000	true	true	BAN299
¤ 6,000.00	VS192	Vital signs monitor	68.0		false	false	MCH439
¤ 12,000.00	XR580	Xray machine (Radiograph)	150.0		false	false	ARM321
¤ 80.00	XR589	Xray film	15.0	100	true	false	ARM321
¤ 3,000.00	XR595	Radiograph processor	135.0		false	false	ARM321
¤ 253.50	PN284	Penicillin injections	4.0	25	true	true	STR449
¤ 108.60	ND562	Nitroglycerin in 5% Dextrose injections	12.0	10	true	true	STR449
¤ 598.00	AD989	Advair diskus	10.0	10	true	true	CAN374
¤ 85.00	XR590	Xray film	15.0	100	true	false	BAR297
¤ 11.50	TD584	Tongue depressors	7.0	1000	false	false	HAL348
¤ 7.50	SW495	Swabs	3.0	100	false	true	HAL348
¤ 8.00	SL285	Slides	0.5	72	false	false	HAL348

SupplierID	SupplierName	Category	Address	City	State	Zip	ContactPhone	ContactFirstName	ContactLastName	InitialContact	CompanyComments
MCH439	McHugh Electronics, LLC	Equipment	438 Kimmell Ave	Arlington	MA	02474	781.153.2742	Jill	Cumberly	2015-10-21
COU392	Courant Medical Supplies, Inc.	Supplies	27 Demoy Rd	Dayton	OH	45406	937.250.4958	Robert	Houston	2016-01-07
GSE420	GSE Medical, Inc.	Equipment	583 Renovo Dr	Claremont	NH	03743	603.202.4951	John	Vereen	2015-09-10
ARE318	Area Northeast Medical Supplies, Inc.	Supplies	48 Vienna St	Bridgeport	CT	06601	2037743048	Student First	Student Last	2015-09-02	Student City, Student State
BAR297	Barclay & Song, LLC	Supplies	657 Ackley Rd	Stamford	CT	06912	203.618.4903	Felice	Boutros	2015-09-21
CAN374	Cantu Medical Distributors, Inc.	Supplies	4906 Carlyle Ave	Tarrytown	NY	10591	914.624.4397	Amy	Price	2015-10-07
KER425	Kershaw Medical, Inc.	Equipment	839 Hudson Dr	Leesburg	FL	34749	352.187.6937	William	Revell	2015-09-09
DUR368	Durasurg Equipment, Inc.	Equipment	74 Jessie St	Roanoke	VA	24036	540.340.3829	Kevin	Taylor	2015-12-01
STR449	Strasbourg & Kenley, Inc.	Supplies	309 Petrie St	Raleigh	NC	27619	919.204.4879	D'arcy	Van Dermeer	2015-10-01
BAN299	Bantam BioMed, LLC	Supplies	92 Kinsman Pl	Madison	CT	06443	203.282.3984	Lee	Chan	2015-10-05
HAL348	Halaxion Surgical Supplies, Inc.	Supplies	837 Mueller Ct	Waukegan	IL	60085	847.311.1472	Esteban	Corredos	2015-10-26
GRE364	Greinke Labs, Inc.	Supplies	451 Summit Dr	Tiverton	RI	02878	401.208.9843	Evan	Brighton	2016-01-12
STE472	Steril Labs of CT, Inc.	Service	938 Gormley Ave	North Branford	CT	06517	203.537.5940	Carmine	San Marcos	2015-11-03
CAR446	Carley Medical Waste Processors, LLC	Service	40 Blaine Rd	Tolland	CT	06084	860.426.7493	Sanjee	Mehra	2015-11-16
SAN481	Sanomar Surgical, Inc.	Supplies	2 Steeplechase Ct	Parkton	MD	21120	410.445.6289	Barbara	Quinn	2015-12-10
ARM321	Armourtek Radiological Supplies, Inc.	Supplies	54 Lang Rd	Edison	NJ	08820	732.760.7829	Jean Paul	Fournier	2015-12-08
CRO403	Crowley Cryo-Service, Inc.	Service	745 Trembley Pl	Holyoke	MA	01040	413.255.2375	Juan	Reyes	2015-12-28
STA374	Standale Medical Distributors, Inc.	Supplies	4910 Carlyle Ave	Tarrytown	NY	10591	914.624.8943	Roger	Kenilworth	2015-11-08

SupplierID	CreditLine	CreditLineDate
STA374	¤ 5,000.00	2016-08-14
COU392	¤ 3,200.00	2017-02-14
GSE420	¤ 4,500.00	2017-07-09
CAR446	¤ 2,750.00	2016-10-01
ARE318	¤ 1,500.00	2016-05-15
MCH439	¤ 2,875.00	2016-11-14
STE472	¤ 1,500.00	2017-03-28

SupplierID	Payables	Paid	Owed	ID
ARE318	12781.16	12191.09	590.07	1
ARM321	2219.49	1857.34	362.15	2
BAN299	11341.78	9107.56	2234.22	3
BAR297	7930.63	7930.63	0.0	4
CAN374	12090.58	8450.84	3639.74	5
CAR446	17043.44	15908.31	1135.13	6
COU392	16394.66	15672.94	721.72	7
CRO403	3423.0	2787.99	635.01	8
DUR368	12128.6	10989.21	1139.39	9
GRE364	5803.43	5179.67	623.76	10
GSE420	14241.89	13003.66	1238.23	11
HAL348	13234.91	11753.0	1481.91	12
KER425	8878.4	7841.92	1036.48	13
MCH439	6109.79	6109.79	0.0	14
SAN481	12128.04	9567.21	2560.83	15
STA374	23154.94	20909.62	2245.32	16
STE472	3845.5	3655.95	189.55	17
STR449	2847.8	2847.8	0.0	18

PaymentID	CompanyID	PaymentDate	PaymentAmt
1	ARE318	2016-10-11T00:00:00	8345.98
2	ARM321	2016-10-11T00:00:00	475
3	BAN299	2016-11-09T00:00:00	956.3
4	BAR297	2016-11-09T00:00:00	1051.45
5	CAN374	2016-10-11T00:00:00	848.84
6	CAR446	2016-10-11T00:00:00	5237.58
7	COU392	2016-10-11T00:00:00	5657.81
8	CRO403	2016-11-09T00:00:00	4090.06
9	DUR368	2016-11-09T00:00:00	1814.97
10	GRE364	2016-10-11T00:00:00	2210
11	GSE420	2016-10-11T00:00:00	6000.52
12	HAL348	2016-10-11T00:00:00	996.58
13	KER425	2016-11-09T00:00:00	565.9
14	MCH439	2016-11-09T00:00:00	3325.95
15	SAN481	2016-10-11T00:00:00	1516.24
16	STA374	2016-10-11T00:00:00	13555
17	STE472	2016-11-09T00:00:00	5685.14
18	STR449	2016-10-11T00:00:00	2847.8

SELECT tblSupplier.SupplierID, tblSupplier.CompanyName, tblSupplier.Category, tblSupplier.Address, tblSupplier.City, tblSupplier.State, tblSupplier.Zip, tblSupplier.ContactPhone, tblSupplier.ContactFirstName, tblSupplier.ContactLastName, tblSupplier.InitialContact FROM tblSupplier WHERE (((tblSupplier.City) Like "T*")) ORDER BY tblSupplier.CompanyName;

SELECT tblSupplier.SupplierID, tblSupplier.Company, tblSupplier.Category, tblSupplier.Address, tblSupplier.City, tblSupplier.State, tblSupplier.Zip, tblSupplier.ContactPhone, tblSupplier.ContactFirstName, tblSupplier.ContactLastName, tblSupplier.InitialContact FROM tblSupplier WHERE (((tblSupplier.City) Not In ("Dayton","Madison","Edison"))) ORDER BY tblSupplier.Company;

SELECT tblSupplier.SupplierID, tblSupplier.CompanyName, tblSupplier.Category, tblSupplier.Address, tblSupplier.City, tblSupplier.State, tblSupplier.Zip, tblSupplier.ContactPhone, tblSupplier.ContactFirstName, tblSupplier.ContactLastName, tblSupplier.InitialContact FROM tblSupplier WHERE (((tblSupplier.State) In ("CT","NJ","NY"))) ORDER BY tblSupplier.CompanyName DESC;

SELECT tblSupplier.CompanyName, tblSupplier.City, tblSupplier.ContactPhone, [tblSupplier]![ContactFirstName] & " " & [tblSupplier]![ContactLastName] AS ContactName FROM tblSupplier ORDER BY tblSupplier.CompanyName;

SELECT tblSupplier.CompanyName, tblSupplier.Category, tblSupplier.City, tblSupplier.State, tblSupplier.ContactFirstName, tblSupplier.ContactLastName, tblSupplier.ContactPhone FROM tblSupplier WHERE (((tblSupplier.State)=[Type the State:]));

SELECT tblProduct.ProductName, tblProduct.ProductID, tblProduct.SupplierID, tblProduct.Price, tblProduct.Units FROM tblProduct WHERE (((tblProduct.ProductName) In (SELECT [ProductName] FROM [tblProduct] As Tmp GROUP BY [ProductName] HAVING Count(*)>1 ))) ORDER BY tblProduct.ProductName;

SELECT tblSupplier.SupplierID, tblSupplier.CompanyName, tblSupplier.City, tblSupplier.State, tblSupplier.ContactPhone, tblSupplier.ContactFirstName, tblSupplier.ContactLastName FROM tblSupplier LEFT JOIN tblProduct ON tblSupplier.[SupplierID] = tblProduct.[SupplierID] WHERE (((tblProduct.SupplierID) Is Null));

SELECT TOP 25 PERCENT tblProduct.ProductID, tblProduct.SupplierID, tblProduct.ProductName, tblProduct.Price FROM tblProduct ORDER BY tblProduct.Price DESC;

SELECT tblSupplier.SupplierName, tblSupplier.Category, tblProduct.ProductName, tblProduct.Price, tblProduct.Units FROM tblSupplier INNER JOIN tblProduct ON tblSupplier.SupplierID = tblProduct.SupplierID;

SELECT DISTINCTROW * FROM tblSupplier;

PARAMETERS __SupplierID Text; SELECT DISTINCTROW * FROM tblProduct AS frmSupplier WHERE ([__SupplierID] = SupplierID);

SELECT [tblSupplier].[SupplierID], tblSupplier.[SupplierName] FROM tblSupplier;

PARAMETERS __SupplierID Value; SELECT DISTINCTROW * FROM tblProduct AS frmSuppliersWithProducts WHERE ([__SupplierID] = SupplierID);

SELECT DISTINCTROW * FROM tblSupplier;

SELECT tblSupplier.[SupplierName], [tblSupplier].[SupplierID] FROM tblSupplier ORDER BY [SupplierID];

SELECT DISTINCTROW * FROM tblProduct;

Access Assignment/Data files for assignment/Tutorial/Health.accdb

InvoiceNum	VisitID	InvoiceDate	InvoiceAmt	InvoiceItem	InvoicePaid
34995	1640	2016-03-10	¤ 100.00	Office visit	false
35801	1527	2015-11-10	¤ 100.00	Office visit	true
35802	1528	2015-11-10	¤ 100.00	Office visit	true
35803	1528	2015-11-10	¤ 45.00	Phlebotomy	true
35804	1528	2015-11-13	¤ 238.00	Lab work - glycated hemoglobin (A1C)	true
35805	1528	2015-11-13	¤ 48.00	Lab work - urine glucose	true
35808	1530	2015-11-12	¤ 100.00	Office visit	true
35809	1530	2015-11-12	¤ 85.00	Pharmacy	true
35810	1530	2015-11-12	¤ 65.00	Pharmacy	true
35811	1530	2015-11-13	¤ 48.00	Lab - culture	true
35813	1535	2015-11-13	¤ 100.00	Office visit	true
35814	1535	2015-11-13	¤ 45.00	Pharmacy	true
35815	1535	2015-11-16	¤ 300.00	Cast of fracture	true
35816	1535	2015-11-16	¤ 250.00	Radiograph	false
35818	1536	2015-11-18	¤ 100.00	Office visit	true
35819	1536	2015-11-18	¤ 65.00	Pharmacy	true
35821	1538	2015-11-18	¤ 100.00	Office visit	true
35822	1538	2015-11-18	¤ 125.00	Pharmacy	false
35825	1539	2015-11-19	¤ 100.00	Office visit	true
35826	1539	2015-11-19	¤ 58.00	Influenza vaccine	true
35827	1539	2015-11-19	¤ 45.00	Phlebotomy	true
35828	1539	2015-11-20	¤ 125.00	Lab work	true
35830	1541	2015-11-25	¤ 100.00	Office visit	true
35831	1541	2015-11-25	¤ 65.00	Pharmacy	true
35833	1542	2015-11-25	¤ 100.00	Office visit	true
35834	1542	2015-11-25	¤ 85.00	Pharmacy	true
35835	1542	2015-11-30	¤ 250.00	Radiograph	true
35838	1544	2015-11-30	¤ 100.00	Office visit	true
35839	1544	2015-11-30	¤ 85.00	Pharmacy	true
35840	1544	2015-11-30	¤ 48.00	IM injection	true
35844	1548	2015-12-01	¤ 100.00	Office visit	false
35847	1549	2015-12-01	¤ 100.00	Office visit	true
35848	1549	2015-12-01	¤ 85.00	Pharmacy	true
35850	1550	2015-12-02	¤ 100.00	Office visit	true
35851	1550	2015-12-02	¤ 85.00	Pharmacy	false
35852	1550	2015-12-04	¤ 250.00	Radiograph	false
35854	1552	2015-12-04	¤ 100.00	Office visit	true
35857	1555	2015-12-08	¤ 100.00	Office visit	false
35858	1555	2015-12-08	¤ 72.00	Pharmacy	false
35860	1557	2015-12-11	¤ 100.00	Office visit	true
35861	1557	2015-12-11	¤ 85.00	Pharmacy	true
35862	1557	2015-12-11	¤ 45.00	Phlebotomy	false
35863	1557	2015-12-14	¤ 32.00	Lab work	false
35865	1560	2015-12-16	¤ 100.00	Office visit	true
35866	1560	2015-12-16	¤ 85.00	Pharmacy	true
35868	1562	2015-12-23	¤ 100.00	Office visit	false
35869	1562	2015-12-28	¤ 150.00	Respiratory therapy	false
35872	1563	2016-01-05	¤ 100.00	Office visit	true
35873	1563	2016-01-05	¤ 75.00	Cast removal	false
35875	1564	2016-01-06	¤ 100.00	Office visit	true
35876	1564	2016-01-06	¤ 85.00	Pharmacy	true
35879	1567	2016-01-11	¤ 100.00	Office visit	true
35880	1569	2016-01-12	¤ 100.00	Office visit	true
35881	1569	2016-01-15	¤ 150.00	Respiratory therapy	true
35884	1570	2016-01-12	¤ 100.00	Office visit	true
35885	1570	2016-01-12	¤ 85.00	Pharmacy	false
35886	1570	2016-01-12	¤ 45.00	Phlebotomy	false
35887	1570	2016-01-13	¤ 68.00	Pharmacy	false
35888	1570	2016-01-13	¤ 125.00	Lab work	false
35889	1572	2016-01-14	¤ 100.00	Office visit	true
35890	1572	2016-01-14	¤ 85.00	Pharmacy	true
35893	1573	2016-01-14	¤ 100.00	Office visit	true
35894	1573	2016-01-19	¤ 75.00	EKG with interpretation	true
35897	1575	2016-01-14	¤ 100.00	Office visit	true
35898	1575	2016-01-14	¤ 45.00	Pharmacy	true
35899	1575	2016-01-19	¤ 250.00	Radiograph	false
35900	1575	2016-01-20	¤ 300.00	Bone setting and cast	false
35905	1576	2016-01-15	¤ 100.00	Office visit	false
35907	1580	2016-01-19	¤ 100.00	Office visit	true
35908	1580	2016-01-19	¤ 85.00	Pharmacy	true
35909	1580	2016-01-20	¤ 68.00	Pharmacy	false
35912	1583	2016-01-25	¤ 100.00	Office visit	true
35913	1583	2016-01-25	¤ 85.00	Pharmacy	true
35915	1585	2016-01-26	¤ 100.00	Office visit	false
35916	1585	2016-01-26	¤ 85.00	Pharmacy	false
35917	1585	2016-01-28	¤ 125.00	Lab work - culture	false
35920	1586	2016-01-26	¤ 100.00	Office visit	false
35923	1588	2016-01-26	¤ 100.00	Office visit	true
35925	1590	2016-01-27	¤ 100.00	Office visit	true
35926	1590	2016-01-27	¤ 85.00	Pharmacy	false
35927	1590	2016-01-28	¤ 65.00	Pharmacy	false
35929	1591	2016-01-27	¤ 100.00	Office visit	true
35930	1591	2016-01-27	¤ 85.00	Pharmacy	true
35931	1591	2016-01-28	¤ 125.00	Lab work - culture	true
35933	1594	2016-01-29	¤ 100.00	Office visit	true
35934	1594	2016-01-29	¤ 45.00	Phlebotomy	true
35935	1594	2016-01-29	¤ 65.00	Pharmacy	true
35936	1594	2016-02-01	¤ 125.00	Lab work - culture	true
35939	1597	2016-02-02	¤ 100.00	Office visit	true
35940	1597	2016-02-02	¤ 85.00	Pharmacy	true
35942	1598	2016-02-02	¤ 100.00	Office visit	true
35943	1598	2016-02-04	¤ 250.00	Physical therapy	true
35945	1601	2016-02-03	¤ 100.00	Office visit	true
35946	1601	2016-02-03	¤ 85.00	Pharmacy	false
35947	1601	2016-02-04	¤ 250.00	Physical therapy	false
35949	1605	2016-02-09	¤ 100.00	Office visit	true
35951	1606	2016-02-09	¤ 100.00	Office visit	false
35952	1606	2016-02-09	¤ 75.00	Pharmacy	false
35953	1607	2016-02-10	¤ 100.00	Office visit	true
35954	1607	2016-02-10	¤ 45.00	Phlebotomy	false
35955	1607	2016-02-10	¤ 48.00	Lab - serum glucose	true
35957	1608	2016-02-10	¤ 100.00	Office visit	false
35958	1608	2016-02-10	¤ 67.00	Pharmacy	false
35959	1608	2016-02-12	¤ 85.00	Lab work - culture	false
35960	1610	2016-02-10	¤ 100.00	Office visit	true
35962	1613	2016-02-12	¤ 100.00	Office visit	true
35963	1615	2016-02-16	¤ 100.00	Office visit	false
35965	1618	2016-02-17	¤ 100.00	Office visit	true
35968	1621	2016-02-19	¤ 100.00	Office visit	true
35969	1621	2016-02-19	¤ 125.00	Pharmacy	true
35970	1623	2016-02-23	¤ 100.00	Office visit	true
35971	1625	2016-02-25	¤ 100.00	Office visit	true
35972	1625	2016-02-25	¤ 45.00	Phlebotomy	true
35973	1625	2016-02-25	¤ 63.00	Pharmacy	true
35974	1625	2016-02-26	¤ 45.00	Pharmacy	true
35975	1625	2016-02-26	¤ 125.00	Lab work	false
35977	1628	2016-02-26	¤ 100.00	Office visit	true
35979	1626	2016-02-26	¤ 75.00	Cast removal	false
35980	1630	2016-03-02	¤ 100.00	Office visit	false
35982	1631	2016-03-02	¤ 100.00	Office visit	false
35983	1631	2016-03-02	¤ 45.00	Phlebotomy	false
35984	1631	2016-03-02	¤ 68.00	Pharmacy	false
35985	1631	2016-03-03	¤ 125.00	Lab work	false
35986	1634	2016-03-04	¤ 100.00	Office visit	true
35987	1634	2016-03-04	¤ 58.00	IM injection	true
35989	1635	2016-03-04	¤ 100.00	Office visit	true
35990	1635	2016-03-07	¤ 150.00	Respiratory therapy	true
35992	1638	2016-03-08	¤ 100.00	Office visit	true
35993	1638	2016-03-08	¤ 85.00	Pharmacy	true
35996	1642	2016-03-10	¤ 100.00	Office visit	true
35997	1642	2016-03-10	¤ 85.00	Pharmacy	true
35998	1642	2016-03-10	¤ 45.00	Phlebotomy	true
35999	1642	2016-03-11	¤ 85.00	Lab work	false
36000	1642	2016-03-11	¤ 250.00	Radiograph	false
36002	1642	2016-03-15	¤ 450.00	Surgery	false
36003	1644	2016-03-14	¤ 100.00	Office visit	true
36004	1644	2016-03-14	¤ 85.00	Pharmacy	true
36006	1645	2016-03-15	¤ 100.00	Office visit	true
36007	1645	2016-03-15	¤ 45.00	Phlebotomy	false
36008	1645	2016-03-15	¤ 67.00	Pharmacy	false
36009	1645	2016-03-16	¤ 85.00	Lab work - culture	false
36011	1647	2016-03-21	¤ 100.00	Office visit	true
36012	1648	2016-03-21	¤ 100.00	Office visit	true
36013	1648	2016-03-21	¤ 125.00	Pharmacy	true
36015	1650	2016-03-22	¤ 100.00	Office visit	true
36016	1650	2016-03-22	¤ 65.00	Pharmacy	true
36017	1650	2016-03-23	¤ 77.00	Pharmacy	true
36020	1652	2016-03-24	¤ 100.00	Office visit	true
36021	1652	2016-03-24	¤ 59.00	Pharmacy	true
36023	1653	2016-03-24	¤ 100.00	Office visit	true
36024	1653	2016-03-24	¤ 45.00	Phlebotomy	true
36025	1653	2016-03-24	¤ 85.00	Pharmacy	true
36026	1653	2016-03-25	¤ 125.00	Lab work	false
36037	1659	2016-03-29	¤ 100.00	Office visit	false
36038	1659	2016-03-29	¤ 85.00	Pharmacy	false
36040	1662	2016-03-31	¤ 100.00	Office visit	true
36041	1662	2016-03-31	¤ 85.00	Pharmacy	false
36042	1662	2016-04-01	¤ 65.00	Pharmacy	false
36043	1662	2016-04-01	¤ 30.00	Pharmacy	false
36045	1663	2016-04-04	¤ 100.00	Office visit	true
36046	1663	2016-04-04	¤ 75.00	Pharmacy	true
36048	1665	2016-04-04	¤ 100.00	Office visit	false
36049	1665	2016-04-04	¤ 85.00	Pharmacy	false
36050	1667	2016-04-04	¤ 100.00	Office visit	true
36051	1667	2016-04-04	¤ 85.00	Pharmacy	true
36053	1670	2016-04-05	¤ 100.00	Office visit	true
36054	1670	2016-04-05	¤ 85.00	Pharmacy	true
36055	1670	2016-04-05	¤ 45.00	Phlebotomy	true
36056	1670	2016-04-06	¤ 125.00	Lab work	false
36057	1670	2016-04-07	¤ 35.00	Pharmacy	false
36059	1672	2016-04-07	¤ 100.00	Office visit	true
36062	1673	2016-04-07	¤ 100.00	Office visit	false
36063	1673	2016-04-07	¤ 85.00	Pharmacy	false
36064	1673	2016-04-11	¤ 250.00	Radiograph	false
36065	1675	2016-04-08	¤ 100.00	Office visit	true
36066	1675	2016-04-08	¤ 45.00	Phlebotomy	false
36067	1675	2016-04-08	¤ 48.00	Lab - serum glucose	false
36069	1679	2016-04-11	¤ 100.00	Office visit	true
36070	1680	2016-04-11	¤ 100.00	Office visit	true
36071	1680	2016-04-11	¤ 85.00	Pharmacy	true
36072	1680	2016-04-11	¤ 45.00	Phlebotomy	false
36073	1680	2016-04-12	¤ 85.00	Lab work	false
36074	1680	2016-04-12	¤ 450.00	Surgery	false
36075	1682	2016-04-11	¤ 100.00	Office visit	true
36076	1682	2016-04-11	¤ 65.00	Pharmacy	true
36078	1683	2016-04-11	¤ 100.00	Office visit	true
36080	1685	2016-04-12	¤ 100.00	Office visit	true
36081	1685	2016-04-12	¤ 85.00	Pharmacy	true
36083	1687	2016-04-13	¤ 100.00	Office visit	false
36084	1687	2016-04-13	¤ 75.00	Pharmacy	false
36085	1687	2016-04-14	¤ 250.00	Radiograph	false
36087	1688	2016-04-13	¤ 100.00	Office visit	false
36090	1690	2016-04-14	¤ 100.00	Office visit	false
36091	1690	2016-04-14	¤ 85.00	Pharmacy	false
36093	1692	2016-04-15	¤ 100.00	Office visit	true
36094	1692	2016-04-15	¤ 150.00	Respiratory therapy	true
36097	1695	2016-04-18	¤ 100.00	Office visit	true
36098	1695	2016-04-18	¤ 45.00	Phlebotomy	true
36099	1695	2016-04-18	¤ 68.00	Pharmacy	true
36100	1695	2016-04-19	¤ 125.00	Lab work	false
36102	1698	2016-04-18	¤ 100.00	Office visit	true
36103	1698	2016-04-19	¤ 125.00	Suture removal	true
36105	1700	2016-04-19	¤ 100.00	Office visit	false
36106	1700	2016-04-19	¤ 65.00	Pharmacy	false

PatientID	BillingFirstName	BillingLastName	BillingPhone	BillingAddress	BillingCity	BillingState	BillingZip	BillingEmailAddress
22512	Randy	Hawes	860-661-7193	26 Edwin Ct	Hartford	CT	06105	[email protected]
22526	Maria	Torres	860-938-2098	27 Reno Dr	Hartford	CT	06120	[email protected]
22529	Chung	Ho	860-552-5846	127 Tracey Ct	Windsor	CT	06095	[email protected]
22533	Victor	Park	860-552-0395	228 Aiken Ave	Windsor	CT	06095	[email protected]
22536	Sam	Lew	860-374-9342	129 Fairchild Ave	Hartford	CT	06114	[email protected]
22517	Mandy	Lin	860-637-5800	332 Agnes Ct	West Hartford	CT	06117	[email protected]
22518	Arthur	Scott	860-226-4992	317 Noyes Ct	Hartford	CT	06112	[email protected]
22504	Larissa	Waller	860-661-3098	7297 Dolor St	Hartford	CT	06105	[email protected]
22505	Maria	Marquez	860-938-1123	27 Frankfurt St	Hartford	CT	06120	[email protected]
22520	Betty	Gallagher	860-552-2987	127 Rain Ct	Windsor	CT	06095	[email protected]
22523	Jonathan	Holloway	860-552-2341	128 Charning Ave	Windsor	CT	06095	[email protected]
22509	Lapfong	Wong	860-374-2521	129 Devon Ave	Hartford	CT	06114	[email protected]

EmployeeID	FirstName	LastName	Position	SupervisorID
101	Laura	Parker	Registered Nurse	103
102	Tan	Xu	Occupational Therapist	103
103	Corinne	Jameson	Chief Medical Officer
104	Sandra	Parker	Physiotherapist	103
105	Joe	D'Angelo	Pharmacist	106
106	Benjamin	Cameron	Pharmacy Supervisor
107	Len	Girard	Nurse Practitioner	103
108	Kerry	Hartman	Pharmacist	106
112	Kathy	Chevalier	Site Manager	103
114	Susan	O'Sullivan	Staff Physician	103
115	Laura	Lang	Medical Technologist	103
116	Candice	Zettle	Pharmacist	106
117	Juan	Mendez	Nurse Practitioner	103
119	Erik	Stefansson	Registered Nurse	103

PatientID	LastName	FirstName	Parent	BirthDate	Phone	Address	City	State	Zip	EmailAddress	Insurance Type
22500	Student Last	Student First		1994-02-28	8609382822	501 Perkins Dr	Hartford	CT	06120	[email protected]
22501	Darcy	Edward		1986-07-15	8603053985	723 Oxford Ave	Bloomfield	CT	06002	[email protected]	Private
22502	Mendez	Andreas		1934-03-01	8605526893	57 Wallace Rd	Windsor	CT	06095	[email protected]	Medicare
22504	Aguilar	Lilian		1938-08-16	8603745724	329 Fairchild Ave	Hartford	CT	06114	[email protected]	Medicare
22505	Finnerty	Amber		1946-05-07	8602264930	37 Noyes Ct	Hartford	CT	06112	[email protected]
22506	Gorski	Drea	Samson, Mary	2005-02-19	8603058394	83 Everett Ln	Bloomfield	CT	06002
22507	Weiss	Matthew	Weiss, Jordan	1997-06-07	8604267492	38 German St	Hartford	CT	06106	[email protected]
22509	Kervin	Steve		1993-04-06	8609380025	49 Davenport St	Hartford	CT	06120	[email protected]
22510	Booker	Thomas		1966-08-25	2036612539	59 Nicola Ave	Meriden	CT	06450
22511	Castro	Daniel		1933-09-23	8606370430	61 Osmond Way	West Hartford	CT	06117	[email protected]	Medicare
22512	Chang	Lisa		1955-10-05	8602266034	731 Macon Rd	Hartford	CT	06112	[email protected]
22513	Smith	Troy		1996-01-31	8603050384	16 Ravine Rd	Bloomfield	CT	06002	[email protected]
22514	Parker	Ian		1958-06-03	8609381873	12 Adelbert St	Hartford	CT	06120	[email protected]	Medicaid
22516	King	Susan		1963-12-07	2036619347	48 Fenton St	Meriden	CT	06450	[email protected]
22517	O'Brien	Henry		1940-12-10	8606379203	58 Redmond Dr	West Hartford	CT	06117	[email protected]
22518	Torres	Sera	Torres, Gina	2008-04-09	8609382098	27 Reno Dr	Hartford	CT	06120	[email protected]
22519	Belanger	Malcolm		1950-10-17	8606373927	723 Nicola Ave	West Hartford	CT	06117
22520	Hallick	Davis		1944-03-26	8605524495	84 Churchill Pl	Windsor	CT	06095	[email protected]
22521	Engber	Cathy	Engber, Jim	2006-04-07	8603053048	58 Deering Pl	Bloomfield	CT	06002	[email protected]
22522	Li	Siyang		1986-07-25	8603056548	225 Krauss Rd	Bloomfield	CT	06002	[email protected]	Private
22523	Fraser	Nancy		1977-11-08	8605527392	7 Quinn Dr	Windsor	CT	06095
22525	Rodriguez	Maria		1936-02-11	4755529023	624 Noyes St	Waterbury	CT	06704	[email protected]	Medicare
22526	Swenson	Lucia		1943-05-01	8602260293	83 Osage Ave	Hartford	CT	06112		Private
22527	Lee	Hwan		1987-08-25	860661 3974	153 Agnes Ct	Hartford	CT	06105	[email protected]
22529	Goldberg	Robert		1961-05-30	8605522873	92 Gaston Ave	Windsor	CT	06095
22530	Brown	Olivia		1943-11-24	2039387482	649 Scovill Dr	Meriden	CT	06450	[email protected]
22531	Wallner	Jessica		1980-02-28	8603742987	74 Brayton Dr	Hartford	CT	06114	[email protected]
22533	Rowe	Christina		1941-12-05	8605525920	27 Tracey Ct	Windsor	CT	06095	[email protected]	Medicare
22534	Hawes	Susan		1945-06-22	8606617193	26 Edwin Ct	Hartford	CT	06105	[email protected]	Medicare
22535	Delgado	Alex		1960-07-16	8605521739	48 Warwick St	Windsor	CT	06095	[email protected]	Private
22536	Caputo	Michael		1998-10-19	8603749347	96 Vega Dr	Hartford	CT	06114		Private
22537	Mehta	Amrita		1989-06-03	8605520375	28 Aiken Ave	Windsor	CT	06095	[email protected]	Medicaid
22539	Ramos	Felipe		1972-03-18	8604261987	64 Logan Ct	Hartford	CT	06106
22540	Taylor	Jerome		1992-09-06	8602262037	598 Belleflower Ave	Hartford	CT	06112	[email protected]
22541	Billings	Claire		1990-11-16	8606612053	786 Kidder Rd	Hartford	CT	06105
22542	Diaz	Anna		1987-09-25	8606379430	93 Gates Ln	West Hartford	CT	06117	[email protected]
22543	Boucher	Sam		1975-03-11	8602265920	92 Bunnell Pl	Hartford	CT	06112	[email protected]
22544	Sutherland	Max		1969-01-26	8605523087	48 Vine St	Windsor	CT	06095	[email protected]
22546	Ingram	Julia		1939-08-04	8606614937	834 Kiefer Rd	Hartford	CT	06105		Medicare
22547	Greene	Caroline		1954-06-12	8609388295	83 Turin Pl	Hartford	CT	06120
22549	Fielder	Pam		1978-12-06	8603052689	39 Unger Ave	Bloomfield	CT	06002	[email protected]
22550	Cruz	Magdalena		1984-07-24	8606374893	49 Kelton Dr	West Hartford	CT	06117
22551	Franklin	Chaney		1954-01-18	8605522409	62 Decker Rd	Windsor	CT	06095	[email protected]	Private
22552	Garrett	Ashley		1989-03-24	4755528429	372 Higbee Ct	Waterbury	CT	06704	[email protected]	Medicaid
22555	Phillips	Aquon		1971-05-23	8609382874	632 Perkins Dr	Hartford	CT	06120
22556	Grus	Mateo		1959-03-11	8602268472	18 Norman Rd	Hartford	CT	06112	[email protected]
22557	Kirk	Isobel		1965-11-18	8603057384	48 Grafton St	Bloomfield	CT	06002		Private
22558	Ropiak	Jane		1950-02-07	8609387830	637 Filbert St	Hartford	CT	06120	[email protected]
22559	Morales	Jose		1965-12-25	8606372015	251 Lilac St	West Hartford	CT	06117
22560	Lewis	Patrice		1991-07-15	8605525830	15 Prince Rd	Windsor	CT	06095	[email protected]
22561	Shaw	Daniel		1990-08-23	8606375894	33 Agnes Ct	West Hartford	CT	06117	[email protected]	Medicaid

InvoiceNum	EmployeeID
34995	107
35801	107
35802	119
35803	107
35804	115
35805	115
35808	119
35809	105
35810	108
35811	115
35813	119
35814	116
35815	104
35815	117
35816	115
35818	119
35819	105
35821	119
35822	108
35825	119
35826	119
35827	114
35828	115
35830	119
35831	116
35833	107
35834	105
35835	115
35838	117
35839	108
35840	107
35844	107
35847	107
35848	116
35850	107
35851	105
35852	115
35854	107
35857	107
35858	108
35860	117
35861	116
35862	117
35863	115
35865	107
35866	105
35868	114
35869	107
35869	102
35872	114
35873	102
35873	117
35875	114
35876	108
35879	114
35880	114
35881	107
35881	102
35884	114
35885	116
35886	107
35887	105
35888	115
35889	114
35890	108
35893	107
35894	114
35894	115
35897	114
35898	116
35899	115
35900	102
35900	117
35905	107
35907	114
35908	105
35909	108
35912	114
35913	116
35915	107
35916	105
35917	101
35920	114
35923	107
35925	107
35926	108
35927	116
35929	114
35930	105
35931	115
35933	114
35934	114
35935	108
35936	101
35939	115
35940	116
35942	115
35943	104
35945	115
35946	105
35947	104
35949	115
35951	117
35952	108
35953	117
35954	117
35955	115
35957	117
35958	116
35959	115
35960	119
35962	119
35963	119
35965	119
35968	117
35969	105
35970	119
35971	119
35972	107
35973	108
35974	116
35975	115
35977	107
35979	104
35979	107
35980	107
35982	119
35983	114
35984	105
35985	101
35986	114
35987	119
35989	114
35990	107
35990	102
35992	107
35993	108
35996	107
35997	116
35998	117
35999	101
36000	115
36002	112
36002	114
36003	107
36004	105
36006	101
36007	107
36008	108
36009	101
36011	101
36012	101
36013	116
36015	101
36016	105
36017	108
36020	107
36021	116
36023	114
36024	114
36025	105
36026	101
36037	117
36038	108
36040	119
36041	116
36042	105
36043	108
36045	101
36046	116
36048	107
36049	105
36050	114
36051	108
36053	117
36054	116
36055	117
36056	101
36057	105
36059	119
36062	101
36063	108
36064	115
36065	107
36066	107
36067	115
36069	114
36070	117
36071	116
36072	114
36073	115
36074	112
36074	114
36075	119
36076	105
36078	101
36080	107
36081	108
36083	114
36084	116
36085	115
36087	117
36090	119
36091	105
36093	101
36094	117
36094	102
36097	107
36098	117
36099	108
36100	115
36102	114
36103	112
36105	117
36106	116

VisitID	PatientID	VisitDate	Reason	WalkIn	Comments
1527	22521	2015-11-09	Allergies - environmental	true	sneezing
1528	22507	2015-11-09	Diabetes mellitis Type 2 - initial diagnosis	true
1530	22510	2015-11-10	Seborrheic dermatitis	false
1535	22546	2015-11-12	Transverse fracture of left ulna	true
1536	22526	2015-11-17	Gastroenteritis	false	occasional headaches
1538	22500	2015-11-17	Migraine	true
1539	22504	2015-11-18	Annual wellness visit	false
1541	22526	2015-11-24	Gastroenteritis - follow up	false
1542	22537	2015-11-24	Influenza	true
1544	22560	2015-11-25	Influenza	true
1548	22519	2015-11-30	Hypertension	false	recent death in family; family is going for counseling and may require further treatment
1549	22501	2015-11-30	Influenza	true
1550	22523	2015-12-01	Influenza	true
1552	22511	2015-12-03	Annual wellness visit	false	no concerns
1555	22520	2015-12-07	Annual wellness visit	false
1557	22526	2015-12-10	Annual wellness visit	false	some insomnia, some stress related to her job; she is asking for a referral for a counselor
1560	22514	2015-12-15	Influenza	true
1562	22516	2015-12-22	COPD management visit	false
1563	22546	2016-01-04	Follow-up - cast removal	false	recommend physio
1564	22512	2016-01-05	Annual wellness visit	false	no concerns
1567	22519	2016-01-08	Hypertension monitoring	false
1569	22558	2016-01-11	COPD management visit	false
1570	22561	2016-01-11	Nasopharyngitis	true
1572	22560	2016-01-13	Acute sinusitis	true
1573	22511	2016-01-13	Cardiac monitoring	false
1575	22513	2016-01-13	Broken leg	true
1576	22514	2016-01-14	Hypertension monitoring	false	difficulty sleeping
1580	22552	2016-01-15	Annual wellness visit	false
1583	22560	2016-01-22	Acute sinusitis follow-up	false
1585	22555	2016-01-25	Acute viral rhinopharyngitis	true
1586	22523	2016-01-25	Nasopharyngitis	true
1588	22535	2016-01-25	Hypertension	false
1590	22505	2016-01-26	Annual wellness visit	false	no concerns
1591	22544	2016-01-26	Acute viral rhinopharyngitis	true
1594	22533	2016-01-28	Nasopharyngitis	true
1597	22517	2016-02-01	Annual wellness visit	false
1598	22530	2016-02-01	Plantar fasciitis	true
1601	22542	2016-02-02	Brachial neuritis	true
1605	22535	2016-02-08	Hypertension monitoring	false
1606	22520	2016-02-08	Gastric reflux	true	difficulty sleeping
1607	22507	2016-02-09	Diabetes mellitis Type 2 - serum glucose check	false
1608	22527	2016-02-09	UTI	true
1610	22529	2016-02-09	Sinusitis	true
1613	22557	2016-02-11	Hypertension	true
1615	22539	2016-02-12	Annual wellness visit	false
1618	22530	2016-02-16	Plantar fasciitis follow-up	false
1621	22550	2016-02-18	Migraine headache	true
1623	22520	2016-02-22	Follow-up - gastric reflux	false
1625	22551	2016-02-24	Elevated blood lipids-monitoring meds	false
1626	22513	2016-02-24	Follow-up - cast removal	false
1628	22557	2016-02-25	Hypertension monitoring	false
1630	22547	2016-03-01	Annual wellness visit	false
1631	22510	2016-03-01	Seborrheic dermatitis follow-up	false
1634	22522	2016-03-03	Allergies - environmental follow-up	false	sneezing
1635	22558	2016-03-03	COPD management visit	false
1638	22560	2016-03-07	Eczema erythematosum	true
1640	22557	2016-03-09	Hypertension monitoring	false
1642	22540	2016-03-09	Onychocryptosis	true
1644	22533	2016-03-11	Annual wellness visit	false	no concerns
1645	22531	2016-03-14	UTI	true
1647	22535	2016-03-18	Hypertension monitoring	false
1648	22550	2016-03-18	Migraine headache follow-up	false
1650	22560	2016-03-21	Eczema erythematosum follow-up	false	insomnia
1652	22540	2016-03-23	Onychocryptosis follow-up	false
1653	22551	2016-03-23	Elevated blood lipids-monitoring meds	false
1659	22531	2016-03-28	UTI follow-up	false
1662	22502	2016-03-30	Annual wellness visit	false	no concerns
1663	22525	2016-04-01	Severe abrasion of left patella	true
1665	22518	2016-04-01	Conjunctivitis	true
1667	22506	2016-04-01	Fifth Disease	true
1670	22509	2016-04-04	Tinea pedis	true
1672	22525	2016-04-06	Wound care for patellar abrasion	false
1673	22549	2016-04-06	Pertussis	true
1675	22507	2016-04-07	Diabetes mellitis Type 2 - serum glucose check	false
1679	22557	2016-04-08	Hypertension monitoring	false
1680	22536	2016-04-08	Laceration of left eyelid -sutured	true	assault victim
1682	22518	2016-04-08	Conjunctivitis follow-up	false
1683	22506	2016-04-08	Fifth Disease follow-up	false
1685	22517	2016-04-11	Idiopathic abdominal pain	true
1687	22534	2016-04-12	Joint pain/arthritis	true	prefers no meds
1688	22529	2016-04-12	Annual wellness visit	false	no concerns
1690	22521	2016-04-13	Varicella	true
1692	22558	2016-04-14	COPD management visit	false
1695	22551	2016-04-15	Elevated blood lipids-monitoring meds	false
1698	22536	2016-04-15	Removal of sutures from left eyelid	false	sensitive to light
1700	22509	2016-04-18	Tinea pedis follow-up	false

EmployeeID	FirstName	LastName	Position	SupervisorID
101	Lynne	Perkins	Site manager	103
102	Timothy	Ering	Artist	106
103	Cynthia	Kadohata	Team leader
104	Linda	Park	Designer	103
105	Richard	Peck	Liaison	103
106	Christopher	Curtis	Team leader
107	Louis	Sacher	Planner	106
108	Karen	Hesse	Designer	106
112	Karen	Cushman	Site manager	106
114	Sharon	Creech	Artist	103
115	Lois	Lowry	Liaison	106
116	Cynthia	Rylant	Site manager	106
117	Jerry	Spinelli	Site manager	103
119	Paul	Fleischman	Planner	103

PatientID	LastName	FirstName	DOB	Phone	Address	City	State	Zip	Email
36108	Ali	Jaspreet	1996-02-12	8609382834	505 Perkins Dr	Hartford	CT	6120	[email protected]
36112	Alvarez	Maria	1991-07-10	8603053985	735 Oxford Ave	Bloomfield	CT	6002	[email protected]
36117	Sweeney	Patrick	1932-03-04	8605526832	5 Wallace Rd	Windsor	CT	6095	[email protected]
36119	Higgins	Jim	1942-08-16	8603745742	329 Fairchild Ave	Hartford	CT	6114	[email protected]
36120	Morales	Juan	1943-05-08	8602264954	33 Noyes Ct	Hartford	CT	6112	[email protected]
36125	Go	Bae	2001-02-21	8603055494	183 Everett Ln	Bloomfield	CT	6002	[email protected]
36128	Ma	Dae	1999-06-07	8604267653	138 German St	Hartford	CT	6106	[email protected]
36129	Zhang	Guang	1943-04-06	8609380142	29 Davenport St	Hartford	CT	6120	[email protected]

InvoiceNum	EmployeeID
35900	102
35900	117
35815	104
35815	117
35873	102
35873	117
35979	104
35979	107
35894	114
35894	115
35840	107
35987	119
35826	119
35811	115
35955	115
36067	115
35828	115
35863	115
35888	115
35975	115
35985	101
35999	101
36026	101
36056	101
36073	115
36100	115
35917	101
35931	115
35936	101
35959	115
36009	101
35804	115
35805	115
34995	107
35801	107
35802	119
35808	119
35813	119
35818	119
35821	119
35825	119
35830	119
35833	107
35838	117
35844	107
35847	107
35850	107
35854	107
35857	107
35860	117
35865	107
35868	114
35872	114
35875	114
35879	114
35880	114
35884	114
35889	114
35893	107
35897	114
35905	107
35907	114
35912	114
35915	107
35920	114
35923	107
35925	107
35929	114
35933	114
35939	115
35942	115
35945	115
35949	115
35951	117
35953	117
35957	117
35960	119
35962	119
35963	119
35965	119
35968	117
35970	119
35971	119
35977	107
35980	107
35982	119
35986	114
35989	114
35992	107
35996	107
36003	107
36006	101
36011	101
36012	101
36015	101
36020	107
36023	114
36037	117
36040	119
36045	101
36048	107
36050	114
36053	117
36059	119
36062	101
36065	107
36069	114
36070	117
36075	119
36078	101
36080	107
36083	114
36087	117
36090	119
36093	101
36097	107
36102	114
36105	117
35809	105
35810	108
35814	116
35819	105
35822	108
35831	116
35834	105
35839	108
35848	116
35851	105
35858	108
35861	116
35866	105
35876	108
35885	116
35887	105
35890	108
35898	116
35908	105
35909	108
35913	116
35916	105
35926	108
35927	116
35930	105
35935	108
35940	116
35946	105
35952	108
35958	116
35969	105
35973	108
35974	116
35984	105
35993	108
35997	116
36004	105
36008	108
36013	116
36016	105
36017	108
36021	116
36025	105
36038	108
36041	116
36042	105
36043	108
36046	116
36049	105
36051	108
36054	116
36057	105
36063	108
36071	116
36076	105
36081	108
36084	116
36091	105
36099	108
36106	116
35803	107
35827	114
35862	117
35886	107
35934	114
35954	117
35972	107
35983	114
35998	117
36007	107
36024	114
36055	117
36066	107
36072	114
36098	117
35943	104
35947	104
35816	115
35835	115
35852	115
35899	115
36000	115
36064	115
36085	115
35869	107
35869	102
35881	107
35881	102
35990	107
35990	102
36094	117
36094	102
36002	112
36002	114
36074	112
36074	114
36103	112

PatientID	FirstName	LastName	Phone	Address	City	State	Zip	Email

InvoiceNum	EmployeeID
35985	101
35999	101
36026	101
36056	101
35917	101
35936	101
36009	101
36006	101
36011	101
36012	101
36015	101
36045	101
36062	101
36078	101
36093	101
35869	102
35881	102
35990	102
36094	102
35943	104
35947	104
35809	105
35819	105
35834	105
35851	105
35866	105
35887	105
35908	105
35916	105
35930	105
35946	105
35969	105
35984	105
36004	105
36016	105
36025	105
36042	105
36049	105
36057	105
36076	105
36091	105
35979	107
35840	107
34995	107
35801	107
35833	107
35844	107
35847	107
35850	107
35854	107
35857	107
35865	107
35893	107
35905	107
35915	107
35923	107
35925	107
35977	107
35980	107
35996	107
36003	107
36020	107
36048	107
36065	107
36080	107
36097	107
35803	107
35886	107
35972	107
36007	107
36066	107
35810	108
35822	108
35839	108
35858	108
35876	108
35890	108
35909	108
35926	108
35935	108
35952	108
35973	108
35993	108
36008	108
36017	108
36038	108
36043	108
36051	108
36063	108
36081	108
36099	108
35992	108
35868	114
35872	114
35875	114
35879	114
35880	114
35884	114
35889	114
35897	114
35907	114
35912	114
35920	114
35929	114
35933	114
35986	114
35989	114
36023	114
36050	114
36069	114
36083	114
36102	114
35827	114
35934	114
35983	114
36024	114
36072	114
36002	114
36074	114
36103	114
35894	115
35811	115
35955	115
36067	115
35828	115
35863	115
35888	115
35975	115
36073	115
36100	115
35931	115
35959	115
35804	115
35805	115
35939	115
35942	115
35945	115
35949	115
35816	115
35835	115
35852	115
35899	115
36000	115
36064	115
36085	115
35814	116
35831	116
35848	116
35861	116
35885	116
35898	116
35913	116
35927	116
35940	116
35958	116
35974	116
35997	116
36013	116
36021	116
36041	116
36046	116
36054	116
36071	116
36084	116
36106	116
35900	117
35815	117
35873	117
35838	117
35860	117
35951	117
35953	117
35957	117
35968	117
36037	117
36053	117
36070	117
36087	117
36105	117
35862	117
35954	117
35998	117
36055	117
36098	117
35987	119
35826	119
35802	119
35808	119
35813	119
35818	119
35821	119
35825	119
35830	119
35960	119
35962	119
35963	119
35965	119
35970	119
35971	119
35982	119
36040	119
36059	119
36075	119
36090	119

Object Name	Object Type	Failure Reason	Time
tblTreatment	Table	Could not save the object	2013-01-12

SELECT DISTINCTROW * FROM tblVisit;

SELECT DISTINCTROW * FROM tblPatient;

SELECT tblBilling.InvoiceItem, tblBilling.InvoiceDate, tblBilling.InvoiceAmt, tblBilling.InvoicePaid, tblVisit.Reason, tblPatient.City, qryPatientsByName.Patient FROM ((qryPatientsByName INNER JOIN tblPatient ON qryPatientsByName.[PatientID] = tblPatient.[PatientID]) INNER JOIN tblVisit ON tblPatient.[PatientID] = tblVisit.[PatientID]) INNER JOIN tblBilling ON tblVisit.[VisitID] = tblBilling.[VisitID] ORDER BY tblBilling.InvoiceItem, tblBilling.InvoiceDate;

SELECT IIf(IsNull([Parent]),[LastName] & ", " & [FirstName],[Parent] & " (Parent)") AS Patient, tblPatient.PatientID, tblPatient.LastName, tblPatient.FirstName, tblPatient.Parent, tblPatient.BirthDate, tblPatient.Phone, tblPatient.Address, tblPatient.City, tblPatient.State, tblPatient.Zip, tblPatient.EmailAddress FROM tblPatient ORDER BY IIf(IsNull([Parent]),[LastName] & ", " & [FirstName],[Parent] & " (Parent)");

SELECT tblVisit.PatientID, tblVisit.VisitID, tblBilling.InvoiceAmt, tblVisit.VisitDate, tblVisit.Reason FROM tblVisit INNER JOIN tblBilling ON tblVisit.VisitID = tblBilling.VisitID;

SELECT [tblVisit].[VisitID] FROM tblVisit;

PARAMETERS __VisitID Value; SELECT DISTINCTROW * FROM tblBilling AS frmVisitsAndInvoices WHERE ([__VisitID] = VisitID);

SELECT [qryPatientsByName].[Patient], [qryPatientsByName].[PatientID] FROM qryPatientsByName ORDER BY [Patient];

SELECT DISTINCTROW * FROM tblVisit;

Access Assignment/Data files for assignment/Tutorial/Referral.accdb

PatientID	FirstName	LastName	Phone	Address	City	State	Zip	EmailAddress
12001	Lee	Freeman	860-938-5622	541 Perkins Dr	Hartford	CT	06120	[email protected]
12002	Marsha	Sullivan	860-552-6937	187 Wallace Rd	Windsor	CT	06095	[email protected]
12003	Chris	Bowers	860-305-3985	716 Oxford Ave	Bloomfield	CT	06002	[email protected]
12004	Sandy	Lee	860-226-4999	137 Noyes Ct	Hartford	CT	06112	[email protected]

Access Assignment/Data files for assignment/Tutorial/Sandra Parker Associate Degree.docx

Joseph Brant Community College

THIS CERTIFIES THAT

Sandra Parker

has successfully completed the required course of study approved by the Board of Education for the State of Michigan, and is therefore awarded this

Associate Degree

Dated this 29th day of November, 1998

Pamela Lee		Roger Samuels
President		Vice Principal Academic

image1.png

Access Assignment/Data files for assignment/Tutorial/Sandra Parker Bachelor Degree.pdf

ORANGE GROVE UNIVERSITY

THIS CERTIFIES THAT

SANDRA PARKER

has successfully completed the required course of study approved by the Board of Education for

the State of Michigan, and is therefore awarded this

BACHELOR DEGREE

Dated this 5th day of May, 2002

Richard Meaden

Theo Yan President Vice Principal Academic

Access Assignment/Data files for assignment/Tutorial/Sandra Parker Expenses.xlsx

Sheet1

Expenses
Gas	$ 126.00
Food	$ 79.00
Hotel	$ 235.00
Total	$ 440.00

AnimalID	StorageID
A23	1
A29	5
A34	6
A43	2
A49	3
A55	4
A58	1
A73	2
B24	3
B33	5
B35	1
B45	6
B55	5
C27	2
C28	3
C29	1
C33	2
C44	4
C58	2
C74	3
C92	1
D21	5
D22	6
D23	4
D34	5
D42	6
D44	5
D48	4
D83	5
F14	6
F29	5
G23	4
G28	1
G29	2
G36	3
G45	5
G48	1
G56	4
H04	1
H21	4
H34	2
J28	5
J29	6
J37	5
K23	3
K24	6
K25	5
K33	4
K34	2
K38	2
K39	5
K43	1
K48	6
K94	5
L45	4
M23	5
M48	6
M49	2
M77	6
N34	3
N35	3
N37	2
N43	5
N82	4
N84	5
N94	5
P34	6
P38	4
P39	5
P48	1
R22	1
R27	6
R29	4
R33	5
R34	5
R38	2
R39	3
R43	5
R45	1
R55	4
R59	5
R98	6
S31	2
S35	3
T23	1
T32	6
T75	5
V84	4
V98	6
W15	5
W22	1
W23	4
W29	2
W52	3
W73	3
Y24	5
Y29	6
Y33	2
Y35	5
Y98	4

AnimalID	StorageID
A23	1
A29	5
A34	6
A43	2
A49	3
A55	4
A58	1
A73	2
B24	3
B33	5
B35	1
B45	6
B55	5
C27	2
C28	3
C29	1
C33	2
C44	4
C58	2
C74	3
C92	1
D21	5
D22	6
D23	4
D34	5
D42	6
D44	5
D48	4
D83	5
F14	6
F29	5
G23	4
G28	1
G29	2
G36	3
G45	5
G48	1
G56	4
H04	1
H21	4
H34	2
J28	5
J29	6
J37	5
K23	3
K24	6
K25	5
K33	4
K34	2
K38	2
K39	5
K43	1
K48	6
K94	5
L45	4
M23	5
M48	6
M49	2
M77	6
N34	3
N35	3
N37	2
N43	5
N82	4
N84	5
N94	5
P34	6
P38	4
P39	5
P48	1
R22	1
R27	6
R29	4
R33	5
R34	5
R38	2
R39	3
R43	5
R45	1
R55	4
R59	5
R98	6
S31	2
S35	3
T23	1
T32	6
T75	5
V84	4
V98	6
W15	5
W22	1
W23	4
W29	2
W52	3
W73	3
Y24	5
Y29	6
Y33	2
Y35	5
Y98	4

AnimalID	StorageID
A23	1
A29	5
A34	6
A43	2
A49	3
A55	4
A58	1
A73	2
B24	3
B33	5
B35	1
B45	6
B55	5
C27	2
C28	3
C29	1
C33	2
C44	4
C58	2
C74	3
C92	1
D21	5
D22	6
D23	4
D34	5
D42	6
D44	5
D48	4
D83	5
F14	6
F29	5
G23	4
G28	1
G29	2
G36	3
G45	5
G48	1
G56	4
H04	1
H21	4
H34	2
J28	5
J29	6
J37	5
K23	3
K24	6
K25	5
K33	4
K34	2
K38	2
K39	5
K43	1
K48	6
K94	5
L45	4
M23	5
M48	6
M49	2
M77	6
N34	3
N35	3
N37	2
N43	5
N82	4
N84	5
N94	5
P34	6
P38	4
P39	5
P48	1
R22	1
R27	6
R29	4
R33	5
R34	5
R38	2
R39	3
R43	5
R45	1
R55	4
R59	5
R98	6
S31	2
S35	3
T23	1
T32	6
T75	5
V84	4
V98	6
W15	5
W22	1
W23	4
W29	2
W52	3
W73	3
Y24	5
Y29	6
Y33	2
Y35	5
Y98	4