Select all the fields from the Plan table, and then select the MemberID, FirstName, LastName, City, Phone, DateJoined, and Expiration fields from the Member table. Use the Report Wizard to create a report based on the primary Plan table and the related Member table. Resize all columns in the subform to their best fit, working from left to right then move through all the records in the main form and check to make sure that all subform field values are fully displayed, resizing the columns as necessary. Change the form title text for the main form to Members by Plan. Specify the title MembersByPlan for the main form and the title MemberSubform for the subform. Select all the fields from the Plan table for the main form, and select the MemberID, FirstName, LastName, Expiration, and Phone fields from the Member table for the subform. Use the Form Wizard to create a form containing a main form and a subform. Use the MemberData form to add a new record to the Member table with the following field values: Member ID: 1261 Plan ID: 306 First Name: Taylor Last Name: Byrne Street: 318 Coolidge Dr City: Jamestown State: CO Zip: 80455 Phone: 30 Date Joined: Expiration Date: 7. Use the Find command to display the record for Marco Krukonis, and then change the Street field value for this record to 75 Woodfield Ave. Edit the form title so that it appears as “Member Data” (two words) resize the title so that both words fit on the same line and then change the font color of the form title to the Dark Red, Accent 1, Darker 25% theme color. Apply the Wisp theme to the MemberData form only. Specify the title MemberData for the form. Select all the fields for the form and the Columnar layout. Use the Form Wizard to create a form based on the Member table. Open the Gopher database you created and worked with in Tutorials 1 through 3, and then click the Enable Content button next to the security warning, if necessary. He asks you to create the necessary forms and a report to help him work with this data more efficiently. from Tutorial 3) and Tasks.bmp GoGopher! Amol Mehta uses the Gopher database to track and view information about the services his company offers. By New Perspectives on Microsoft Office 2013, First Course (1st Edition) Edit edition Solutions for Chapter AT4 Problem 1CP: Data Files needed for this Case Problem: Gopher.accdb (cont.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |