Microsoft Office Tutorials and References
In Depth Information
Manipulating the Data in a Report
Access won’t automatically update your reports just because you modified
any data that the report displays.
Manipulating the Data in a Report
After you create a report, you can manipulate the data displayed in that
report, such as sorting data in ascending or descending order, or applying a
filter that only displays data that meets a certain criteria.
By using a report, you get a different view of your data. By manipulating
the data in a report, you create alternate views of the same report. Some
common ways to extract information from a report include counting, sorting,
and filtering.
Switching a report to Layout view
To manipulate data in a report, you must first display your report in Layout
view, which you can do by following these steps:
1. Double-click on the report name in the left pane of the Access
window.
Access displays your chosen report.
2. Click the Home tab and click the downward-pointing arrow
underneath the View icon in the Views group.
A pull-down menu appears.
3. Choose Layout View.
Access displays your report in Layout view, which highlights an entire
column (field) at a time, as shown in Figure 18-6.
Counting records or values
To make reports more useful, you can have Access count and display
information, such as which products are selling the best or the total dollar
amount of each sale so you can tell exactly how much money your company
made during March. By counting records or adding up values stored in fields,
Access can help you better interpret the data displayed in a report.
 
Search JabSto ::




Custom Search