An Access report lets you present data in a visually appealing way. Also use reports in Access to share data others can't manipulate.
If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database.
In this lesson, you will learn how to create, modify, and print reports.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2013 sample database. You will need to have Access 2013 installed on your computer in order to open the example.
Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries.
Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you want to sort or filter, then select the desired option from the menu.
You might find that your report contains some fields you don't really need to view. For instance, our report contains the Zip Code field, which isn't necessary in a list of orders. Fortunately, you can delete fields in reports without affecting the table or query where you grabbed your data.
When you delete a field, be sure to delete its header as well. Simply select the header and press the Delete key.