Microsoft Access for the Analysis of Open-ended Responses in Questionnaires and Interviews

Structured interviews or questionnaires often comprise open-ended questions, especially to obtain additional information from the interviewee not covered by standardised questions. Ordinarily, the analysis of these open-ended questions cannot be undertaken by the same computer program, in which quan...

Full description

Saved in:
Bibliographic Details
Published in:Forum, qualitative social research Vol. 3; no. 2
Main Authors: Meyer, Thorsten, Gruppe, Harald, Franz, Michael
Format: Journal Article
Language:English
German
Published: Berlin Freie Universität Berlin 01.05.2002
FQS
Subjects:
Access
Computer Assisted Research
Content analysis
Data
Data quality
Exports
inter-coder reliability
Interviews
Mental Patients
Methodological Problems
MS Access
open-ended response format
Patient satisfaction
Property
psychiatric patients
Quality of life
Quantitative analysis
Quantitative Methods
Questionnaires
Reliability
Satisfaction
Schizophrenia
Software
SPSS
Statistical analysis
Visual Basic
ISSN:1438-5627, 1438-5627
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Structured interviews or questionnaires often comprise open-ended questions, especially to obtain additional information from the interviewee not covered by standardised questions. Ordinarily, the analysis of these open-ended questions cannot be undertaken by the same computer program, in which quantitative data is entered and managed, which impedes the combination of open-ended and closed answer formats. The usage of the database management program Microsoft Access is widespread. It allows for various ways of entering quantitative data, of data management and data export. The entry of text material is convenient and almost unrestricted due to memo-format variables. Given the possibility to manage quantitative and qualitative data with the same computer software, we tried to use the programming properties of MS Access (Visual Basic with MS-Access-supplements) for the purpose of content analysis. The present paper comprises a description of the construction of data tables, queries, code lists and data entry forms. In addition, the construction of coding units (paraphrasing of text data), the coding process and the restructuring for subsequent statistical analysis is illustrated. In addition, the export of data into the statistical software package SPSS and the analysis of inter-coder reliability are discussed. This is based on the data collected from open-ended quality of life interviews with chronic schizophrenic persons and a paper-pencil assessment of patient satisfaction during a psychiatric hospital stay. URN: urn:nbn:de:0114-fqs0202206
Bibliography:ObjectType-Case Study-2
SourceType-Scholarly Journals-1
content type line 14
ObjectType-Report-1
ObjectType-Article-1
ObjectType-Feature-2
content type line 23
ISSN:1438-5627
1438-5627