Computer Science

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.

Order now and get 10% discount on all orders above $50 now!!The professional are ready and willing handle your assignment.

ORDER NOW »»