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.
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more