using ms access in managing household survey data
DESCRIPTION
Breaking the traditional entry of Survey data in Spreadsheet. This presentation aim's to standardize Social Sciences Division Survey data and understand the value database management using Access.TRANSCRIPT
International Rice Research Institute
Using MS Access in Managing Household Survey Data
Data Entry, Validation and Analysis
Orlee VelardeSSD
International Rice Research Institute
Features:• User-friendly (Windows interface similar to the
questionnaire)• More secured data entry• No need to use codes (i.e. MV=1; TV=2)• Minimizes confusions on which row/column
needs to be filled• Includes data validation package• One-step data merging for multi-PC data entry• Easy recoding steps for a uniform use of terms
(i.e. spellings, terminology etc.)
International Rice Research Institute
Major component:
• Data entry form• Data validation
– By household– By sample
• Merging multiple files• Recoding (changing terms, categories,
spellings, etc.)• Database source used for analysis
International Rice Research Institute
Data Entry
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
Data Entry and Validation (per household)
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
Sample Validation
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
Merging and Recoding
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
International Rice Research Institute
Dat
abas
e
International Rice Research Institute
Thank you.