Patient Surveys
 
General
Q: Some patients don't seem receptive or just don't fill out the survey. Any advice?
A: There will always be some patients who are too ill or tired or just don't want to be bothered to fill out a survey. I have offered to read the survey to some patients and find a few who just want to talk. I let them talk and either pass on the survey or fill it out to the extent that the patient is able to give answers.
 
Q: There is no code field on the Patient Survey. How do I match my patient surveys to my medical record audits.
A: We do suggest you use the same patients for records as surveys; however, you do not necessarily need to match them up in the database because there is not a report that does a direct comparison of the two. If you would like to have a code number on the patient surveys just for organizational purposes, it is relatively simple to do:
1. You are adding a field that is text criteria so that you can enter both numbers and letters. In design view of the Patient Survey table, scroll to the bottom and add "Code" as the last Field Name, choose Text as the Field Type. Close and Save the table.
2. Open the Medical Record Audit Data Entry Form in Design View and under View, choose Field List.
3. Scroll to the bottom of the field list and drag the Code field from the list to the form where you want it to sit. You can move the new field and its label by moving your cursor over the field until it changes into a hand, then grab and move the field.
4. For a more detailed explanation of how to add new fields, use these instructions.
 
Q: Can I put the database on my network?
A: You'll have to ask your network administrator if they'll allow you to put it on the network. If they will, you certainly can put it in a shared file, however more than one person cannot enter data at the same time.

Q: The database won't load. It says unrecognizable format.

A: The version of the database you must use depends on which version of Access you have on your machine. If you have Access 97, you need to use the Pain QI Database 1997. If you have Access 2000, you need to use the Pain QI Database 2000. There is NO difference in content, each is just formatted for a specific version of Access.
 
Q: How do I import the data from my old database into the new version?
A: Here are the instructions.
 
Q: I've loaded the database and now I can't enter data because it says the database is Read Only.
A: Instructions were included with the CD on how to make the database not Read Only. Here's a repeat of those instructions:
ATTENTION: The database as it appears on the CD is Read Only. In order to make it accessible for data entry and reporting, you MUST copy it onto your hard drive using the following steps.
1. Open the CD ROM and find the database in the Database folder.
2. Drag the icon of the database you will be using, either 1997 (Pain QI Database 1997) or 2000 (Pain QI Database) to your desktop or to the folder in which you wish it to be located.
3. Wait for the file to copy. This may take a few minutes.
4. Right click on the database icon that you have copied to your computer.
5. A menu should pop up; choose Properties from this menu.
6. In the Properties screen that appears, uncheck the Read Only box at the bottom.
You are now free to enter data, create reports, and make changes to the database.


Q: I want to add questions to the Patient Survey. How do I reflect this in the Database?
A: Use these instructions.
 

Q: I'm concerned that if I make changes in the database, I won't be able to use any other updates that you might produce, and that my data will be different from everyone else's so that it cannot be compared.
A: It is true that people that make changes to their database will not be able to use the “quick fix” updates that are sent out. In these cases, outlined instructions on how to make the updates will be given. This database is a template, so we anticipate and encourage that people make changes to fit their needs. If you feel that integrating your changes and our suggestions is to complex, we encourage you to use another method of monitoring your progress. That brings me to the second point: data submission. Submission of data is completely voluntary, so we do not expect to get everyone's data. The data that we do receive will most definitely vary in content, either because people have made changes to the design of the database, or because people have interpreted and answered questions differently. As mentioned in other questions, how you answer some of the questions is up to you. This will result in many different answers to a single question. Therefore, when we do collect data, all who submit their data will be asked to fill out a short questionnaire on how they changes/altered the database, so we can compare answers and usage.
 
Question 1
Q: On the Patient Survey, if the answer to question #1 is no, the patient is directed to stop there. Should the surveys with a NO answer be entered into the database, and if those patients continued to fill out the survey, should those values be entered?
A:  NO, do not enter data from patients who indicate they did not have pain in the first 24 hours. That question is intended as a screening question. You can use it if you like to say what percent of patients report pain in first 24 hours. For example if you knock on 100 doors and 20 patients state NO (and return the uncompleted survey hopefully) you have an 80% incidence of pain with a convenience sample.

Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Yes answers, divided by the total number of record (surveys)
Yes:  =(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))/(DCount("[ID]","Pt Survey))
No:  =(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=0"))/(DCount("[ID]","Pt Survey))
If you do screen for patients who have pain, your Yes percentage should be 100% and your no percentage should be 0%.
 
Question 2
Q: What does the average on the Patient Survey Summary represent?
A: The average on the Patient Survey Summary represents the average of all answers to this question, including 0s. The equation is as follows:
=DAvg("[RATE_NOW]","Pt Survey")

Q: I'm afraid that the average on the Patient Survey Summary doesn't represent the correct population, especially if people who didn't have pain answered this question with 0s.
A: As mentioned above, Question 1 should be used as a screening question, and we suggest not entering patients who didn't have pain. If you do enter those records, your averages will be of the entire population. To limit them to only those patients that answered Yes to the first question (this may also help guard against data entry mistakes), change the equation to the following:
=DAvg("[RATE_NOW]","Pt Survey","[EXP_PAIN]=1")

Question 3
Q: What does the average on the Patient Survey Summary represent?
A: The average on the Patient Survey Summary represents the average of all answers to this question, including 0s. The equation is as follows:
=DAvg("[R_WORST]","Pt Survey")

Q: I'm afraid that the average on the Patient Survey Summary doesn't represent the correct population, especially if people who didn't have pain answered this question with 0s.
A: As mentioned above, Question 1 should be used as a screening question, and we suggest not entering patients who didn't have pain. If you do enter those records, your averages will be of the entire population. To limit them to only those patients that answered Yes to the first question (this may also help guard against data entry mistakes), change the equation to the following:
=DAvg("[R_WORST]","Pt Survey","[EXP_PAIN]=1")

Question 4
Q: What does the average on the Patient Survey Summary represent?
A: The average on the Patient Survey Summary represents the average of all answers to this question, including 0s. The equation is as follows:
=DAvg("[R_LEAST]","Pt Survey")

Q: I'm afraid that the average on the Patient Survey Summary doesn't represent the correct population, especially if people who didn't have pain answered this question with 0s.
A: As mentioned above, Question 1 should be used as a screening question, and we suggest not entering patients who didn't have pain. If you do enter those records, your averages will be of the entire population. To limit them to only those patients that answered Yes to the first question (this may also help guard against data entry mistakes), change the equation to the following:
=DAvg("[R_LEAST]","Pt Survey","[EXP_PAIN]=1")

 
Question 5
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Always answers, divided by the total number of record (surveys)
Always:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=1"))/(DCount("[ID]","Pt Survey"))
Almost Always:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=2"))/(DCount("[ID]","Pt Survey"))
Often:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=3"))/(DCount("[ID]","Pt Survey"))
Almost Never:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=4"))/(DCount("[ID]","Pt Survey"))
Never:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=5"))/(DCount("[ID]","Pt Survey"))

Q: My percentages don't add up correctly - could it be that the people who said they didn't have pain (Question 1) answered this question?
A: That is exactly what is going on. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right.  Either that or some records left this answer blank. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
Always:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=1 And [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Almost Always:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=2 And [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Often:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=3 And [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Almost Never:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=4 And [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Never:  =(DCount("[F_MODSEV]","Pt Survey","[F_MODSEV]=5 And [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
 
Question 6
Q: How should Question #6 be answered if a patient is either incapable of performing a function or unable to identify their level of pain for that function?
A: Patients should be instructed to leave those items on question #6 blank. In other words, if they are bedridden or have NG, etc., they should just not answer those parts of the question.

Q: Some patients have trouble answering the question about pain interfering with their ability to walk or eat when they are not allowed to do those activities yet. Some have left it blank, others put no, others put N/A. How should this be handled?
A: Our preference is to instruct patients to leave this blank. If they answer 0, this will affect your mean. 


Q: What do the averages on the Patient Survey Summary represent?
A: The averages on the Patient Survey Summary represent the average of all answers to each question, including 0s. The equations are as follows:
Gen Activity:  =DAvg("[INT_ACT]","Pt Survey")
Mood:  =DAvg("[INT_MOOD]","Pt Survey")
Walking:  =DAvg("[INT_WALK]","Pt Survey")
Eating:  =DAvg("[INT_EAT]","Pt Survey")
Sleep:  =DAvg("[INT_SLEP]","Pt Survey")
Coughing:  =DAvg("[INT_CDB]","Pt Survey")

Q: I'm afraid that the averages on the Patient Survey Summary don't represent the correct population, especially if people who didn't have pain answered these questions with 0s.
A: As mentioned above, Question 1 should be used as a screening question, and we suggest not entering patients who didn't have pain. If you do enter those records, your averages will be of the entire population. To limit them to only those patients that answered Yes to the first question (this may also help guard against data entry mistakes), change the equations to the following:
Gen Activity:  =DAvg("[INT_ACT]","Pt Survey","[EXP_PAIN]=1")
Mood:  =DAvg("[INT_MOOD]","Pt Survey","[EXP_PAIN]=1")
Walking:  =DAvg("[INT_WALK]","Pt Survey","[EXP_PAIN]=1")
Eating:  =DAvg("[INT_EAT]","Pt Survey","[EXP_PAIN]=1")
Sleep:  =DAvg("[INT_SLEP]","Pt Survey","[EXP_PAIN]=1")
Coughing:  =DAvg("[INT_CDB]","Pt Survey","[EXP_PAIN]=1")
 
Question 7
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Yes answers, divided by the total number of record (surveys)
Yes:  =(DCount("[S_E]","Pt Survey","[S_E]=1"))/(DCount("[ID]","Pt Survey))
No:    =(DCount("[S_E]","Pt Survey","[S_E]=0"))/(DCount("[ID]","Pt Survey))
The individual choices are the number of answers divided by the number of records that had side effects (previous question is answered Yes).
Drowsiness:  =(DCount("[DROWSY]","Pt Survey","[DROWSY]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Nausea:  =(DCount("[N_V]","Pt Survey","[N_V]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Constipation:  =(DCount("[CONSTIP]","Pt Survey","[CONSTIP]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Itchiness:  =(DCount("[ITCHY]","Pt Survey","[ITCHY]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Other:  =(DCount("[OTHER]","Pt Survey","[OTHER]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))

Q: I want to change the equations so that they show percentages of only those records that had both the individual side effect AND the side effect question answered Yes.
A: If you are afraid that data entry will not be done correctly and people will answer Yes to the individual side effects without answering Yes to the original side effects question, you can change the equations to the following:
Drowsiness:  =(DCount("[DROWSY]","Pt Survey","[DROWSY]=1 AND [S_E]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Nausea:  =(DCount("[N_V]","Pt Survey","[N_V]=1 AND [S_E]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Constipation:  =(DCount("[CONSTIP]","Pt Survey","[CONSTIP]=1 AND [S_E]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Itchiness:  =(DCount("[ITCHY]","Pt Survey","[ITCHY]=1 AND [S_E]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))
Other:  =(DCount("[OTHER]","Pt Survey","[OTHER]=1 AND [S_E]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1"))

Q: My percentages don't add up correctly - could it be that the people who said they didn't have pain (Question 1) answered this question?
A: That is exactly what is going on. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right.  Either that or some records left this answer blank. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
Yes:  =(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
No:    =(DCount("[S_E]","Pt Survey","[S_E]=0 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))

Drowsiness:  =(DCount("[DROWSY]","Pt Survey","[DROWSY]=1 AND [S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))
Nausea:  =(DCount("[N_V]","Pt Survey","[N_V]=1 AND [S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))
Constipation:  =(DCount("[CONSTIP]","Pt Survey","[CONSTIP]=1 AND [S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))
Itchiness:  =(DCount("[ITCHY]","Pt Survey","[ITCHY]=1 AND [S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))
Other:  =(DCount("[OTHER]","Pt Survey","[OTHER]=1 AND [S_E]=1 AND [EXP_PAIN]=1"))/(DCount("[S_E]","Pt Survey","[S_E]=1 AND [EXP_PAIN]=1"))

 
Question 8
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Yes answers, divided by the total number of record (surveys)
Yes:  =(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))/(DCount("[ID]","Pt Survey"))
No:  =(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))/(DCount("[ID]","Pt Survey"))
The percentages for the individual non-drug methods represent the count of Yes answers to each question, divided by the number of records that answered Yes to the previous question (did you use any non-drug methods).
Relaxation:  =(DCount("[relaxa]","Pt Survey","[relaxa]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Mediation:  =(DCount("[Medita]","Pt Survey","[Medita]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Heating Pad:  =(DCount("[Heating]","Pt Survey","[Heating]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Cold Pack:  =(DCount("[Ice]","Pt Survey","[Ice]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Walking:  =(DCount("[Walking]","Pt Survey","[Walking]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Imagery:  =(DCount("[Images]","Pt Survey","[Images]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Therapeutic Touch:  =(DCount("[Thertuch]","Pt Survey","[Thertuch]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Deep Breathing:  =(DCount("[Dbreathe]","Pt Survey","[Dbreathe]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Other:  =(DCount("[N_other]","Pt Survey","[N_other]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))

Q: I want to change the equations so that they show percentages of only those records that had both the individual non-drug method AND the non-drug method question answered Yes.
A: If you are afraid that data entry will not be done correctly and people will answer Yes to the individual side effects without answering Yes to the original side effects question, you can change the equations to the following:
Relaxation:  =(DCount("[relaxa]","Pt Survey","[relaxa]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Mediation:  =(DCount("[Medita]","Pt Survey","[Medita]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Heating Pad:  =(DCount("[Heating]","Pt Survey","[Heating]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Cold Pack:  =(DCount("[Ice]","Pt Survey","[Ice]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Walking:  =(DCount("[Walking]","Pt Survey","[Walking]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Imagery:  =(DCount("[Images]","Pt Survey","[Images]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Therapeutic Touch:  =(DCount("[Thertuch]","Pt Survey","[Thertuch]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Deep Breathing:  =(DCount("[Dbreathe]","Pt Survey","[Dbreathe]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))
Other:  =(DCount("[N_other]","Pt Survey","[N_other]=1 AND [NON_DRUG]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1"))

Q: My percentages don't add up correctly - could it be that the people who said they didn't have pain (Question 1) answered this question?
A: That is exactly what is going on. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right.  Either that or some records left this answer blank. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
Yes:  =(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
No:  =(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[ID]","Pt Survey","[EXP_PAIN]=1"))
Relaxation:  =(DCount("[relaxa]","Pt Survey","[relaxa]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Mediation:  =(DCount("[Medita]","Pt Survey","[Medita]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Heating Pad:  =(DCount("[Heating]","Pt Survey","[Heating]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Cold Pack:  =(DCount("[Ice]","Pt Survey","[Ice]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Walking:  =(DCount("[Walking]","Pt Survey","[Walking]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Imagery:  =(DCount("[Images]","Pt Survey","[Images]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Therapeutic Touch:  =(DCount("[Thertuch]","Pt Survey","[Thertuch]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Deep Breathing:  =(DCount("[Dbreathe]","Pt Survey","[Dbreathe]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Other:  =(DCount("[N_other]","Pt Survey","[N_other]=1 AND [NON_DRUG]=1 AND [EXP_PAIN]=1"))/(DCount("[NON_DRUG]","Pt Survey","[NON_DRUG]=1 AND [EXP_PAIN]=1"))
Question 9
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Very Satisfied answers, divided by the total number of record (surveys)
Very Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=1"))/(DCount("[ID]","Pt Survey"))
Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=2"))/(DCount("[ID]","Pt Survey"))
Slightly Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=3"))/(DCount("[ID]","Pt Survey"))
Slightly Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=4"))/(DCount("[ID]","Pt Survey"))
Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=5"))/(DCount("[ID]","Pt Survey"))
Very Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=6"))/(DCount("[ID]","Pt Survey"))

Q: My percentages don't add up correctly - could it be that the people who said they didn't have pain (Question 1) answered this question?
A: That is exactly what is going on. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right. Either that or some records left this answer blank. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
Very Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=2 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Slightly Dissatisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=3 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Slightly Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=4 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=5 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Very Satisfied:  =(DCount("[satis_tx]","Pt Survey","[satis_tx]=6 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
 
Question 10
Q: If I click the wrong answer on 10 and 11, I can't change it without deleting the whole record.
A: Yes you can! Don’t delete the whole record.
1. If you make a mistake, leave your cursor in the mistaken field (so that the option was the last thing selected; select it again if you're not sure).
2. Go to the “View” menu and select “Datasheet. DON’T CLICK ON ANYTHING OR PUT YOUR CURSOR ANYWHERE! The wrong option should be highlighted (your cursor should already be in that field).
3. Delete what is in that field.
4. Go back to the “View” menu and select “Form.” It should bring you back to the record you need with the option erased.

Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of "I didn't have much pain" answers, divided by the total number of record (surveys). Your percentages may not add up to 100% because each patient can check as many answers as are applicable.
I didn't have much pain:  =(DCount("[s_nopain]","Pt Survey","[s_nopain]=1"))/(DCount("[ID]","Pt Survey"))
Pain medicine relieved my pain:  =(DCount("[s_meds]","Pt Survey","[s_meds]=1"))/(DCount("[ID]","Pt Survey"))
I had control over my pain:  =(DCount("[s_contrl]","Pt Survey","[s_contrl]=1"))/(DCount("[ID]","Pt Survey"))
MDs and RNs cared about my comfort:  =(DCount("[s_caring]","Pt Survey","[s_caring]=1"))/(DCount("[ID]","Pt Survey"))
MDs and RNS were prepared:  =(DCount("[s_manage]","Pt Survey","[s_manage]=1"))/(DCount("[ID]","Pt Survey"))
Other:  =(DCount("[s_other]","Pt Survey","[s_other]=1"))/(DCount("[ID]","Pt Survey"))
 

Q: I'm afraid my percentages don't represent the correct population - could it be that people who didn't have pain answered this question?
A: That could be the problem. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
I didn't have much pain:  =(DCount("[s_nopain]","Pt Survey","[s_nopain]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Pain medicine relieved my pain:  =(DCount("[s_meds]","Pt Survey","[s_meds]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
I had control over my pain:  =(DCount("[s_contrl]","Pt Survey","[s_contrl]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
MDs and RNs cared about my comfort:  =(DCount("[s_caring]","Pt Survey","[s_caring]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
MDs and RNS were prepared:  =(DCount("[s_manage]","Pt Survey","[s_manage]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Other:  =(DCount("[s_other]","Pt Survey","[s_other]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Question 11
Q: If I click the wrong answer on 10 and 11, I can't change it without deleting the whole record.
A: Yes you can! Don’t delete the whole record.
1. If you make a mistake, leave your cursor in the mistaken field (so that the option was the last thing selected; select it again if you're not sure).
2. Go to the “View” menu and select “Datasheet. DON’T CLICK ON ANYTHING OR PUT YOUR CURSOR ANYWHERE! The wrong option should be highlighted (your cursor should already be in that field).
3. Delete what is in that field.
4. Go back to the “View” menu and select “Form.” It should bring you back to the record you need with the option erased.
Q: Question 11 on the Patient Survey won't accept text as the explanation to “Other.”
A: This was fixed in the new database, however if you are still having problems:
1. Open the Patient Survey Entry Form in design view.
2. Scroll to Question 11 and select the “Other description” box. When you select it, your cursor WILL NOT appear in the box, however small boxes will appear in each corner.
3. Under the “View” menu, choose “Properties.”
4. In the Properties box, choose the Data tab, and in the Control Source row, use the pull down menu (the pull down will appear if you put your cursor in the row) to choose “Nsatis_other.”
5. Exit the form, and when prompted, Save the form.
 
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of "I had a lot of pain" answers, divided by the total number of record (surveys). Your percentages may not add up to 100% because each patient can check as many answers as are applicable.
I had a lot of pain:  =(DCount("[u_pain]","Pt Survey","[u_pain]=1"))/(DCount("[ID]","Pt Survey"))
Pain medicine did not help:  =(DCount("[u_meds]","Pt Survey","[u_meds]=1"))/(DCount("[ID]","Pt Survey"))
I had no control over my pain:  =(DCount("[u_contrl]","Pt Survey","[u_contrl]=1"))/(DCount("[ID]","Pt Survey"))
MDs and RNs did not car about my comfort:  =(DCount("[u_caring]","Pt Survey","[u_caring]=1"))/(DCount("[ID]","Pt Survey"))
MDs and RNS were not prepared:  =(DCount("[u_manage]","Pt Survey","[u_manage]=1"))/(DCount("[ID]","Pt Survey"))
I had side effects: =(DCount("[u_s_e]","Pt Survey","[u_s_e]=1"))/(DCount("[ID]","Pt Survey"))
Other:  =(DCount("[u_other]","Pt Survey","[u_other]=1"))/(DCount("[ID]","Pt Survey"))
Q: I'm afraid my percentages don't represent the correct population - could it be that people who didn't have pain answered this question?
A: That could be the problem. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
I had a lot of pain:  =(DCount("[u_pain]","Pt Survey","[u_pain]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Pain medicine did not help:  =(DCount("[u_meds]","Pt Survey","[u_meds]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
I had no control over my pain:  =(DCount("[u_contrl]","Pt Survey","[u_contrl]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
MDs and RNs did not car about my comfort:  =(DCount("[u_caring]","Pt Survey","[u_caring]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
MDs and RNS were not prepared:  =(DCount("[u_manage]","Pt Survey","[u_manage]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
I had side effects: =(DCount("[u_s_e]","Pt Survey","[u_s_e]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Other:  =(DCount("[u_other]","Pt Survey","[u_other]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
Question 12
Q: What do the averages on the Patient Survey Summary represent?
A: The averages on the Patient Survey Summary represent the average of all answers to each question, including 0s. The equations are as follows:
Pain meds cannot control pain:  =DAvg("[painmeds]","Pt Survey")
People get addicted:  =DAvg("[addict]","Pt Survey")
Good patients avoid talking about pain:  =DAvg("[avoidtlk]","Pt Survey")
Its easier to put up with it:  =DAvg("[put_up]","Pt Survey")
Complaints waste my doctors time:  =DAvg("[wstetime]","Pt Survey")
Pain meds should be saved:  =DAvg("[savemeds]","Pt Survey")
Pain means the illness is worse:  =DAvg("[more_ill]","Pt Survey")

Q: I'm afraid that the averages on the Patient Survey Summary don't represent the correct population, especially if people who didn't have pain answered these questions with 0s.
A: As mentioned above, Question 1 should be used as a screening question, and we suggest not entering patients who didn't have pain. If you do enter those records, your averages will be of the entire population. To limit them to only those patients that answered Yes to the first question (this may also help guard against data entry mistakes), change the equations to the following:
Pain meds cannot control pain:  =DAvg("[painmeds]","Pt Survey","[EXP_PAIN]=1")
People get addicted:  =DAvg("[addict]","Pt Survey","[EXP_PAIN]=1")
Good patients avoid talking about pain:  =DAvg("[avoidtlk]","Pt Survey","[EXP_PAIN]=1")
Its easier to put up with it:  =DAvg("[put_up]","Pt Survey","[EXP_PAIN]=1")
Complaints waste my doctors time:  =DAvg("[wstetime]","Pt Survey","[EXP_PAIN]=1")
Pain meds should be saved:  =DAvg("[savemeds]","Pt Survey","[EXP_PAIN]=1")
Pain means the illness is worse:  =DAvg("[more_ill]","Pt Survey","[EXP_PAIN]=1")
 

Question 13
Q: What do the percentages on the Patient Survey Summary represent?
A: The percentages represent the number of records that had that particular answer, divided by the total number of records. So, for example the number of Yes answers, divided by the total number of record (surveys)
Yes:  =(DCount("[tx_imp]","Pt Survey","[tx_imp]=1"))/(DCount("[ID]","Pt Survey))
No:    =(DCount("[tx_imp]","Pt Survey","[tx_imp]=1"))/(DCount("[ID]","Pt Survey))

Q: My percentages don't add up correctly - could it be that the people who said they didn't have pain (Question 1) answered this question?
A: That is exactly what is going on. We suggest you use Question 1 as a screening question. If the patient didn't have pain, they shouldn't answer the rest of the questions. And thus, they shouldn't be entered into the database. If they are, your percentages won't be right.  Either that or some records left this answer blank. If you are worried about this and don't have time to check all data, you can change all of your percentages to be the following:
Yes:  =(DCount("[tx_imp]","Pt Survey","[tx_imp]=1 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
No:    =(DCount("[tx_imp]","Pt Survey","[tx_imp]=0 AND [EXP_PAIN]=1"))/(DCount("[EXP_PAIN]","Pt Survey","[EXP_PAIN]=1"))
 
Patient Survey Data Entry Form
Q: When I click the buttons at the top of the screen for previous record, new record, etc., nothing happens.
A: If the buttons at the top of the screen don't work, use the buttons at the bottom of the screen.
Text Box:
<Previous record
|<First record
>Next record
>|Last record
>*New record
 
Q: When I try to go to the next record it reads “Data Set Full.”
A: There are two options with this problem.
1. First try using the buttons at the bottom of the screen to move from record to record instead of the buttons at the top (see previous question).
2. If that doesn't help things, it could be that your computer doesn't have enough memory to support the program. Check with your I/S department.
 
Q: I've entered all my records and now I can't go back and edit them.
A: There are two possible solutions to this problem:
1. The buttons at the top of the screen that help you move between records aren't working properly.
If this is the case, the correct number of forms will appear after the “of” at the very bottom of the screen.
2. If the correct number of forms does not appear at the bottom of the form (like below)
Text Box:
there is probably a filter that has there is probably a filter that has accidentally been turned on. Make sure the funnel like commands at the top of the screen (like those at the right) aren't punched in. If they are, click on them again and all your records should come back.
Text Box:
3. Use the buttons at the bottom of screen to move from record to record.
 
Q: Some patients don't seem receptive or just don't fill out the survey. Any advice?
A: There will always be some patients who are too ill or tired or just don't want to be bothered to fill out a survey. I have offered to read the survey to some patients and find a few who just want to talk. I let them talk and either pass on the survey or fill it out to the extent that the patient is able to give answers.
 
Q: There is no code field on the Patient Survey. How do I match my patient surveys to my medical record audits.
A: We do suggest you use the same patients for records as surveys; however, you do not necessarily need to match them up in the database because there is not a report that does a direct comparison of the two. If you would like to have a code number on the patient surveys just for organizational purposes, it is relatively simple to do:
1. You are adding a field that is text criteria so that you can enter both numbers and letters. In design view of the Patient Survey table, scroll to the bottom and add "Code" as the last Field Name, choose Text as the Field Type. Close and Save the table.
2. Open the Medical Record Audit Data Entry Form in Design View and under View, choose Field List.
3. Scroll to the bottom of the field list and drag the Code field from the list to the form where you want it to sit. You can move the new field and its label by moving your cursor over the field until it changes into a hand, then grab and move the field.
4. For a more detailed explanation of how to add new fields, use theses instructions.
 
Q: I'd like to add questions to the database, how do I do that?
A: You can definitely add whatever you want to the database. I would first contact someone in your IS department or get out the Microsoft Access User's Manual to help. Check out these instructions. The steps are the same.
 
Q: If I click the wrong answer on 10 and 11, I can't change it without deleting the whole record.
A: Yes you can! Don’t delete the whole record.
1. If you make a mistake, leave your cursor in the mistaken field (so that the option was the last thing selected; select it again if you're not sure).
2. Go to the “View” menu and select “Datasheet. DON’T CLICK ON ANYTHING OR PUT YOUR CURSOR ANYWHERE! The wrong option should be highlighted (your cursor should already be in that field).
3. Delete what is in that field.
4. Go back to the “View” menu and select “Form.” It should bring you back to the record you need with the option erased.

Q: Question 11 on the Patient Survey won't accept text as the explanation to “Other.”

A: This was fixed in the new database, however if you are still having problems:
1. Open the Patient Survey Entry Form in design view.
2. Scroll to Question 11 and select the “Other description” box. When you select it, your cursor WILL NOT appear in the box, however small boxes will appear in each corner.
3. Under the “View” menu, choose “Properties.”
4. In the Properties box, choose the Data tab, and in the Control Source row, use the pull down menu (the pull down will appear if you put your cursor in the row) to choose “Nsatis_other.”
5. Exit the form, and when prompted, Save the form.
Patient Survey Summary
Q: On the Patient Survey Summary, what does the number after Count represent?
A: That represents the number of records you have entered. It does NOT count records that have been deleted. So, for instance, if the ID number of the last record entered is 138, but you've deleted 10 records, the count will say 128. It does not use the last ID number as an indicator.

Q: My percentages add up to less than 100%.

A: This means data entry wasn't done correctly. Go back and make sure all those answers that were supposed to be filled in are filled in. Make data entry changes as needed. Don't fill in side effect choices if there were no side effects. 
 
Q: What do the percentages on the Patient Survey Summary represent?
A: Look above at each individual question to find out what the percentages represent, and what the equations are.