CHS762 Public Health Information Systems and Data Management

Module 7: MS Access Assignment

INSTRUCTIONS

Answer all questions.

Notes:

a. You will work in your assigned groups for this assignment.

b. When you have completed the assignment, you will evaluate yourself and your group members. If the group evaluation indicates that a group member did not participate, this will affect that individual's score on the assignment. Complete the self and group evaluation assignment on Canvas.

c. For your Access assignment filename, include course code, group number, and module number, e.g. “CHS762_Grp1_M7”. Note that you will be uploading the Access database file that you will create for this assignment.

d. List the names of the group members on the header section, on the top right-hand corner of the assignment.

e. It is strongly recommended that you review the following files (found in Canvas) and complete the suggested exercises for creating the table and form before completing this assignment:

1. CHS 762 Creating an MS database—1 Table (Word)
2. CHS 762 Creating a MS database—2 Form (Word)
3. CHS 762 Student Test (Access database)

Create a database using Microsoft Access to enter the results from a research project. The project involves studying the relationship between diet, exercise, body weight, and blood sugar level. A total of nine diabetes patients are enrolled in this project. They are encouraged to take a 30-minute daily walk, watch their food intake daily, and measure body weight and blood glucose, and then record the data. The following table contains data for these nine patients:

a. Using data in the preceding table, create four tables and their corresponding data entry forms to enter (a record) all the information as follows:

1. Table one (named “Patient Info”): participants’ demographic information to include patient ID, name, gender, age, and race/ethnicity. Create the corresponding form to enter this information onto the table. (10 points)
2. Create a combo box, for race/ethnicity. Remember to enter the option “9” for missing or unknown values. Include two columns for the combo box, see sex categories example below: (5 points)
3. Table two (named “Weight”): patient ID and body weight information to include height in feet and inches (Height_F and Height_I), pretest weight in pounds and ounces (Weight1_P, Weight1_O), and posttest weight (Weight2_P, Weight2_O) measurements. Create the corresponding form to enter this information on the table. (10 points)
4. Table three (named “Intake”): patient ID and average food intake estimates daily (calories). Create the corresponding form to enter this information onto the table. (4 points)
5. Table four (named “Glucose”): patient ID and the three blood glucose measurements (mg/l). Create the corresponding form to enter this information onto the table. (6 points)

b. Add a button for adding records on the form for table one (Patient Info). (5 points)

c. Enter all the data for table one using the Patient Info form you created. (5 points)

d. Make the necessary changes such that when the database is opened, the form for Patient Info is displayed. (5 points)