PROJECT STEPS $1.$ The Economic Development Professional Organization hosts an annual conference for its members, college students, and other interested persons to share new ideas, discuss problems, and brainstorm solutions. You are a conference coordinator responsible for tracking registrations and for recording income based on advertisers, exhibitors, and sponsors. Open the Preview Advertisers Contact Report macro in Design View. Change the View argument to Print Preview. Save the change to the macro, and then close the Preview Advertisers Contact Report macro. $2.$ Create a new macro with two submacros by following the directions below: a$.$ When the Macro design window opens, display the Action Catalog. b$.$ Add the first submacro to the macro, using Open Attendees Table as the name for the submacro. c$.$ In the first submacro, use the OpenTable action to open the Attendees table in Datasheet View and in Edit data mode. d$.$ Add a second submacro to the macro, using Open Registration Table as the name for the macro. e$.$ In the second submacro, use the OpenTable action to open the Registration table in Datasheet View and in Edit data mode. f$.$ Save the macro using Open Tables as the macro name. Confirm that your macro matches Figure $1,$ and then close the macro. Figure $1$: Open Tables Macro $3.$ Open the EarlyRegistration table in Datasheet View and create a data macro for the table as follows: a$.$ Click the Before Change button on the Table tools tab. When the Macro window opens, enter the data macro shown below: If $[$Paid$]>[$TotalFees$]$ Then SetField Name $[$Paid$]$ Value $=[$TotalFees$]$ Else If $[$Paid$]<0$ Then SetField Name $[$Paid$]$ Value $=0$ End If b$.$ Confirm that the macro matches Figure $2.$ Save and close the macro, then save and close the EarlyRegistration table. Figure $2$: Data Macro for Before Change Event $4.$ Create a Navigation form for the database with the following options: a$.$ Use the Horizontal Tabs layout. b$.$ Add the Advertisers, Exhibitors, and Sponsors Datasheet forms to the Navigation form in that order. c$.$ Change the title $($in the Form Header$)$ using Main Navigation Form as the new title. d$.$ Save the navigation form using Main Navigation Form as the form name. Switch to Form View, and confirm that your form matches Figure $3.$ Save the form and close the Main Navigation Form. Figure $3$: Main Navigation Form$$Form View $5.$ Open the Advertisers form in Datasheet View and perform the following tasks to create a UI macro for the form: a$.$ Select the AdvertiserID column. b$.$ Click the Property Sheet button. c$.$ Click the Build button for the On Click event and select Macro Builder. d$.$ Create a macro that opens the Advertiser Master Form when a user selects a value in the AdvertiserID column. The macro actions are shown below: SetTempVar Name AN Expression $=$AdvertiserID OpenForm Form Name Advertiser Master Form View Form Filter Name Where Condition $=[$AdvertiserID$]=[$TempVars$]![$AN$]$ Data Mode Window Mode Dialog Remove TempVar Name AN Confirm that the macro actions match Figure $4.$ Save and close the macro, then save and close the form. Figure $4$: UI Macro Associated with On Click Event in the Advertisers Form $6.$ Open the Main Menu Form in Layout View and perform the following tasks: a$.$ Add the Forms List form to the Main Menu Form as the last horizontal tab. b$.$ Rename the Forms List tab using Master Forms as the new name. c$.$ Move the Sponsors tab so that it appears first in the list. Switch to Form View, confirm that the form matches Figure $5,$ then save and close the form. Figure $5$: Main Menu Form$$Form View $7.$ Open the Open Master Forms form in Design View and add a command button to the form in the approximate position shown in Figure $6.$ The left$-$edge of the button is at the $2"$ mark on the horizontal ruler and the top$-$edge of the button is at the $2\mathrm{.}5"$ mark on the vertical ruler. Ensure that Use Control Wizards is selected and use the following options when creating the command button using the Command Button wizard: a$.$ Select Miscellaneous as the category and Run Macro as the action. b$.$ Select Forms.Open Workshop Master Form as the macro. c$.$ Select the Text option and enter Open Workshop Master Form as the text. d$.$ Name the command button using Open$\_$Workshop$\_$Master$\_$Form as the name. Save the changes to the form but do not close it$.8.$ With the Open Master Forms form still open in Design View, complete the following actions: a$.$ Select the three buttons on the form and use the Size$/$Space menu to adjust the size To Widest. b$.$ Use the Size$/$Space menu to adjust the spacing of the button controls to Equal Vertical. c$.$ Align the buttons to the Left. The left$-$edge of the buttons should be at the $2"$ mark on the horizontal ruler. The top$-$edge of the first button should be at the $1"$ mark on the vertical ruler. The right$-$edge of the buttons is at the $4"$ mark on the horizontal