I am looking for some assistance with the attached ACCESS Assignment. I don't have ACCESS. 

 

StepInstructionsPoint Value1Start Access. Open the file namedexploring_a04_grader_h2.accdb. Save the database asexploring_a04_grader_h2_LastFirst.02Select the Members table and create a Multiple Items form. Save the form asMaintain Members.103In Layout view, change the MemNumber label toMemIDand reduce the MemNumber column width to0.6".84Change the widths of the LastName, FirstName, City, and Phone fields to1.25"; change the width of the State and Zip fields to0.75"; and change the width of the Address field to1.75". Delete the form icon (the picture next to the title of the form) in theForm Header.85Change the sorting order of the MemberSince control so that the members who joined most recently are displayed first.86Click the LastName field and change the control padding to Wide. Save and close the form.87Select the Revenue query and create a report using the Report Wizard. Include all fields in the report and add grouping by Cityand then by ServiceName. Add a Sum to the Revenue field and select the Summary Only option. Choose Outline Layout andname the reportRevenue by City and Service.108Scroll through all the pages to check the layout of the report while in Print Preview mode. Exit Print Preview. Switch to Layoutview and delete the NumInParty and PerPersonCharge controls.109Select the Sum control below the Summary for 'City' control. Change the font size to 12; change the font color to Dark Blue, Text2; and change the background color of the control to Yellow.1010Change the sort on the report, so that it sorts by city in descending order—that is, so that the last city alphabetically (St. Paul) isdisplayed first.1011Examine the data in the report to determine which city of St. Paul, St. Louis, and Seattle has the highest Sum of event revenue.Save and close the report. Modify the Totals by Service query so the criteria for the City field is the city you determined had thehighest sum from St. Paul, St. Louis, or Seattle. Save and close the query.812Create a report using the Report tool based on the Totals by Service query. Name the reportTargeted City. Close the report.1013Close the database, and submit based on your instructor's directions.

• 1495067510-exploring_a04_grader_h2_LastFirst_Instructions.docx

SuperTutor

(15)

Status NEW Posted 18 May 2017 12:05 AM My Price 8.00

-----------

Attachments

file 1495067512-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer