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...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Forum, qualitative social research Ročník 3; číslo 2
Hlavní autoři: Meyer, Thorsten, Gruppe, Harald, Franz, Michael
Médium: Journal Article
Jazyk:angličtina
němčina
Vydáno: Berlin Freie Universität Berlin 01.05.2002
FQS
Témata:
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
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Abstract 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
AbstractList Structured interviews or questionnaires often comprise open-ended questions, especially to obtain additional information from the interviewee not covered by standardized questions. Ordinarily, the analysis of these open-ended questions cannot be undertaken by the same computer program, in which quantitative data is entered & managed, which impedes the combination of open-ended & 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 & data export. The entry of text material is convenient & almost unrestricted due to memo-format variables. Given the possibility to manage quantitative & 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 & data entry forms. In addition, the construction of coding units (paraphrasing of text data), the coding process & the restructuring for subsequent statistical analysis is illustrated. In addition, the export of data into the statistical software package SPSS & 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 & a paper-pencil assessment of patient satisfaction during a psychiatric hospital stay. 5 Figures, 7 References. Adapted from the source document.
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
Author Franz, Michael
Meyer, Thorsten
Gruppe, Harald
Author_xml – sequence: 1
  givenname: Thorsten
  surname: Meyer
  fullname: Meyer, Thorsten
– sequence: 2
  givenname: Harald
  surname: Gruppe
  fullname: Gruppe, Harald
– sequence: 3
  givenname: Michael
  surname: Franz
  fullname: Franz, Michael
BookMark eNpdkE1LAzEQhhepYFv9D8GDt4Vssskmx1L8KFSKohcvS5pMNGWb1MxW8d-7tR7E07y8PDzMzKQYxRThpBhXNVelkKwZ_clnxQRxQynjjPFx8XIfbE6YfE9m1gIi8SmT_g3ILJruCwOS5MlqB7GE6MCRR8BdighIQiQPe8A-pBhNyENjoiOL2EP-CPCJ58WpNx3Cxe-cFs8310_zu3K5ul3MZ8vSVazmJVCqmfbC22FF0TjjJFS2dp65taDONcyBPiTqQFbS1dVACFiDUQBcOz4tFkevS2bT7nLYmvzVJhPanyLl19bkPtgOWkGZBc-FlhJqUyntpdIAVChuVe3p4Lo6unY5vR-Oa7cBLXSdiZD22Epaa6YUH8DLf-Am7fPwMmyVbBpJKa34N1uQeD0
ContentType Journal Article
Copyright Copyright Freie Universität Berlin 2002
Copyright_xml – notice: Copyright Freie Universität Berlin 2002
DBID 0-V
3V.
7U4
7XB
88J
8BJ
8FK
ABUWG
AFKRA
ALSLI
AZQEC
BENPR
BFMQW
BHHNA
CCPQU
DWI
DWQXO
FQK
GNUQQ
HEHIP
JBE
M2R
M2S
PHGZM
PHGZT
PIMPY
PKEHL
POGQB
PQEST
PQQKQ
PQUKI
PRINS
PRQQA
Q9U
WZK
DOA
DatabaseName ProQuest Social Sciences Premium Collection【Remote access available】
ProQuest Central (Corporate)
Sociological Abstracts (pre-2017)
ProQuest Central (purchase pre-March 2016)
Social Science Database (Alumni Edition)
International Bibliography of the Social Sciences (IBSS)
ProQuest Central (Alumni) (purchase pre-March 2016)
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
Social Science Premium Collection
ProQuest Central Essentials
ProQuest Central
Continental Europe Database
Sociological Abstracts
ProQuest One
Sociological Abstracts
ProQuest Central Korea
International Bibliography of the Social Sciences
ProQuest Central Student
ProQuest Social Science Premium Collection - Sociology Collection
International Bibliography of the Social Sciences
ProQuest Social Science Premium Collection - Social Science Database
Sociology Database
Proquest Central Premium
ProQuest One Academic (New)
Publicly Available Content Database
ProQuest One Academic Middle East (New)
ProQuest Sociology & Social Sciences Collection
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central China
ProQuest One Social Sciences
ProQuest Central Basic
Sociological Abstracts (Ovid)
DOAJ Directory of Open Access Journals
DatabaseTitle Publicly Available Content Database
ProQuest Sociology & Social Sciences Collection
ProQuest Central Student
ProQuest One Academic Middle East (New)
ProQuest Central Essentials
ProQuest Social Science Journals (Alumni Edition)
ProQuest Central (Alumni Edition)
ProQuest One Community College
Sociology & Social Sciences Collection
ProQuest Central China
ProQuest Central
International Bibliography of the Social Sciences (IBSS)
ProQuest Central Korea
ProQuest Sociology Collection
ProQuest Central (New)
ProQuest Sociology
Social Science Premium Collection
ProQuest One Social Sciences
ProQuest Central Basic
ProQuest One Academic Eastern Edition
Sociology Collection
Continental Europe Database
Sociological Abstracts (pre-2017)
ProQuest Social Science Journals
ProQuest Social Sciences Premium Collection
ProQuest One Academic UKI Edition
Sociological Abstracts
ProQuest One Academic
ProQuest One Academic (New)
ProQuest Central (Alumni)
DatabaseTitleList Sociological Abstracts (pre-2017)

Publicly Available Content Database
Database_xml – sequence: 1
  dbid: DOA
  name: DOAJ Directory of Open Access Journals
  url: https://www.doaj.org/
  sourceTypes: Open Website
– sequence: 2
  dbid: PIMPY
  name: Publicly Available Content Database
  url: http://search.proquest.com/publiccontent
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Social Sciences (General)
EISSN 1438-5627
ExternalDocumentID oai_doaj_org_article_502cef35966e4a189f689ee0583c84f0
2352852981
Genre Report
Case Study
GroupedDBID 0-V
29H
2WC
3V.
5GY
5VS
7U4
7XB
8BJ
8FK
AAFWJ
ABUWG
ACGFO
ACIHN
ADBBV
ADZJE
AEAQA
AFFHD
AFKRA
AFPKN
AHQJS
AKVCP
ALMA_UNASSIGNED_HOLDINGS
ALSLI
ARALO
ASOEW
AZQEC
BCNDV
BENPR
BFMQW
BHHNA
BPHCQ
C1A
CCPQU
DARCH
DWI
DWQXO
E3Z
EBS
EJD
ESI
FQK
FRS
GNUQQ
GROUPED_DOAJ
HEHIP
JBE
KQ8
KWQ
M2R
M2S
M~E
OK1
OVT
P2P
PHGZM
PHGZT
PIMPY
PKEHL
POGQB
PQEST
PQQKQ
PQUKI
PRINS
PROAC
PRQQA
Q9U
RNS
TR2
WZK
XSB
PUEGO
ID FETCH-LOGICAL-d1243-e00929f5fc43857dad6e1c4df2db50dd72de9b50d0de616d41ad65ebea8ee39d3
IEDL.DBID M2R
ISSN 1438-5627
IngestDate Tue Oct 14 15:07:11 EDT 2025
Thu Sep 04 18:44:48 EDT 2025
Wed Nov 12 02:51:10 EST 2025
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 2
Language English
German
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-d1243-e00929f5fc43857dad6e1c4df2db50dd72de9b50d0de616d41ad65ebea8ee39d3
Notes 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
OpenAccessLink https://www.proquest.com/docview/867760001?pq-origsite=%requestingapplication%
PQID 867760001
PQPubID 556354
ParticipantIDs doaj_primary_oai_doaj_org_article_502cef35966e4a189f689ee0583c84f0
proquest_miscellaneous_60492883
proquest_journals_867760001
PublicationCentury 2000
PublicationDate 20020501
PublicationDateYYYYMMDD 2002-05-01
PublicationDate_xml – month: 05
  year: 2002
  text: 20020501
  day: 01
PublicationDecade 2000
PublicationPlace Berlin
PublicationPlace_xml – name: Berlin
PublicationTitle Forum, qualitative social research
PublicationYear 2002
Publisher Freie Universität Berlin
FQS
Publisher_xml – name: Freie Universität Berlin
– name: FQS
SSID ssj0023223
Score 1.5303403
Snippet Structured interviews or questionnaires often comprise open-ended questions, especially to obtain additional information from the interviewee not covered by...
SourceID doaj
proquest
SourceType Open Website
Aggregation Database
SubjectTerms 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
SummonAdditionalLinks – databaseName: DOAJ Directory of Open Access Journals
  dbid: DOA
  link: http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV07T8MwELYQYmBBPEUpDw8MMEQksePYY0FUDFAhBFLFEjm5s9QlRU3L7-fsuAiJgYUtSuIkujuf7y7n72PsEpTA3ABpoIA0kdphUmOuE6GkzYSr69qEjcKP5WSip1Pz_IPqy_eE9fDAveBuijRv0ImCwnKk4do4pQ1iWmjRaOlCtp6WZp1MxVSLzFREFP5fTjasHONdthNDPj7qX7XHNgD32aDfF8vj3Or4VQSAvj5g70--S64jB8lHgc-QU2TJKVLjawgRPnfct4IkoYDNX_pGV3rKrOWhhEnSbi15s47bFngo-wXU0UP2Nr5_vXtIIgdCArTyigQ9KJJxhWuk0EUJFhRmjQSXQ12kAGUOaPxRCqgyBTKjOwrSjNWIwoA4YpvtvMVjxhuFNFQrqaySgGVtnXGpbKwssXGYD9itl1f10cNcVB54OpwgdVRRHdVf6hiw4VraVZwNXeUx85SPJgfs4vsqmbH_N2FbnK-6SlGm4omPT_7jI4ZsO5C2hL7EU7a5XKzwjG01n8tZtzgPlvIFpZvJsg
  priority: 102
  providerName: Directory of Open Access Journals
Title Microsoft Access for the Analysis of Open-ended Responses in Questionnaires and Interviews
URI https://www.proquest.com/docview/867760001
https://www.proquest.com/docview/60492883
https://doaj.org/article/502cef35966e4a189f689ee0583c84f0
Volume 3
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVAON
  databaseName: DOAJ Directory of Open Access Journals
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: DOA
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://www.doaj.org/
  providerName: Directory of Open Access Journals
– providerCode: PRVHPJ
  databaseName: ROAD: Directory of Open Access Scholarly Resources
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: M~E
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://road.issn.org
  providerName: ISSN International Centre
– providerCode: PRVPQU
  databaseName: Continental Europe Database
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: BFMQW
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/conteurope
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Central
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: BENPR
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Publicly Available Content Database
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: PIMPY
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/publiccontent
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Social Science Database
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: M2R
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/socscijournals
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Sociology Database
  customDbUrl:
  eissn: 1438-5627
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0023223
  issn: 1438-5627
  databaseCode: M2S
  dateStart: 20000101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/sociology
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpV1Lb9QwEB5By4ELb8RSWHzgAIeIbOw49gm1aCuQ2NVqAalwiRzPuOolKZu2x_52xl7vXpC4cLGs2E6kzMMz4_E3AG9RS6osMgVqLAtlAhUdVaaQWrmZDF3X2XRR-GuzXJqzM7vKuTljTqvc6cSkqHHwMUb-IeKu6WiRfLz8XcSiUfFwNVfQuAuHbCfbyNSLar33t5hXZYbi_0vTpu3j9OF_fvgRPMh2ozjeEvox3KH-CUy2l2tFFtBRvMso0u-fwq9FTLUbWcuK41QUUbB5KtjcEzscEjEEEfNJihQFF-tttiy_5aIXKQ7KJOsdq8RRuB5Fih0m6NJn8ON0_v3T5yIXUiiQt29ZUERWsqEOXklTN-hQ08wrDBV2dYnYVEg29kokPdOoZjyjZvI6QyQtyudw0A89vQDhNfFSo5V2WiE1nQs2lMo71ZAPVE3gJP7v9nKLldFG9Or0YNict1kY2rqsPAVZs6tFzBLGBm0sUVkb6Y0K5QSOdqRos0iN7Z4OE3izH2VZiAccrqfhemw1uzuxevLLf64_gvuppEvKWnwFB1eba3oN9_zN1cW4mcLhyXy5Wk-Tcz5NDJXab7G9nfP46sti9fMP75LeDA
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V1Lb9QwEB6VLRJceCO2BeoDSHCIyMaOYx-qqjyqrrq7WqEiFS6pY49RL0m7aan6o_iPjJ1kL0jceuAWJbElaz6PZ8Yz3wC8cZJjph1JIHdpIpTHpMJMJVwKM-G-qiodC4VnxWKhTk70cgN-D7UwIa1y0IlRUbvGhhj5h8C7JoNFsnd-kYSmUeFydeig0aHiCG-uyWNrd6efSbxvs-zgy_Gnw6RvKpA4Osp4goFlSPvcW8FVXjjjJE6scD5zVZ46V2QOdXhKHcqJdGJCf-S0VKMQuXac5r0DmyJgfQSby-l8-X3t4dHu4D35_1-6PR5YBw__s6U-gge9Zcz2Oyg_hg2sn8C4Kx9mvQpq2bueJ_v9U_gxD8mELZ0jbD-2fWRkgDMyaNnAtMIaz0LGTBLj_Oxrlw9Ms5zVLEZ6CZS1IaXfMlM7FqOjkZz1GXy7laU-h1Hd1PgCmJVIQ5UU0kjhsKiM1z4V1ogCrcdsDB-DfMvzjg2kDPzc8UWz-ln2273M08yi5zk5k0igV9pLpRHTXHGrhE_HsD2IvuyVRluu5T6GnfVX2u3hCsfU2Fy1pSSHLvSH3vrn-B24d3g8n5Wz6eJoG-7HBjYxR_MljC5XV_gK7tpfl2ft6nUPYAantw2kP9y7OPA
linkToPdf http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V1Lb9QwEB6VLUJceCO2BeoDSHCImo0dxz4g1FJWVG1XBYGouKSOPUa9JO2mBfHT-HeMHWcvSNx64BYlsSVrPn_z8HgG4IWTHAvtSAKlyzOhPGYNFirjUpgZ903T6HhR-LBaLNTJiT5eg9_jXZiQVjlyYiRq19kQI98OdddksEi2fcqKON6bvz2_yEIDqXDQOnbTGBBygL9-kvfWv9nfI1G_LIr5-8_vPmSpwUDmSK3xDEPFIe1LbwVXZeWMkzizwvnCNWXuXFU41OEpdyhn0okZ_VHSso1C5NpxmvcGrCspVT6B9d350cevK2-PdgpPjQD-4vmovOZ3_-Nl34M7yWJmOwPE78Matg9gOlwrZomaevYq1c9-_RC-HYUkw570C9uJ7SAZGeaMDF02VmBhnWchkyaL8X_2acgTplnOWhYjwATW1pAy6JlpHYtR01i09RF8uZalPoZJ27X4BJiVSEOVFNJI4bBqjNc-F9aICq3HYgq7Qdb1-VAlpA51u-OLbvm9TjRQl3lh0fOSnEykzaC0l0oj5qXiVgmfT2FzhEGdyKSvVxiYwtbqK7FAONoxLXZXfS3J0Qt9ozf-OX4LbhF66sP9xcEm3I59bWLq5lOYXC6v8BnctD8uz_rl84RlBqfXjaM_PWRBkA
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Microsoft+Access+for+the+Analysis+of+Open-ended+Responses+in+Questionnaires+and+Interviews&rft.jtitle=Forum%2C+qualitative+social+research&rft.au=Meyer%2C+Thorsten&rft.au=Gruppe%2C+Harald&rft.au=Franz%2C+Michael&rft.date=2002-05-01&rft.pub=Freie+Universit%C3%A4t+Berlin&rft.eissn=1438-5627&rft.volume=3&rft.issue=2&rft.externalDBID=HAS_PDF_LINK&rft.externalDocID=2352852981
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1438-5627&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1438-5627&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1438-5627&client=summon