Database Help!

  1. Start Access, and then open the BuySell database..
  2. Extract the file, and save it to your desktop.
  3. Follow the steps below to design the macros and the switchboard form.
    • 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 macros

     

     

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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.