Ms Access Macro Tutorial — Pdf

| Action | Purpose | |------------------|----------------------------------------------| | OpenForm | Opens a form | | OpenReport | Opens a report (Print Preview, PDF export) | | RunQuery | Executes an action query (append, update) | | MessageBox | Displays a pop-up message | | SetValue | Changes a field or control value | | CloseWindow | Closes the active object | | ExportWithFormatting | Exports data to PDF, Excel, Word |

on the Quick Access Toolbar and give the macro a descriptive name Microsoft Support Assign to a Button : Open a form in Design View , select a command button, and in the Property Sheet event to your saved macro Commonly Used Macro Actions How to Make a Macro in Microsoft Access ms access macro tutorial pdf

You have two options to get the official, updated guide: Switch to VBA for complex data processing

Before diving into the tutorial, you need to understand the three components of any Macro action: select a command button

This macro exports the current report to a PDF file.

When a user clicks the button, your macro runs instantly.

Use macros for simple UI automation. Switch to VBA for complex data processing.