Graduate Studies Reports Access

Graduate Course Proposal Form Submission Detail - PHC6192
Tracking Number - 1717

Edit function not enabled for this course.

Current Status: Approved, Permanent Archive - 2007-05-14
Submission Type:
Course Change Information (for course changes only):

Detail Information

  1. Date & Time Submitted: 2007-01-17
  2. Department: Epidemiology and Biostatistics
  3. College: PH
  4. Budget Account Number: 640300
  5. Contact Person: Dr. Heather Stockwell
  6. Phone: 9744804
  7. Email:
  8. Prefix: PHC
  9. Number: 6192
  10. Full Title: Public Health Database Management
  11. Credit Hours: 3
  12. Section Type: C - Class Lecture (Primarily)
  13. Is the course title variable?: N
  14. Is a permit required for registration?: Y
  15. Are the credit hours variable?: N
  16. Is this course repeatable?:
  17. If repeatable, how many times?: 0
  18. Abbreviated Title (30 characters maximum): Database Management
  19. Course Online?: -
  20. Percentage Online:
  21. Grading Option: R - Regular
  22. Prerequisites: Computer Application for Public Health Workers (PHC 6700)
  23. Corequisites: none
  24. Course Description: This course focuses on the creation of databases with applications to public health and clinical research; data entry and database management and checks for accuracy and consistancy, and prepararation of final databases for statistical analysis.

  25. Please briefly explain why it is necessary and/or desirable to add this course: This course is needed by MPH students in epidemiology as the collection of data and development of a databases for analysis of the collected data as well as the management and manipulation of large existing public health and research databases are becomin
  26. What is the need or demand for this course? (Indicate if this course is part of a required sequence in the major.) What other programs would this course service? This course will be a requirement for the MPH students in the Epidemiology concentration in the Department of Epidemiology and Biostatistics. The course was developed to strengthen the data management skills (data collection, monitoring, management and analysis) of our students, and will help meet the newly revised competencies of the Association of Schools of Public Health (ASPH). This course is also relevant for students in other health disciplines involved in research such as Medicine, Nursing, etc.
  27. Has this course been offered as Selected Topics/Experimental Topics course? If yes, how many times? Yes once (currently - Spring 2007)
  28. What qualifications for training and/or experience are necessary to teach this course? (List minimum qualifications for the instructor.) Ph.D. in Epidemiology, Statistics/Biostatistics or related field
  29. Objectives: 1. To describe and analyze concepts and principles of developing data bases for epidemiologic and clinical research studies.

    2. To provide in depth understanding data base design using the Microsoft Access software.

    3. To demonstrate and apply advanced programming features of Statistical Analysis Software (SAS) for the manipulation of the database and to perform a suite of data management tasks that are commonly employed in a research studies

  30. Learning Outcomes: By the completion of this course students will:

    1.Have a complete understanding of the principles of developing a multi-table relational database for epidemiological and clinical research studies.

    2.Be able to create annotated case report forms and data dictionary.

    3.Use effectively the Microsoft Access software to design a multi-table relational database that includes creating data entry screens, setting up integrity checks, creating queries, writing macros for automation of certain data entry tasks, etc.

    4.Write SAS macros to convert Access tables into individual SAS data sets, merging these SAS data sets to create a single SAS dataset for each study, perform the double-entry comparisons and resolve discrepancies and carry out edit checks to check the accuracy and the consistency of the data across all forms in the study.

    5.Use Interactive Matrix Language procedures, and other advanced features of SAS such as multi-dimensional arrays to conduct a suite of data management tasks to prepare the databases for final statistical analyses.

    6.Have a sound knowledge of how to work with the national databases such as NHANES, for academic research purposes.

  31. Major Topics: Fundamentals and principles of multi-table relational database design and data management; sample clinical case report forms (questionnaires). Creation of annotated case report forms and a study data dictionary; Creation of tables with validation rules, default values, primary keys, and specifying relations among the tables; Creation of data entry screens (Access forms) based on the tables, writing macros within Access to implement integrity checks, data entry rules and skip patterns to ensure the accuracy of data entry; creating Access queries, generating simple reports, and creating two databases; data management plans, standard operating procedures (SOPs) for data quality assurance, data backup and correction of errors, ethics of dealing data, HIPAA and confidentiality; export Access database tables to other packages such as SAS, SPSS and EpiInfo; SAS macros; advances features of SAS; and National databases; Oracle and Sequel.
  32. Textbooks: Access 2000: The Complete Reference by Virginia Andersen (ISBN 0-07-882512-1

    Microsoft Access 2003 Bible by Cary N. Prague and Michael R. Irwin

    Applied Statistics and the SAS programming Language, Fifth Edition by Ron Cody and Jeffrey K. Smith.

    Delwiche, Lora D., & Slaughter, Susan J. The little SAS book: A Primer. SAS Institute, Inc.

  33. Course Readings, Online Resources, and Other Purchases:
  34. Student Expectations/Requirements and Grading Policy:
  35. Assignments, Exams and Tests:
  36. Attendance Policy:
  37. Policy on Make-up Work:
  38. Program This Course Supports:
  39. Course Concurrence Information:

- if you have questions about any of these fields, please contact or