Access expert
anon27m
Homework10LastNameFirstName.accdb| InsName |
|---|
| BCBS |
| Kaiser |
| Cigna |
| PatientID | Pname | Address | Phone | Birthdate | Insurance | InsuranceNum |
|---|---|---|---|---|---|---|
| 10001 | Jerry Seidmann | 10 East Ave | 8604292778 | 3/30/97 | BCBS | 114-56-4567 |
| 10002 | Mary Taylor | 37 South Ave | 8604298990 | 4/2/88 | BCBS | 234-67-9084 |
| 10003 | Hugh Ryan | 68 Main St. | 8607427243 | 5/1/81 | Kaiser | 456-09-8909 |
| 10004 | Robert Russell | 98 Lakeside Dr. | 8606437889 | 8/4/06 | Cigna | 908-98-9999 |
| 10005 | David Stafford | 80 River Rd. | 8604471435 | 8/5/09 | Cigna | 905-89-6654 |
| ServiceId | Sname | Price |
|---|---|---|
| 1510 | Space Maintainer | ¤ 120.00 |
| 2220 | X-Rays | ¤ 40.00 |
| 2510 | Inlay | ¤ 185.00 |
| 2740 | Crown | ¤ 215.00 |
| 3330 | Molar Root Canal | ¤ 85.00 |
| 9440 | Emergency Visit | ¤ 25.00 |
| VisitID | ServiceID | Comments | SPrice |
|---|---|---|---|
| 2101 | 3330 | Ok | ¤ 80.00 |
| 2101 | 9440 | Ok | ¤ 23.00 |
| 2102 | 2220 | show problems | ¤ 35.00 |
| 2102 | 2510 | revisits needed | ¤ 180.00 |
| 2103 | 2740 | see patient in 5 days | ¤ 215.00 |
| 2104 | 3330 | Ok | ¤ 85.00 |
| 2104 | 9440 | Ok. Further care needed | ¤ 25.00 |
| 2105 | 1510 | pick up in 3 weeks | ¤ 120.00 |
| 2105 | 2220 | show perfect teeth | ¤ 40.00 |
| 2105 | 2510 | follow up visit in 5 days | ¤ 185.00 |
| 2106 | 2510 | ¤ 185.00 | |
| 2107 | 2740 | ¤ 215.00 |
| VisitId | PatientId | VisitDate | Doctor | Payment Method |
|---|---|---|---|---|
| 2101 | 10002 | 3/4/15 | Bloch | Check |
| 2102 | 10003 | 3/5/15 | Marks | Insurance |
| 2103 | 10003 | 3/6/16 | Bloch | Credit Card |
| 2104 | 10004 | 3/7/16 | Koontz | Insurance |
| 2105 | 10005 | 4/2/16 | Bloch | Credit Card |
| 2106 | 10001 | 5/2/16 | Marks | Check |
| 2107 | 10003 | 5/4/16 | Marks | Insurance |
