Details of this Paper

Database Help!

Description

solution


Question

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

 

Paper#73322 | Written in 18-Jul-2015

Price : $22
SiteLock