Posted: December 12th, 2022
Open the file named exploring_a07_grader_h2_Rewards.accdb.02Select the Members table, and create a form using the Form tool. Save the form as Maintain Members.
0.53Switch to Design view. Change the State text box to a combo box. Change the Row Source to States.0.54Delete the form logo and the Label control (containing the word Members) from the Form Header section. Insert an Image control in the upper-left corner of the Form Header section. Insert the downloaded a07m1Logo.png file.
Hint: To insert an image, on the Form Design Tools Design tab, in the Controls group, click the Image control.15Change the background color of the Detail section to the orange color found in the first row (Orange, Accent 6). Select all the labels in the Detail section by drawing a box around them. Change the font color of the labels to Black, Text 1.0.56Change the border width of the labels to 4 pt and the border color to Blue, Accent 1 (fifth column, first row).
Hint: To change the border settings, on the Form Design Tools Format tab, use the tools in the Control Formatting group.0.57Switch to Form view. Verify the tab order does not work as expected by pressing TAB to visit each field (State comes before City). Correct the tab order. Save and close the form. Hint: To change the tab order, on the Design tab, in the Tools group, click Tab Order.0.58Open the Members By State report in Design view. Add a formula in the Time as Member box (which currently displays Unbound) to determine the number of years they have been a member. Use #12/31/2017# as the current date (recall dates must be surrounded by # signs), subtract the MemberSince field, and divide the result by 365. Change the format of the using the Property Sheet to Standard format with 1 decimal place. Hint: Type =(#12/31/2017#-[MemberSince])/365 in the text box. To format the field, on the Design tab, in the Tools group, click Property Sheet.19Add grouping by the State field. Remove the State label from the Page Header section. Switch to Report view. Ensure the values displayed make sense. For example, assuming a current date of 12/31/2017, member Melissa Remaklus has been a member since 11/8/2006, so she has been a member for slightly more than 11 years. Also notice after the members from Alaska (AK) there is a break before the members from Arizona (AZ) due to the grouping you added. Save and close the report. Hint: To add grouping, on the Design tab, in the Grouping & Totals group, click Group & Sort.0.510Close the database, and submit the file as instructed.
Place an order in 3 easy steps. Takes less than 5 mins.