NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1056654
Record Type: Journal
Publication Date: 2011
Pages: 24
Abstractor: As Provided
ISSN: ISSN-1942-2504
Data Preparation 101: How to Use Query-by-Example to Get Your Research Dataset Ready for Primetime
Lazarony, Paul J.; Driscoll, Donna A.
American Journal of Business Education, v4 n3 p1-24 2011
Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable dataset. Fortunately, there is hope. The query facility within database management software (DBMS), such as Microsoft Access, is particularly well-equipped to do the data reconfigurations necessary to get datasets ready for a SASP. Unfortunately, most researchers have either never been exposed to a DBMS or are unaware of the powerful data-transforming queries that they can perform. The purpose of this paper is to introduce researchers to some very helpful and relatively easy to learn techniques for solving common dataset misconfiguration problems. It is presented in three sets of hands-on examples: (1) how to import a dataset from an electronic spreadsheet into a database table, (2) how to use an easy-to-learn DBMS facility called Query-By-Example (QBE) to perform specific data reconfiguration tasks, and (3) how to import the reconfigured dataset from the DBMS into a SASP. The software used is MS Excel, MS Access, and SPSS (originally called Statistical Package for the Social Sciences). The examples are presented step-by-step so that the reader can follow along using files downloadable from the authors' website.
Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: Researchers
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A