Assigning keywords to long text fields.

[mdv1978]

We are wanting to use Access to store the results of and analyze a survey. This survey has a lot of open-ended questions would longer text. So we would be using a larger type text field, like a memo field.

My question is this: is there a way to assign keywords (tags) to the data of these longer text fields?

The functionality would be like in Evernote, where you can assign keywords to each note.

Thanks!
Mark

[Robeen]

Hi Mark,

I am not familiar with assigning keywords and how that is done - but . . .
Is assigning the keywords something that is done manually - by someone involved in analyzing the survey?

If so - you could make a separate Table that has a field in it that will tie it back to the record in your table that has the Memo field[s] in it with the open ended answers - and also has a field in it for keywords.

So - for instance - if you have a 'SurveyID' field in the table with the long answers - then your new table would also have a SurveyID field.
It would also have field [you could call it 'Keyword'] in which you could put one of your keywords.
There would be one row of data in this new table for each keyword and each row would have a SurveyID and a keyword.

Another thing I'm not sure you have considered . . .
Even though you have long answers in your Memo fields - it is still possible to write a Query that searches through every record in your main SurveyTable and looks for a given set of keywords in the Memo field[s].

Also - you can create a Form in which you allow Users to select either from a pre-determined list [the programmer will determine this] of key words from one or more drop-down Combo Box controls - or just enter their own key words in one or more Text fields and then you could have a command button that executes code that searches for those keywords in the Memo fields.

There are probably other ways too . . . depends on how you want to do it.