SophiaPretty
$14/per page/Negotiable
Navigation Forms in the Pro Shop Database
Project Description:
An intern has created a database that Phil’s Phone App Store can use to sell apps for smartphones. Phil is not happy with how the forms are working and has asked you for help. The form used for looking up information about an app author is not working the way Phil would like it to work. He wants to be able to look up an author name, view information about the author, information about the author’s different apps, and see where and when the author’s apps were sold. He would also like to see how many apps each author has created and the total royalties each author has earned for all apps they have. You will help Phil by modifying the form so there is a lookup field and multiple tabs with all the information he wants to see.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access file named a05ws09_grader_h1_AppStore.accdb. Save it as a05ws09AppStore_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.
2
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 name the box 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 header.
Hint: To insert the control, on the DESIGN tab, in the Controls group, click Combo Box.
3
4
Insert the date and time in the header, accepting the default formatting, and anchor both controls to the top right of the header.
Hint: To anchor the controls, on the ARRANGE tab, in the Position tab, click Anchoring.
2
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.
5
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.
5
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 to Total Royalty. Resize the label so that the caption displays. Format the field with Currency formatting, and then save and close the subform.
Hint: To open the subform in a new window, on the DESIGN tab, in the Tools group, click Subform in New Window. The function is =Sum([AuthorRoyalty]).
5
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 to Total Apps. Save and close the subform.
Hint: The function is =Count([PurchaseDate]).
5
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.
5
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.
5
11
Lock frmAuthorAppSubform, lock frmAuthorPurchaseSubform, and lock the fields Total Royalty and Total Apps.
4
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.
3
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.
3
14
Change the background color of the header to Aqua, Accent 5, Lighter 40%. Save and close the form.
3
15
Close the database and submit the database as directed.
0
Total Points
50
Attachments: