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: see image.
A. Using data in the preceding table, create four tables and their corresponding data entry forms to enter (record) all the information as follows:
i. 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.
ii. 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: see image.
iii. 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.
iv. Table three (named "Intake"): patient ID and average food intake estimates daily (calories). Create the corresponding form to enter this information onto the table.
v. 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.
B. Add a button for adding records on the form for table one (Patient Info).
C. Enter all the data for table one using the Patient Info form you created.
D. Make the necessary changes such that when the database is opened, the form for Patient Info is displayed.