Most of the Access 2010 Web Database templates include a tab named Report Center, where you can preview and print the reports that were included in the template. If you create a new report, you can add it to the Report Center tab by following the instructions in this video.
In the video
Note Depending on the complexity of your report, some additional steps may be required to add it to the Report Center. This procedure will work for most situations, where the goal is to display and print a simple report.
- Click the Report Center tab.
- On the Home tab, in the Views group, click View, and then click Layout View.
- If the Property Sheet is not already displayed, press F4 to display it.
Note You might need to “undock” the Property Sheet from the right side of the Access window so that you can see the Select a Report buttons. Place the pointer at the top of the Property Sheet, and then drag it to the left until the report buttons are visible.
- On the Design tab, in the Controls group, click Button, and then click in the first empty cell below the existing report selector buttons.
- Select the text in the new button, and type the text that you want displayed.
- Click one of the existing buttons, and then click the Event tab in the Property Sheet.
- In the OnClick event box, click the Build button.
- On the Design tab, in the Collapse/Expand group, click Expand All to display the full macro.
- Select all of the actions by pressing CTRL+A, and then copy them by pressing CTRL+C.
- Close the Macro Builder, without saving changes.
- Select the new button, and then in the OnClick event property box, click the Build button.
- Paste in the macro actions by pressing CTRL+V.
- Edit the action arguments to that they include the name of your new report instead of the existing report.
- On the Design tab, click Save, and then click Close.
- On the Home tab, in the Views group, click View, and then click Form View.
The new button should be ready to use.
For more information about the BrowseTo macro action that is seen in this video, see the blog post Navigate your Access 2010 database by using "BrowseTo".
Top of Page