Access Homework

profileralph44
hw_5_doc-n-the-box_-_data.xlsx
Home>Information Systems homework help>Access Homework

Patients

Patient ID First Name Last Name Phone Date of Birth Gender Health Plan Allergies
19 Dusty Springfield (435) 693-1212 4/5/1990 M Medicare Codeine derivatives, merperidine
10 Jonathan Cardenas (928) 551-5547 8/22/94 M Dismal Swamp Health Peanuts
23 Jennifer Holiday (928) 888-3545 11/21/1989 F WeCare Health Management
18 Anders Kroll (505) 499-6541 9/11/94 M Claytor Lake Community Health Penicillin
14 Mary Ambrose (435) 444-1233 4/15/90 F Claytor Lake Community Health Shellfish
15 Gina Mercado (970) 514-3212 6/17/89 F Medicare Morphine
4 Steven Nuggent (435) 122-4545 10/12/1986 M Southern Appalachian Mountains Health Plan Penicillin
11 Paula Hargus (505) 744-1889 6/11/90 F WeCare Health Management
22 Jose Hernandez (505) 498-6478 6/30/1987 F Dismal Swamp Health Morphine, morphine derivatives
24 Kimberley Smith (928) 647-2477 1/16/1989 F Claytor Lake Community Health Homework
20 Kevin Bacon (435) 477-8989 6/22/1990 M Southern Appalachian Mountains Health Plan
21 Cesar Romero (970) 631-2222 1/14/1987 M Great American Mid-Atlantic Health Peanuts
1 Ted Williams (970) 644-1214 12/11/94 M Medicare Pine Tar
17 Maria Gabel (970) 223-4157 8/12/90 F WeCare Health Management Penicillin
8 Sonia Cardenas (928) 551-5547 4/12/1988 F Great American Mid-Atlantic Health Penicillin, cephalosporins

Doctors

Doctor ID First Name Last Name Phone
D1 David Warric (435) 321-4789
D3 Patricia Loke (435) 189-9874
D5 Gene Allen (435) 887-1818
D2 Roxanna Freitag (505) 884-0542
D4 Robert Gramann (928) 449-4174
D9 Sara Jurski (505) 884-0542
D11 James Trehass (928) 888-4178
D6 Antonio Westenberg (928) 488-1741
D8 Joshua Wilson (435) 887-1818
D7 Gunther Zamarron (970) 429-7475

Drugs

UPN Name Generic? Description Unit Dosage Dosage Form Cost Price/Dose
102 Ampicillin TRUE Antibiotic Pill 250 mg $0.75 $1.45
121 Tolbutamide FALSE Bacterial infections Pill 2 mcg $0.24 $0.90
224 Avatocin FALSE Allergies Pill 100 mg $0.65 $1.40
247 Acebutolol hydrochloride FALSE Arthritis Pill 400 mg $0.55 $1.10
256 Dseurton TRUE High blood pressure Pill 175 mg $0.60 $1.20
289 Levothyroxine TRUE Thyroid disorders Pill 25 mg $0.70 $1.40
311 Dyotex FALSE Tonsillitis Bottle 2 tsp $0.25 $1.05
366 Phalastat FALSE Allergies Bottle 1 tsp $0.75 $1.60
398 Clonazepam FALSE Epiliepsy Pill 4 mcg $0.65 $1.20
412 Epronix FALSE Pain Pill 500 mg $0.85 $1.50
444 Syocil TRUE Diabetes Pill 120 mg $0.45 $1.10
452 Diazapam TRUE Anxiety Pill 5 mg $0.45 $1.12
467 Glimepiride TRUE Diabetes Pill 2 mg $0.25 $0.90
523 Xeroflarol TRUE Acid reflux Bottle 1 tsp $0.50 $1.05
524 Cefixime TRUE Antihistamine Pill 400 mg $0.95 $1.60
566 Quentix TRUE High blood pressure Pill 50 mg $0.50 $1.25
587 Haloperidol FALSE Diuretic Pill 6 mcg $0.70 $1.30
622 Tiron FALSE Beta blocker Pill 150 mcg $0.75 $1.30
642 Montelukast sodium TRUE Acne Pill 10 mcg $0.32 $0.90
644 Hyometadol FALSE Asthma Bottle 2 tsp $0.65 $1.35
654 Warfarin Sodium TRUE Bronchitis Pill 4 mg $0.65 $1.40
711 Nvalax TRUE Depression Pill 200 mg $0.30 $0.90
732 Albuterol Sulfate TRUE Asthma Pill 2 mg $0.30 $0.95
741 Almotriptan TRUE Conjunctivitis Pill 6.25 mg $0.14 $0.87
828 Myobuterol TRUE Antibiotic Bottle 1 tsp $0.55 $1.60
852 Oxaprozin TRUE Anti-inflammatory Pill 1200 mg $0.60 $1.25
878 Didanosine TRUE Sinus infection Pill 200 mg $0.65 $1.12
932 Tvalaxec TRUE Antihistamine Bottle 2 tsp $0.50 $1.00
972 Rivastigmine tartrate TRUE ADHD Pill 4.4 mg $0.40 $1.05
987 Rizatriptan Benzoate FALSE Pain Pill 6 mg $0.47 $1.10

Health Plans

Plan ID# Plan Name Address City State Zip Phone
H1205 WeCare Health Management 269 Monument Ave Richmond VA 23223 (804) 477-9899
H10119 Claytor Lake Community Health 11112 W. University Dr. Radford VA 24141 (540) 741-4545
H0971 Medicare 7500 Security Blvd. Alexandria VA 22301 (703) 411-1414
H1941 Southern Appalachian Mountains Health Plan 99 Blue Ridge Parkway Front Royal VA 22630 (540) 540-8742
H3410 Great American Mid-Atlantic Health 4200 Hwy 123 S. Fairfax VA 22030 (703) 177-9184
H1695 Dismal Swamp Health 32111 Swamp Park Place Suffolk VA 23434 (757) 654-2425

Refills

Prescription ID Refill Date
15 4/22/10
14 6/10/10
13 6/23/10
17 8/1/10
24 9/1/10
19 9/12/10
13 9/29/10
11 11/1/10
15 11/13/10
16 11/16/10
13 11/30/10
19 12/14/10
18 12/23/10
21 12/23/10
26 12/31/10
12 1/3/11
5 1/12/11
20 1/16/11
26 2/1/11
16 2/14/11
21 2/14/11
24 2/15/11
17 2/21/11
5 3/11/11
10 3/11/11
27 3/14/11
8 3/18/11
2 4/14/11
9 4/14/11
7 5/14/11
21 5/16/11
2 6/1/11
8 6/1/11
6 6/3/11
23 6/11/11
4 6/21/11
10 6/21/11
3 7/1/11
6 8/25/11
23 9/18/11
9 10/11/11
1 12/11/11

Rx

Prescription ID UPN Quantity Unit Date Expire Date Refills Authorized Auto Refill? Refills Used Instructions Patient ID Doctor
9 102 1 mg 6/29/10 6/14/11 4 TRUE 2 1 pill every 4 hours 10 D6
26 102 1 mg 5/2/11 10/30/11 3 TRUE 0 1 pill every 5 hours with food 1 D3
15 224 1 mg 9/10/10 6/10/11 2 TRUE 0 1 pill every 6 hours 11 D7
22 247 1 mg 1/16/11 12/18/11 0 TRUE 0 2 pills daily 14 D9
1 256 1 mg 1/10/10 10/24/10 2 TRUE 0 2 pills every 12 hours 22 D2
12 311 1 ml 7/17/10 3/9/11 3 TRUE 0 2 teaspoons full every 4 hours 8 D4
17 311 1 ml 9/24/10 11/25/11 4 TRUE 0 2 teaspoons full every 4 hours 1 D11
5 366 1 ml 4/15/10 3/3/11 3 TRUE 0 3 teaspoons full every 6 hours 1 D8
24 366 1 ml 2/2/11 12/15/11 3 FALSE 0 2 teaspoons full every 6 hours 19 D4
25 366 1 ml 2/2/11 12/15/11 0 FALSE 0 2 teaspoons full every 6 hours 19 D5
4 398 1 mg 4/15/10 6/11/11 4 TRUE 1 1 pill every 5 hours with food 18 D2
7 398 1 mg 5/16/10 7/11/11 4 TRUE 0 1 pill every 5 hours with food 17 D6
16 398 1 mg 9/10/10 9/12/11 3 TRUE 1 2 pills every 6 hours with food 4 D8
2 444 1 mg 2/24/10 1/20/11 4 TRUE 0 2 pills every 6 hours with food 21 D7
21 523 1 ml 1/14/11 8/19/11 3 TRUE 1 2 teaspoons full every 5 hours 4 D11
11 642 1 mg 7/8/10 1/6/11 4 TRUE 0 2 pills daily 21 D3
8 711 1 mg 6/21/10 7/30/11 5 FALSE 0 2 pills daily 22 D4
20 711 1 mg 1/6/11 8/9/11 3 FALSE 1 2 pills daily 24 D5
10 732 1 mg 7/6/10 6/24/11 4 TRUE 0 2 pills every 5 hours as needed 23 D8
14 732 1 mg 8/14/10 7/31/11 4 TRUE 0 2 pills every 6 hours 18 D9
3 828 1 ml 3/14/10 1/22/11 2 TRUE 0 1 teaspoon every 4 hours 11 D1
13 828 1 ml 8/13/10 7/14/11 5 TRUE 2 1 teaspoon every 4 hours 23 D4
19 828 1 ml 12/15/10 12/11/11 3 FALSE 1 1 teaspoon every 4 hours 15 D1
6 878 1 mg 5/1/10 4/18/11 4 TRUE 1 2 pills every 4 hours with food 20 D7
27 878 1 mg 6/13/11 12/12/11 2 TRUE 0 2 pills every 4 hours with food 14 D3
18 932 1 ml 9/24/10 4/16/11 3 TRUE 0 1 teaspoon every 6 hours 17 D3
23 932 1 ml 1/24/11 9/22/11 2 TRUE 1 1 teaspoon every 6 hours 11 D11