Sedang Disiapkan

Add searchable forms and reports to existing MS Access database

I am available to speak with you via Skype if you need to discuss this project. This should be a quick project. I will likely pick the developer in 1-2 days.

I have an existing MSAccess 2010 database with 2 primary tables (Patients and Charges). Relationships have already been established. I would like the following:

Create a form and subform for the patient information and the patient's charges. The users need to be able to look up patients and see each patient's charge activity.

The top part of the form would be the patient information (name, address, etc.), beneath that would be the patient's insurance coverages (there can be up to 3 of them), and beneath that would be all the charge records associated with that patient. Use all of the fields in the database on the forms and I'll remove what I don't need later. So there would be one main form and two subforms. The user needs to be able to search for these patients. There should be 4 ways to search:

*Search by DOB

Enter DOB

Enter Last Name or partial last name

Enter First Name or partial first name

----

*Search by chart

Enter chart #

-----

*Search by Name

Enter Last Name or partial last name

Enter First Name or partial first name

If more than one found, the user can page through the records

-----

*Search by SSN

Enter SSN or partial SSN

-------------------------

I need to have 2 reports added as well:

Reports:

*List patients by Diagnosis

Prompts: Doctor, Service Dates, Diagnosis Ranges

*CPT Code Query

Prompts: Doctor, Dates of service

Kemahiran: Microsoft Access

Lihat lebih lanjut: service database access, msaccess developer, microsoft access database developer, access subform, microsoft access developer, searchable database, doctor search, access chart, microsoft query top, access project 2010 2013, microsoft access patient database, project 2013 access, create access database reports, patient insurance database access, forms search, 2013 query, access create query, access database form reports, insurance microsoft database, create search access database, insurance database access, add code access database, microsoft access insurance, add existing access database, user searchable database

Tentang Majikan:
( 26 ulasan ) Raleigh, United States

ID Projek: #4102698

Dianugerahkan kepada:

sinfulm3

Hello Sir, kindly check PMB.

$8 USD / jam
(7 Ulasan)
3.7

2 pekerja bebas membida secara purata $9/jam untuk pekerjaan ini

japapuss

Thank you for the opportunity to bid on your project. I have over 15 years of MS Access/SQL development experience, and am confident that I can effect the changes you have specified in a short time frame. The initial q Lagi

$10 USD / jam
(0 Ulasan)
0.0