Access Assignment 4 is Tutorial 6, Case Problem 1, P. 375-376, Steps 1, 5 a.-e., 6 (see below for modified steps 1 and 6).

Step 1. Copy the Task database and name your Last Name First Name A4 T6 C1, e.g., Cohan Jeff A4 T6 C1.

Step 6. Compact and repair, and close the database. Submit the database in the Access Assignment 4 link in Assignments in Blackboard by the due time/due date.

5. follow the steps to create a custom form names frmPlansWithMembers based on the tblPlan and tblMember tables.

a. place the fields from the tblPlan table at the top of the Detail section and edit the captions in the associated label controls as shown.

b. selected fields from the tblMember table appear in a subfrom names frmPlanMemberSubform.

c. calculated control displays the total number of records that appear in the subform. set the calculated control's ControlTip text property to Total number of members in this plan.

Set the calculated control's tab stop property to No.

d. apply the organic theme to the form

e. save from

6. make a backup copy of the database, compact and repair the database, and then close the database.