Hi,
I am a radiologist. I work at a medical faculty as the responsable for mammographic examinations. My former collegues didn't use any form of database to archive mammography reports but I want to create a Access Database to achieve this purpose. As I am a doctor, I don't have a lot of experience in database creation. So any help will be appreciated.
So far I created (with Access 2000) the part required for patient demographics (name, ID number. adress, etc). This part is relatively easy. I just created tables with the required fields and used a wizard in form generator to create a form. The harder part for me is the creation of the mammography results. I want the other physicians to be able to enter results as fast and as easily as possible. For this purpose I created option groups. One option group consists of 4 options detailing the mammpgraphic finding (mass, asymetical opacity, microcalcification, parenchymal distortion), the other option group is the BI-RADS score (a score which can be between 0 and 6, but 4 is divided to 4a, 4b and 4c. This is score is decided by the radiologist depending on mammographic findings). What I haven't been able to achieve is to link these option groups' results to a table. Because I want to be able to search and classify the patients depending on their BI-RADS score and mammographic finding. I also want to create a text message summarizing the choices made by the pyhsician: For example if the physician choose asymetrical opacity and BI-RADS 3, I want a text box to display "The mammogram is evaluated as BI-RADS 3 because of asymetrical opacity."
So, these are my current problems. Thank you very much.
I am a radiologist. I work at a medical faculty as the responsable for mammographic examinations. My former collegues didn't use any form of database to archive mammography reports but I want to create a Access Database to achieve this purpose. As I am a doctor, I don't have a lot of experience in database creation. So any help will be appreciated.
So far I created (with Access 2000) the part required for patient demographics (name, ID number. adress, etc). This part is relatively easy. I just created tables with the required fields and used a wizard in form generator to create a form. The harder part for me is the creation of the mammography results. I want the other physicians to be able to enter results as fast and as easily as possible. For this purpose I created option groups. One option group consists of 4 options detailing the mammpgraphic finding (mass, asymetical opacity, microcalcification, parenchymal distortion), the other option group is the BI-RADS score (a score which can be between 0 and 6, but 4 is divided to 4a, 4b and 4c. This is score is decided by the radiologist depending on mammographic findings). What I haven't been able to achieve is to link these option groups' results to a table. Because I want to be able to search and classify the patients depending on their BI-RADS score and mammographic finding. I also want to create a text message summarizing the choices made by the pyhsician: For example if the physician choose asymetrical opacity and BI-RADS 3, I want a text box to display "The mammogram is evaluated as BI-RADS 3 because of asymetrical opacity."
So, these are my current problems. Thank you very much.