How to Run Reports in Access
An Access report visualizes data in an organized format from one or multiple sources, such as a table or query. You can run a customized report without re-entering the data. For example, you may use data from an employee table and a sales table to display employees who live in Sacramento, California, and have met or exceeded their quarterly sales goal. The generated report may be viewed on the screen, printed or emailed to others.
Open the database you're working on in Microsoft Access.
Select "Reports" from the navigation pane.
Double-click the report you want to run. To switch to "Report View," select the "Home" tab and choose "Report View" from the "Views" group. The report displays on your screen.
Click the Office Button and select "Print." Press "OK" in the Print dialog box to print the report.
Click the Office Button and select "E-mail" to email the report. The "Send Object As" dialog box appears.
Pick the output format for the report and click "OK." Enter the recipient's email address in the "To" field and click the "Send" button.