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:

Patient ID

201

202

203

204

205

206

207

208

209

Name

John

Jean

Mary

Mark

Bill

Jack

Amy

Lynn

Bob

Sex

M

F

F

M

M

F

F

F

M

Age

35

46

38

56

42

33

47

29

38

Race/ethnicity

Asian

White

Black

White

White

Black

Hispanic

Hispanic

White

Height_F

5

5

6

6

5

5

5

5

5

Height_I

10

6

0

1

6

4

3

7

11

Weight1_P

175

150

165

200

197

179

127

162

194

Weight1_O

3

1

0

2

8

5

3

0

6

Weight2_P

172

130

172

191

197

150

130

153

190

Weight2_O

0

8

2

9

1

8

1

4

3

Calories

3000

2800

2600

4000

3200

2500

2200

2800

3100

Glocuse1

136

165

189

150

135

150

180

160

180

Glocuse2

140

150

170

155

134

145

175

161

160

Glocuse3

128

130

170

160

138

130

140

160

140

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)