Topics Search

Standard responses

Standard responses
Views: 0
On a number of my forms, I have preferred or standardised text for responses under different circumstances (ie if "this" type "ABC"; if "that" type "XYZ").

I have saved these in autocorrect; however, autocorrect is machine based coding. If I type "STBC" I get "search to be conducted", but no-one else using the database will.

I'm wondering is there a way to (ie how do you) program autocorrect functionality that is part of the database, rather than part of the user's Office settings
Sponsored Links:

More topics


Report that returns the percentage of complete vs. incomplete responses

The responses are captured via yes/no check boxes with a checkbox for YES, NO, and NA.

I'm trying to create a report that returns the percentage of complete vs. incomplete responses:

1 100% 0% 50%
2 50% 50% 0%
3 NA NA 100%
4 100% 0% 0%
5 NA NA 100%

I can't figure out how to make the report generate "NA" for the YES and NO fields on questions who's responses are NA (questions 3 & 5 above).

I need to show questions that are NA without those #VALUE! deals all over the place.

Storing Responses

In part I of our case study, we examine one possible means of storing both single and multiple option form responses within the same data table.

Survey Database Design - hit a snag

I am working on a Survey / Questionnaire database and have hit a roadblock. I am trying to follow a design that mirrors the At Your Survey database in Roger's Access Library that has been recommended on these forums.

jpg (zipped since forum says new users can't post images) with the current relationship structure that I have. I have removed the Surveys table as there isn't a need formore than one survey any time soon.

Many of the survey questions are set up in sets like below (example only). Each question (Fruit 1-3) uses the same list of possible responses and the responses need to be ranked (Fruit 1= most preferred fruit, Fruit 3 = Least preferred).
List Your Top Three Fruits
Fruit 1: Apple
Fruit 2: Pear
Fruit 3: Orange

Because of this, I have set up an extra table with question categories. Otherwise, I would be storing a lot of redundant values if I had a table with only the QuestionID and PossibleResponses (some sets of questions will ask for as many as ten user responses that use the same set of possible responses)

I want to be able to join the Possible Responses table (SrvQPosResponses) to the table where the Survey Responses are stored (SrvResponses).

The At Your Survey database does not join these two. Don't I want to join them so that if I change a possible response, it will be updated in the survey responses as well (say if I want to rename Apple to Apples).

Count responses based on entires of other table

I want to do a query that counts the responses in one table that match the values of another table. So, for example

Table Options

Table Responses
OrderNum Color
12 Blue
21 Blue
33 Red

So, I want a query that outputs:
Blue 2
Green 0
Red 1

So far I've only built queries using Query Wizard (so SQL code still reads like Greek to me

Multiple Message box responses

Could someone please tell me how I can handle responses to various msgbox's.

At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next.

So in my case

if they answer
Q1 with yes they get Q2

if they answer
Q2 with Yes form does its normal thing


If they answer
Q1 with No they get Q3

If the answer
Q2 with no they get Q3

And finally

If they answer Q3 with Yes or No form does its normal thing!

I have tried numerous ways to sort these responses and am even confusing myself ! I have tried using the Elseif but to be honest Im not 100% sure I am using it right as depending where I put it in the order of the code it will work but the Questions then don't come up

How do I show only aggregate data for survey responses?

I'm trying to develop an Access 2007 report that will allow me to analyze and aggregate raw survey Monkey survey data without displaying the individual responses to each question.

The structure of the data is as follows:
Each respondent's survey is on a separate row
Each column contains the answer to a single question
All answers are constrained to a list of choices (e.g., Best, Bad, What I'd like to do is to build a report that shows the percentage of responses to each question. So, for example:
Question #1: What did you think of our product?
Best: 25%
Good: 50%
Bad: 25%
Poor: 0%

chart with multiple serieS

I am developing a survey application that has 4 questions with responses. the responses are strongly disagree, disagree, agree and strongly agree. I would like to make a chart of some type in access that would show the over breakdown of the questions and the total answers.

I was thinking something like a bar chart that would have the names of the questions along the x axis and a count of the responses along the y axis.

each question would have 4 bars one for each of the answers (strongly disagree, disagree, agree and disagree). the aim would be to allowmanagement to see where the strong points and weak points across the board.

Counting similar responses from Multiple fields; output into a crosstab type view

I would like to take a table of data (example below with four rows of responses) as such:

Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good

and turn it to a crosstab type output that groups the responses of conditions to resemble the following:

.Windows; Tires; Interior
Fair ; 1 ; 0 ; 2

Comparing values from different records

I'm not sure exactly what is the best way to do this, so I have this under queries . I have a listing of survey responses from year A. I have another listing of survey responses from year B. Both are in the same table with a unique record - names and years are separate related tables. What I need to be able to do is find out if each individual's answers to questions X and Y changed from year A to year B and then count how many changed. In other words, I need a way to say that # individuals changed their answer in question X and Y from year A to B. Is there a way to query this

Unlocking standard form layout

I'm trying to figure out how to unlock access' standard form lay out with one column to have multiple columns See image below. I would think this would be fairly easy, but I can't move theboxes out of their standard layout.

Blue = Field

Orange = txt box