Stats_beginning_access

Stats_beginning_access - Building A Database February 5,...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Building A Database February 5, 2008
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ACCESS instead of EXCEL Excel is a spreadsheet program used for mathematical calculations, accounting, banking, etc. ACCESS is a database program which is used for entering, storing, and analyzing data records. DO NOT use Excel unless you are creating a budget document or storing mathematical calculations.
Background image of page 2
ACCESS and SPSS SPSS (Statistical Package for the Social Sciences) is also a database program which allows you to create a database, enter data, and perform statistical analysis. Why do you need both?? ACCESS makes it easier to create the database and is more user-friendly when it comes to data entry, but analysis can be tricky – need to create and write your own queries. SPSS makes statistical analysis much easier but, data entry and database creation is more challenging. So I use both and make the most of the good qualities of each program.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Review of Steps 1. Understand the Project Assignment 2. Identify Data Source(s) 3. Create Variable List(s) with appropriate attributes when needed 4. Create the Code sheet 5. Code data source
Background image of page 4
Step Six Create the Database Table Field Names, Data Types & Adjusting Field Properties
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Stats Class Folder Create a Stats Class folder in the T drive. This is where you will save all work done in
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 19

Stats_beginning_access - Building A Database February 5,...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online