Suljettu

Surgical Logbook and patient management online

I need an online database to be used as a personal logbook and also to be used for producing reports at the end of each month.

I have the Microsoft access database with all the tables and fields. I do not know how to form the right relationships between the tables so that they work online. I also am not familiar with the lookup fields and how to use selected predefined data in the fields.

I need simple front ends for the site to allow adding, modifying and deleting data. The scripts linking to the database should be ready to go on a windows server. Prefer Microsoft access database so that I can analyse data offline.

The structure of the database has the following tables

1. Table : Patients details

Fields: Auto ID number, Hosp number, Name, Date of birth, address, Email address.

2. Table : Symptoms

Fields : question 1 (1 answer out of 5 choices) question 2 (1 answer out of 5 choices) etc etc up to question 5, followed by a field for comments

[url removed, login to view] : Diagnosis.

Fields : Category, Diagnosis (A general diagnosis will be chosen out of a list of about 20), Sub diagnosis, further subdiagnosis. Comorbidity, A comments field. A script should be used to narrow down the list of options when a category and diagnosis is chosen.

4. Table : Operation Details.

Fields : Hospital name, Consultant name, Surgeons name, Assistants name, Anaesthetists name, Op start time, op finish time. Elective or emergency, Approach (Anterior, Posterior, Combined, Laparoscopic), Spinal Cord monitoring (Yes or No). Drains (1,2 or 3). Blood loss, Bone graft (rib, pelvic, vertebra or substitute), Research specimens (Yes or No). Intra-op complications (free text)

5. Table : Postop Details

Fields: Length of stay, Orthotics( Brace, shoe raise, crutches, walking stick or wheelchair), complications (choice of about 12) Xray findings. Follow up (Number of weeks ?)

6. Follow up Table : Symptoms

Fields : question 1 (1 answer out of 5 choices) question 2 (1 answer out of 5 choices) etc etc up to question 5, followed by following fields; How many weeks since op, comments

The database should allow different users to log on using own password. Only administrator can add to patients table ie add, delete or modify new patients. Users can only add or modify other tables. Patient details table must exist before other tables can be formed.

The following relationships should apply online;

Each patient can have multiple diagnoses. Each diagnosis can have multiple operations. Each opeartion can only have one postoperative details table. Each patient can have multiple follow ups.

Please let me know if any further clarification is needed.

Thanks

Taidot: ASP, Java, Komentosarjan asennus, Windows Desktop

Näytä lisää: surgical logbook script, online surgical logbook, surgical logbook online, surgical logbook, management surgical logbook, surgical patient logbook, work online free, start up consultant, right management, question of data structure, producing work, personal assistants online, or hospital, online research reports, online management consultant, microsoft consultant, microsoft access database consultant, microsoft access consultant, management research reports, java table data structure, i need a management consultant, how to consultant, go ie, free work online, free online java

Tietoa työnantajasta:
( 12 arvostelua ) London, United Kingdom

Projektin tunnus: #5113

20 freelanceria on tarjonnut keskimäärin 88 $ tähän työhön

ispg

Dear Sir, We are one website designing and programming company based at Cochin, Kerala, India. We are looking forward for a great and long lasting association with you organization. We posses high end technology an Lisää

100 $ USD 2 päivässä
(4 arvostelua)
5.2
nidle

Dear Sir. We had carefully examined your project and got your idea. We can provide you EXACTLY WHAT YOU NEED!!! We had already developed a great number of projects similar to yours and have all the required skills, so Lisää

100 $ USD 10 päivässä
(2 arvostelua)
4.8
ItIndia

Hello, I had implemented some big solution on Data Bases and this will be pretty simple for My team. If you inisis I can show you My previus work demo. Thanks satish

78 $ USD 10 päivässä
(13 arvostelua)
3.9
viaden

Hi! WE have just gone through your requirements and now we would like to assure you that our programmers can help you with your problem. WE have already developed many databases so we are familiar to all levels of thei Lisää

100 $ USD 10 päivässä
(1 arvostelu)
3.8
jlcreat

We would be happy to interface your database with an easy-to-use webpage. Please see [url removed, login to view] for more information about us, including our portfolio.

100 $ USD 14 päivässä
(1 arvostelu)
2.6
jaidev

Please check PMB. Thanks.

100 $ USD 7 päivässä
(1 arvostelu)
2.0
mail2veejay

We are a group of 2 programmers and one designer having proficency in providing customised database driven application part from dymanic and static sites with a combined experience of over 12 years in VB, ASP MSSQL a Lisää

100 $ USD 31 päivässä
(1 arvostelu)
1.9
qcomp

I am well experienced will help you in completing this. Will give you an asp based scripting solution, with HTML form wizard for data entry and modifications. I have done many similar works. Thanks.

100 $ USD 10 päivässä
(1 arvostelu)
1.4
gunjankvel

We are a group of professionals having more than 5 yrs [url removed, login to view] can do the work for you.

80 $ USD 7 päivässä
(1 arvostelu)
1.4
cb73

we can do it.

100 $ USD 2 päivässä
(0 arvostelua)
0.0
rschipie

I'm just working on a hospital informationsystem for a hospital but it's bigger and works under Linux also the price is much bigger, anyway if your interested feel free to contact me.

100 $ USD 40 päivässä
(0 arvostelua)
0.0
lcwprakash

Hi, I am Prakash, we (3 guys from New Delhi) have been in the serious web and customized software development business for the past 5 years, and providing quality and professional web and client/server solutions for a Lisää

70 $ USD 15 päivässä
(0 arvostelua)
0.0
salus

Hi, We are a professional software development company with 100% project completion and customer satisfaction rate. Being new to this site we, obviously, do not have a rating. We have been through your posting and u Lisää

22 $ USD 30 päivässä
(0 arvostelua)
0.0
technosoft

Check our profile we have done similair projects.

100 $ USD 20 päivässä
(0 arvostelua)
0.0
deepakv

Hello,We have done many projects in HealthCare segment, and even have two doctors onboard with us to help us relate to Healthcare sector. We assure you that the project will be executed with a clinical precision. Rega Lisää

100 $ USD 10 päivässä
(0 arvostelua)
0.0
DevindraSharma

Hi, I can provide u the project as per requirement u can given in short period of time dev

100 $ USD 7 päivässä
(0 arvostelua)
0.0
globusresearch

We have developed same kind of modules for more than 6 websites so we can give you best layout and codding with full security and encyptions. As you know we work for clients and then never claim that its our work as pe Lisää

95 $ USD 3 päivässä
(0 arvostelua)
2.0
smartdesign

Hi, we are an efficient and dedicated team of professionals with more than 7 years experience in the I.T. indusrty and more than 100 quality projects to our credit. Our focus is on quality and timely delivery. Some Lisää

100 $ USD 30 päivässä
(0 arvostelua)
0.0
sarabjeetkaur

We have fairly good experience in working with database applications. Pleae vist us at [url removed, login to view]<b><i>Removed by [url removed, login to view] Admin for breaching our Terms and Conditions</i></b>[url removed, login to view] and [url removed, login to view]<b><i>Removed by Fre Lisää

100 $ USD 10 päivässä
(0 arvostelua)
0.0
craniumone

We studied and understood your [url removed, login to view] are interested in working on this [url removed, login to view] the work is easy we'll charge only $[url removed, login to view] interested kindly contact via PMB.Thanks.

20 $ USD 6 päivässä
(0 arvostelua)
0.0