access homework

2. Use the Form Wizard to create a form containing a main form and a subform. Select all the fields from the Program table for the main form, and select the Member ID, First Name, Last Name, and Phone fields from the Member table for the subform. Use the Tabular layout for the subform and the Office style. Name the main form Program Members Form – YourName and the subform Member - YourName Subform.

3. Change the AutoFormat of the Member Subform to Northwind. (Hint: Close the Program Members form, and then open the Member Subform. Change the AutoFormat of the subform, and then save and close the subform.)

4. In the Program Members form, change the AutoFormat to Origin. Change the font color of the main form title to Access Theme 3, and change the line type of the field boxes in the main form to Solid.

5. Save the Program Members form, navigate to the second record in the subform for the first main record, and then change the Phone field value to 804- 553- 7986.

6. Navigate to the ninth record in the main form, and then change the Last Name field value for the fourth record in the subform to Larsen. Close the form. Note: If you can’t find the record requested in the ninth record, it may be that you didn’t delete record 205 from the Program table requested in a previous assignment.

7. Use the capture and print method to capture the mainform / subform, paste it in Word, and then print the screen capture from Word.

8. Use the Report Wizard to create a report based on the primary Program table and the related Member table. Select all fields except Physical Required from the Program table, and then select the following fields from the Member table: Member ID, First Name, Last Name, City, Phone, and Date Joined. In the third Report Wizard dialog box, specify the City field as an additional grouping level. Sort the detail records by Date Joined in descending order. Choose the Block layout, Landscape orientation, and the Office style for the report. Name the report Programs and Members Report-Your Name.

9. Revise the report title text to Programs and Members-Your Name.

10. Change the report’s AutoFormat to Origin.

11. Resize the fields as necessary so that all the field names and values are completely displayed within the margins of the report.

12. Insert the Weights picture from the Moodlerooms download folder just to the right of the Programs and Members title in the report.

13. Open the Access Help window and enter “resize an image in a report “as the search text. Select the Help article titled “ Modify, edit, or change a report,” select the section titled “ Modify your report in Layout view,” select the topic titled “ Add or modify a logo or other image,” and then read the “ Resize a control that contains a logo or other image” section. Verify that the Weights picture is still selected, and then resize it to about 75 percent of its original height. Close the Access Help window. Make sure that the Size Mode property for the Weights picture is set to Zoom.

14. Apply conditional formatting so that all City field values equal to Ashland are formatted as bold and dark blue- green ( sixth row, ninth column in the gallery).

15. Preview the report to confirm that it is formatted correctly. Save the report, print its first page ( only if asked by your instructor to do so), and then close the report.

16. Compact and repair the Fitness database, and then close it. IT IS IMPERATIVE THAT YOU CLOSE YOUR DATABASE BEFORE SUBMITTING IT FOR GRADING.

17. Upload your Fitness database and submit the assignment for grading using the Attach file option in Moodlerooms.

CISB 15 Access Lab 4 Instructions Page 1 of 2