If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can access 2007 do what I need?
I would be grateful for some help!
I need to create a program that can calculate a score based on data entered by the user. The user will need to enter data from patients with coronary disease. The first question will be "how many coronary narrowings are present" Then there will need to be a series of questions for each coronary narrowing. So if there are 3 narrowings, then the program will need to go through a series of "sub-questions" for each coronary narrowing. when it has finished the questions on the 1st narrowing, then it will ask the same sub questions for the 2nd narrowing and then the 3rd. At the end it will need to calculate a score based on the answers to the questions. For example Question 1: How many narrowings are there? Answer 2 Narrowing 1: Question 1.1: Which artery does it affect. Answer: Left coronary Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes Narrowing 2: Question 2.1: Which artery does it affect. Answer: Right coronary Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No Score calculation: If Question 1.1 = L coronary then multiply by score by 5 If Question 1.1 - Right coronary then multiply score by 3 If Question 1.2 = Yes then score 5, If = No then score 2 Based on the calculation algorithm the score for narrowing 1 would be 5x5=25 and for narrowing 2 would be 3x2=6 Can anyone tell me whether access 2007 can deal with this sort of problem. If so, how best do I get started, if not which program can I use? Many thanks JD |
#2
|
|||
|
|||
Can access 2007 do what I need?
On Feb 8, 12:59*pm, JRD wrote:
I would be grateful for some help! I need to create a program that can calculate a score based on data entered by the user. The user will need to enter data from patients with coronary disease. The first question will be "how many coronary narrowings are present" Then there will need to be a series of questions for each coronary narrowing. So if there are 3 narrowings, then the program will need to go through a series of "sub-questions" for each coronary narrowing. when it has finished the questions on the 1st narrowing, then it will ask the same sub questions for the 2nd narrowing and then the 3rd. At the end it will need to calculate a score based on the answers to the questions. For example Question 1: How many narrowings are there? Answer 2 Narrowing 1: Question 1.1: Which artery does it affect. Answer: Left coronary Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes Narrowing 2: Question 2.1: Which artery does it affect. Answer: Right coronary Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No Score calculation: If Question 1.1 = L coronary then multiply by score by 5 If Question 1.1 - Right coronary then multiply score by 3 If Question 1.2 = Yes then score 5, If = No then score 2 Based on the calculation algorithm the score for narrowing 1 would be 5x5=25 and for narrowing 2 would be 3x2=6 Can anyone tell me whether access 2007 can deal with this sort of problem.. If so, how best do I get started, if not which program can I use? Many thanks JD Hi, Sure you can do it using Access if you know how. I think the best way to do it is to have a table with answers related to patient. When user say there are 2 narrowings, write 2 records into this table with patient ID. Now all you need to do is to run form filtered to the patient ID and the form will show 2 records. You will need to design the form to contain 2 questions/answers per record. It is up to you how you will lead/force user to go from record one to last record (that is record 2 in this case), to make sure that user provide all answers. When both questions for both records are answered, you can run calculation. No need to store result of calculation in DB as you can always re-calculate it for reporting purposes. However, this program will require advanced Access programing knowledge; depending on design, how to deploy queries and/or VBA program, but still I think the Access is the easiest program to do it. Regards, Branislav Mihaljev Microsoft Access MVP |
#3
|
|||
|
|||
Can access 2007 do what I need?
JRD wrote:
I would be grateful for some help! I need to create a program that can calculate a score based on data entered by the user. The user will need to enter data from patients with coronary disease. The first question will be "how many coronary narrowings are present" Then there will need to be a series of questions for each coronary narrowing. So if there are 3 narrowings, then the program will need to go through a series of "sub-questions" for each coronary narrowing. when it has finished the questions on the 1st narrowing, then it will ask the same sub questions for the 2nd narrowing and then the 3rd. At the end it will need to calculate a score based on the answers to the questions. For example Question 1: How many narrowings are there? Answer 2 Narrowing 1: Question 1.1: Which artery does it affect. Answer: Left coronary Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes Narrowing 2: Question 2.1: Which artery does it affect. Answer: Right coronary Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No Score calculation: If Question 1.1 = L coronary then multiply by score by 5 If Question 1.1 - Right coronary then multiply score by 3 If Question 1.2 = Yes then score 5, If = No then score 2 Based on the calculation algorithm the score for narrowing 1 would be 5x5=25 and for narrowing 2 would be 3x2=6 Can anyone tell me whether access 2007 can deal with this sort of problem. If so, how best do I get started, if not which program can I use? Many thanks JD Here are my initial thoughts: You'll want a table with patient records (name, age, whatever). Also a table for narrowings, related to the Patient table by PatientID - a one-to-many relationship set up in the Relationships window. If you've correctly linked the tables (be sure to use the same field name for the Primary Key of the Patients table and the Foreign Key in the Narrowings table, and I'd suggest you use an Autonumber for the former and a Long Integer for the latter), then Access will recognise the relationship when you "Create a form with Subform" (look that up in Help). You'll need to run the Wizard a few times to get it laid out right, but you should end up with a form showing patients and within it a subform showing the various fields for Narrowings. Don't bother trying to tell the system first that Patient X has 3 narrowings; just add three Narrowings records against that patient in the subform. Once you have the data entered, you can use VBA logic to calculate the scores. I guess you'd create a query to calculate the score for each narrowing as a calculated field (play with the Expression Builder - well worth the time spent understanding it). Then you'd create a report on that query which would provide an opportunity to sum the scores for a patient in the report footer. You could also turn on grouping by PatientID and sum scores for each patient in a report which showed all patients. Do this in stages: 1) Most important - get your tables right. Ignore calculations at this stage; you're just trying to set up tables to store the raw data. Post a description here as a followup to this thread. You can use the built-in Documenter to describe your tables. 2) Then get your form/subform right. If you go about it the right way, Access's Form Wizard will do all the hard work for you! You should be able to enter all patient data at the end of this step. 3) Then get a query built with a "calculated field" which will display the score for each narrowing according to the medical rules you've devised. This query will be based on both Patient and Narrowing tables. The Expression Builder will help you find and use functions like IFF, and express your basic arithmetical calculations. 4) Build your report on this query using the Report Wizard, and marvel at your handiwork. Access is just great for this sort of stuff. Post for help or comments here at each stage if you need to. This is one of the best newsgroups anywhere in terms of expertise and helpfulness, and you'll get a lot of help. I'm certainly not an expert, and I'm learning constantly just reading the replies to other people's questions! Phil, London |
Thread Tools | |
Display Modes | |
|
|