Database Help

• Click on the Create tab, and then create 3 different macros. The actions are listed below:
  1. Create a macro and save it as “Basic.” Program the macro to do the following:
     • Open a message box that reads, “Open Form ‘Item’ “
     • Open the form “Item”
     • Open a message box that reads, “This is a beep”
     • Sound a beep
     • Open a message box that reads, “Directing to record 18”
     • Go to record 18 in the form “Item”
     • Open a message box that reads, “Closing form ‘Item’ “
     • Close the form
  2. Create a new macro, and save it as “Print Form Item.” Program the macro to do the following:
     • Open the form “Item”
     • Select the form “Item”
     • Run the PrintSelection command
     • Reselect the form “Item”
  3. Create a new macro and save it as “Run Macros/Exit Database.” Program the macro to do the following:
     • Run the macro “Basic”
     • Run the macro “Print Form Item”
     • Close the database
• Click on the Create tab, and create a new blank form.
• Name it “Switchboard,” and open it in the Design view.
• Create 3 buttons, and attach your 3 macros.
• Create a label for each of your buttons.
• Associate each label with the button command name.
• Set the background color for the switchboard to a color of your choice.
• Test your macrosFollow the steps below to design the macros and the switchboard form.

Upon a final handshake I will provide a link to the database file that is needed for this one