Uses of Macros

Access 2010 provides various types of macro actions that you can use to automate your application. With macros, you can

  • Open any table, query, form, or report in any available view or close any open table, query, form, or report.

  • Open a report in Print Preview or Report view or send a report directly to the printer.

  • Send the output data from a report to a Rich Text Format (.rtf) file or a Notepad (.txt) file. You can then open the file in Microsoft Word 2010 or Notepad.

  • Execute a select query or an action query. You can base the parameters of a query on the values of controls in any open form.

  • Include conditions that test values in a database, a form, or a report and use the results of a test to determine what action runs next.

  • Execute ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.