O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Uses of Macros

Access 2007 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, a Windows Notepad (.txt) file, or a Snapshot (.snp) format file. You can then open the file in Microsoft Word 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required