Access Skills Approach

Jiawei.Yu-AC2016-SkillReview-4-2.accdb

Home >Computer Science homework help >Access Skills Approach

HospitalID	HospitalName	MemberVisits	Address	City	StateProvince	ZIPPostal	CountryRegion
1	Miami City Hospital	87	4500 Miami Blvd	Miami	FL	33126	USA
2	Central Lauderdale Hospital	59	320 Palmer Rd	Ft. Lauderdale	FL	33301	USA
3	West Palm Hospital	61	800 Jefferson Street	West Palm Beach	FL	33403	USA

OrderID	OrderingPhysician	Procedure	OrderDate
1	AG01	3094	6/29/16
2	MB01	2355	8/1/16
3	MB01	2355	8/12/16
4	BG01	4219	8/15/16
5	DD01	0045	8/15/16
6	JC01	1472	8/15/16
7	JC01	4219	8/15/16
8	JA01	3161	8/20/16

PhysicianID	FirstName	LastName	Phone	StreetAddress	City	ZipCode	MemberCount	HospitalName
AG01	Antonio	Gonzalez	5615559361	702 Columbia Road	West Palm Beach	33403	26	3
AW01	Anthony	Willett	5615557939	1274 Valley Street	West Palm Beach	33412	9	3
BG01	Bruce	Garber	9545554473	1107 Murry Street	Ft. Lauderdale	33312	31	2
CF01	Caroline	Fredette	5615550634	4123 Five Points	West Palm Beach	33403	11	1
CM01	Catherine	Martin	9545551016	1234 Main Street	Ft. Lauderdale	33305	0	1
CS01	Charlotte	Sager	3055552879	749 Petunia Way	Miami	33156	32	1
DB01	Dale	Brown	5615552312	4849 Sunrise Road	West Palm Beach	33401	8	1
DD01	David	Duron	5615555510	1317 Everette Lane	West Palm Beach	33414	7	3
DT01	Danny	Tweed	3055557623	711 Duke Lane	Miami	33183	10	1
EM01	Emily	McNabb	3055557363	3633 Armbrester Drive	Miami	33134	5	1
GE01	Genevieve	Eades	5615554819	1941 Collins Avenue	West Palm Beach	33401	22	3
GP01	Gerald	Price	9545556754	3735 Jadewood Drive	Ft. Lauderdale	33312	5	1
HH01	Heidi	Hartzell	9545553859	2204 Plainfield Avenue	Ft. Lauderdale	33301	31	3
JA01	Joe	Alleyne	3055553748	2086 Lewis Street	Miami	33176	23	2
JB01	Juan	Bettencourt	5615554509	4769 Pinewood Avenue	West Palm Beach	33412	15	3
JB02	James	Bryant	3055551212	3091 Main Street	Miami	33143	16	1
JC01	John	Castellano	3055557731	56 Waldeck Street	Miami	33176	19	1
JD01	Jeff	Defelice	3055559012	2202 Boone Street	Miami	33134	14	1
JM01	Jason	Mayer	3055551956	2331 Upland Avenue	Miami	33183	14	1
JW01	Jeffery	Weldon	9545556243	3775 Willow Oaks Lane	Ft. Lauderdale	33305	14	2
KS01	Karen	Swann	3055552490	800 Tyler Street	Miami	33155	22	2
MB01	Melinda	Bocanegra	3055555648	355 Garrett Street	Miami	33156	23	1
MN01	Marvin	Numbers	9545554366	4630 Meadowcrest Lane	Ft. Lauderdale	33305	22	2
MZ01	Min	Zhou	9545554386	3952 Hewes Avenue	Ft. Lauderdale	33316	11	2
NG01	Nora	Gomez	9545559177	3182 Roguski Road	Ft. Lauderdale	33316	18	2
NW01	Nathan	Westmoreland	5615550096	4066 Glen Street	West Palm Beach	33414	25	3
PE01	Philip	Elson	3055551028	2905 Washington Street	Miami	33186	19	1
RR01	Russell	Rand	5615552958	3320 Sharon Lane	West Palm Beach	33417	14	3
RR02	Ronald	Rayner	5615551141	3670 Beechwood Drive	West Palm Beach	33417	28	3
RS01	Roberta	Storm	3055550049	2191 Jarvis Street	Miami	33186	29	1
RW01	Ralph	Whitacre	9545554512	590 Grant View Drive	Ft. Lauderdale	33304	18	3
SD01	Steve	Diggs	9545551017	2860 Godfrey Road	Ft. Lauderdale	33305	29	3

ProcedureID	ProcedureName	Covered	ReimbursementAmt
0045	Acupuncture	false	¤ 0.00
0063	Fertility Treatment	false	¤ 0.00
0072	Visual Acuity Exam	false	¤ 0.00
0091	Facial	false	¤ 0.00
0094	ACNE Treatment	false	¤ 0.00
1472	CBC	true	¤ 20.00
1895	Flu Vaccine	true	¤ 15.00
2310	Ultrasound	true	¤ 30.00
2325	X-ray	true	¤ 50.00
2355	MRI	false	¤ 0.00
2385	CT Scan	true	¤ 95.00
3094	ECG	true	¤ 25.00
3161	Cardiac Stress Test	true	¤ 35.00
4219	EEG	true	¤ 25.00
5698	Mammography	true	¤ 35.00
5834	Prostate Exam	true	¤ 20.00

SELECT Hospitals.HospitalName, Physicians.LastName, Physicians.FirstName, Physicians.MemberCount FROM Hospitals INNER JOIN Physicians ON Hospitals.HospitalID = Physicians.HospitalName;