Using Reports to Make Data Meaningful to Others

In Access reports can be more meaningful to others. Learn how to create reports in Access so others can understand the data you're presenting.

Creating a report based on a query

Access 2007 can also create a report using a query as the source. The process for creating a report based on a query is identical to the process for creating a report based on a table, which was outlined on the previous page. And just like when making a report from a table, every field and record that appears in the query results will appear on the report.

It's possible to limit the number of records in a report, but only if the report was based on a query. The limit is set in the query itself, using the query design screen.

To limit the number of records in a report: