| Start Access. Open the downloaded Access file named a05ch09_grader_a1_AppStore.accdb. Save it as a05ch09_grader_a1_AppStore_LastFirst. Enable content if necessary. |
0 |
| 2 |
Open frmAuthor, switch to Layout view, and delete the FirstName and LastName labels and text boxes. Change the title to App Lookup. |
5 |
| 3 |
In Design view, insert a combo box in the header below the title at the 1.5-inch mark on the horizontal ruler to find a record based on the AuthorName field from tblAuthor. Hide the key column, and then set the label caption as App Author Lookup. Move the combo box below the title so that the left edge of the label aligns with the left edge of the title. |
5 |
| 4 |
Insert the date and time in the header, accepting the default formatting, and anchor both controls to the top right of the header. |
5 |
| 5 |
Insert a tab control in the Detail section so the top-left corner of the control is at the 1-inch mark on the horizontal and the .5-inch mark on the vertical ruler. Cut frmAuthorAppSubform, and then paste it on the first page of the tab control. Delete the subform label, and then move the subform to the top-left corner of the page. Rename the page Author Apps. |
11 |
| 6 |
Cut frmAuthorPurchaseSubform, and then paste it on the second page of the tab control. Delete the subform label, and then move the subform to the top-left corner. Rename the page App Purchases. |
10 |
| 7 |
Open the frmAuthorAppSubform in a new window. Drag the Form Footer down to the 1″ mark on the vertical ruler and then add a new field in the footer that will calculate the author’s total royalty for all his apps. Name the field TotalRoyalty and then change the label caption to Total Royalty. Resize the label so that the caption displays. Format the field with Currency formatting, and then save and close the subform. |
10 |
| 8 |
Open the frmAuthorPurchaseSubform in a new window. Drag the Form Footer down to the 1-inch mark on the vertical ruler and then add a new field in the footer that will calculate the total number of apps the author has sold; use the PurchaseDate field. Name the field TotalApps and then change the label caption to Total Apps. Save and close the subform. |
10 |
| 9 |
Insert a new page to the tab control, and then call it Author Summary. Insert a new field with the TotalRoyalty calculated field on the page. Name the field TotalRoyalty and then change the label to Total Royalty. Format the field as Currency. |
11 |
| 10 |
Insert a new field on the Author Summary page of the tab control that calculates the number of TotalApps. Name the field TotalApps and then change the label to Total Apps. Align the two field labels on the page left and the two text boxes right. Move all four fields to the top-left corner of the page. |
10 |
| 11 |
Lock frmAuthorAppSubform, lock frmAuthorPurchaseSubform, and lock the fields TotalRoyalty and TotalApps. |
8 |
| 12 |
Add a button below the tab control to close the form. Display the text Close Form on the button and then name the button cmdCloseForm. Line the top-left corner of the button up with the 3.5″ vertical grid line and the 1″ horizontal grid line. |
5 |
| 13 |
Add a button to the right of the Close Form button to open frmFindAppSales. Display the text Find App Sales on the button and then name the button cmdFindAppSales. Align both buttons by their top edge, and then size them to the widest button. |
5 |
| 14 |
Change the background color of the header to Blue, Accent 1, Lighter 40%. Save and close the form. |
5 |
| 15 |
Close the database and submit the database as directed. |
0 |
0 comments