Recent content by akerenyi

Dear all, Happy new year to all of you, I hope you had some nice relaxation over the holidays. Agnieszka, thank you very much for your help. I have tryed to follow your example in both questions. First, the combo box issue. What I'm trying to do is only select the InfusionName in the combo...

Hi there, First, to Agnieszka: Thanks for your date/time suggestion, I will follow your example. Regarding test types my tables are currently set up like this: tbl_TestType -TestTypeID -TestType name tbl_TestDataItems -DataItemID -Test Data Item name tbl_PatientTestResults...

Thank you all for your kind help. I have followed the structure suggested my lagbolt. I am making the final strokes now on the tables structure. As soon as I'm done, I will post a brief outline and I would appreciate your comments on it. Than I will probably also have some questions regarding...

So you're all suggesting that I make tbl_Infusions - ID - PatientID - Time - Morfine - Saline - other infusions Thus, each record would correspond to 1 hour from one patient's care. This would create approx. 200 records / patients, with over 300 patients that's 60 000 records.

Hi there, Many of you might already be familiar with my amateur questions regarding the database I'm currently developing for our medical research group. We are working at a neonatology ward, an intensiver care unit for newborns. These babies recieve continuous hourly physiological monitoring...

Hi there, I have read everything through and I would set up my patients-blood test relationships like this: Patients_table - Patient_ID (PK) - Address - Phone - Date of birth Tests_Table - Test_ID (PK) - Patient_ID (FK) - Test_date - Test_hour - pH - CO2 It is a one-to-many relationwhip...

This is a pure research tool for our private purposes, patient care uses a big, national medical software, which has no connection to our small access database. This is only to surpass having to look up everything in the wirtten patient files. I will dive into that site now:)

Yes, I already have input masks for the text boxes and I will try to use as many combo boxes as possible to reduce human error. I haven't given much thought yet to the tracability of the changes, how can I manage that most easly, maybe with a work log? How can I get acces to make one?:)

Hi, Thank you all for your help. I will clarify our work briefly, I hope it helps. I work with neonatologist at an ICU for newborns. This means that everything needs to be monitored hourly (physiological parameters, blood tests, infusions/drugs) and everything is crucial in their first 168...

Hi there, I have made a simplified example. It is more measurements on day 2 than day 1, for example. So my problem is basicly with designing the entry form, which is optimalized for the user, who has hospital documentation from each day separately, with all the data from that particular day...

Thank you very much for you answer. I have researched data normalization and the data models and here is how I think about building the database now, based on the seen models: Patients_table - Patient_ID (PK) - Address - Phone - Date of admission Patients_tests_table - Patient_ID - Test_ID...

Hi there, Another amateur question: I am developing a medical patient database for our research group and I want to save an excessive amount of intensive care data. My problem is that there are some variables which need to be registered chronologically precisely and have discreet values, not...

Thank you very much:)

Hi there, I am developing a medical patient database for out research group. We have agreed to store numerical values in the table to help running statistics later. however, in the input form, we have to give text options. For example, I would like to create a form to save maternal medical...