You are required to create a macro that can run action query. What steps will yo

You are required to create a macro that can run action query. What steps will you take?

Question Posted / kundan prajapati

1 Answers
957 Views
I also Faced
E-Mail Answers

You are required to create a macro that can run action query. What steps will you take?..

Answer / Devesh Mishra

To create a macro in MS Access that runs an Action Query, follow these steps:
1. Click on the 'Developer' tab.
2. In the 'Controls' group, click on the 'Macro' button to open the Macro Builder.
3. Add a new action by clicking on the 'Action' drop-down and selecting 'Run SQL'.
4. Enter your SQL statement for the Action Query in the 'SQL Statement' field.
5. Save and close the Macro.
6. Assign the macro to a button or event.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer