Database Help

  1. Start Access, and then open the BuySell database..
  2. Extract the file, and save it to your desktop.
    • 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

Do you need help with this assignment? Or a different one? We got you covered.

Quality Guaranteed

Any Deadline

No Plagiarism