final_project_database_revised.xls
Demographics
| Client's Name | Address | City | State | Zip | Phone Number | Date of Birth | Age | Medications | Social Security Number |
| SHARON THOMAS | 1413 S CALIFORNIA | COMPTON | CA | 90221 | 310-631-1988 | 02/28/99 | 17 | Adderall | 424-26-4789 |
| DON WALKER | 15215 BROOKSHIRE | DOWNEY | CA | 90242 | 562-775-3125 | 12/15/79 | 37 | Paxil | 56-48-2323 |
| DANIELLE SMITH | 26 SUNSHINE STREET | MORENO VALLEY | CA | 92551 | 951-887-8765 | 09/11/60 | 56 | Adderall | 345-67-8901 |
| MILES HAVEN | 2666 E 55TH WAY | LONG BEACH | CA | 90805 | 562-258-6569 | 08/25/69 | 47 | Ritalin | 456-78-9012 |
| THOMAS JOHNSON | 312 ACKERFIELD LANE | WILMINGTON | CA | 90744 | 310-867-4759 | 04/03/80 | 37 | Xanax | 567-89-0123 |
| SHAYLA JOHNS | 552 CHERRYCREEK RD | SAN PEDRO | CA | 90731 | 562-323-1455 | 03/23/83 | 34 | Adderall | 678-90-1234 |
| TERRI SHAWN | 61 BANNER DRIVE | PARAMOUNT | CA | 90723 | 562-685-2323 | 08/02/98 | 18 | Ibuprofen | 789-01-2345 |
| DOLORES GOMEZ | 9128 TRAVIS DR | NORWALK | CA | 90651 | 310-9641352 | 11/24/78 | 38 | Xanax | 890-12-3456 |
| Ted Jackson | 3101 E ARTESIA | PERRIS | CA | 92570 | 951-635-7412 | 04/24/97 | 19 | Adderall | 901-23-4567 |
| FRED JACKSON | 1614 CHESTNUT AVE | CORONA | CA | 92880 | 951-242-8759 | 12/01/84 | 32 | Ibuprofen | 423-94-0387 |
&CDATABASE
Encounters
| Client's Name | Therapist Seen | Service Provided | Date of Service | Hours of Service | Fee per hour | Amount Due | Amount Paid | Balance |
| SHARON THOMAS | Frank Mullins | Family | 04/10/16 | 2 | $100 | $25.00 | $75.00 |
| DON WALKER | Frank Mullins | Medication | 01/12/16 | 1 | $50 | $10.00 | $40.00 |
| DANIELLE SMITH | Frank Mullins | Individual | 02/25/17 | 0.5 | $25 | $15.00 | $10.00 |
| MILES HAVEN | Frank Mullins | Family | 05/22/16 | 2.5 | $125 | $50.00 | $55.00 |
| THOMAS JOHNSON | Frank Mullins | Medication | 02/14/17 | 1.5 | $75 | $25.00 | $50.00 |
| SHAYLA JOHNS | Jodie Blackwell | Individual | 07/15/16 | 1 | $50 | $15.00 |
| TERRI SHAWN | Jodie Blackwell | Family | 04/07/17 | 2 | $100 | $25.00 | $75.00 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 08/23/16 | 1.25 | $80 | $20.00 | $60.00 |
| Ted Jackson | Jodie Blackwell | Family | 11/15/16 | 1 | $50 | $10.00 | $40.00 |
| FRED JACKSON | Jodie Blackwell | Medication | 07/06/16 | 2 | $100 | $25.00 | $75.00 |
Ddlalicous1
