How to Edit Macros or Reports in Access


Access databases let you input data with forms and tables. Data is extracted from the database by using reports and queries. Macros let you automate your database functionality by performing tasks that are programmed into the macros. Once the tables, forms, macros, queries and reports are created, they can be modified if changes are needed. These changes are done while the object is in Design View.

  • Open Access 2007 and select a database with macros or reports to edit. Click the "Office" button and select "Open." Browse your computer and locate the database. Click the database and then the "Open" button. The Access database opens.

  • Expand your Navigation Pane by pressing "F11" on your keyboard. Once the Navigation Pane is expanded, select the drop-down list at the top of the Navigation Pane. Select "All Tables." This will display all of the objects in your database. Select one of the reports in your database by double-clicking on it. The report will appear on the right side of your Access screen.

  • Change the view of your report to "Design View" by clicking the "View" button on the ribbon. Once the report is in Design View, you can change the report formatting and contents. Modify the formatting by dragging the fields around to your desired location. Add contents by clicking on the "Add Existing Fields" button. Remove contents by clicking on fields in the report and pressing the "Delete" button.

  • Locate one of the macros in the Navigation Pane. Right-click on the macro and select "Design View." Modify the macro by changing the actions within the macro. The actions can be altered by changing the option from the "Action" drop-down list. Save your changes by clicking "Save" on the Quick Access Toolbar.

Related Searches


  • Photo Credit pregunta image by caironbohemio from
Promoted By Zergnet


Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!