How to Format Access Reports
Microsoft Access is a database management application that can be used to store and access structured types of data. Access can be used to generate queries that search the data, as well as reports that provide information about the data that is stored in the database. Access reports can be formatted to provide information about the relationships between any type or category of data that is stored within the database. This provides a simple means for evaluating the data and making any necessary changes to improve data storage.
Other People Are Reading
Instructions
-
-
1
Navigate to your Microsoft Access database and double-click on the file to open it.
-
2
Click the "Create" tab at the top of the screen, then select the "Report Wizard" button.
-
-
3
Select the drop-down menu under "Tables/Queries" to locate the table or query with your desired field, then click the field to select it. Click the ">" button to move it to the "Selected Fields" window. Repeat this step for each field that will be included on your report. Click the "Next" button.
-
4
Click the drop-down menus at the right side of the window to determine the sorting order for your report. You also can click the "Ascending" or "Descending" button to the right of each selection to have the list sorted in that manner. Click the "Next" button.
-
5
Select an option under "Layout" and "Orientation" to determine how your report will be displayed. Click the "Next" button.
-
6
Click an option from the list on the right side of the window to select the style for your report. Click the "Next" button.
-
7
Type a name for your report into the text field at the top of the screen, then select the "Modify the report's design" option. Click the "Finish" button.
-
8
Make any additional changes to your report by using the "Format," "Arrange" and "Page Setup" tabs at the top of the screen. Click the "View" button at the top left of the screen at any time to see what your report will look like.
-
9
Click the Office button in the top left corner of the screen and select the "Save" option to preserve the changes to your report.
-
1
Tips & Warnings
If you are unable to create a report that includes all of your data from multiple tables, then you may have a problem with your table relationships. Experiment with linking fields in different tables until you are able to generate a report on your desired data. Relationships can be created from the "Datasheet" tab the the top of the window.
