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 ...