Creating a Simple Report in Microsoft Access 2007
Microsoft Access 2007 has taken much of the drudgery and confusion out of creating a report, especially in the design mode. Let’s look at the steps for creating a report directly from a table and then redesign the report for a desired grouping (by sales area in our example).
To create a report from a table, do the following steps:
♦ Open the table in the datasheet (table) view.
♦ Click on the Create tab.
♦ In the Reports group, click on the Report icon.
♦ A report based on the table will open in the new Layout view.
In Access 2007, you can rearrange the column widths, and locations. You can also reformat numerical data (dates, numbers, currency) using the groups on the Format tab. (See the screenshot of the report in layout view.)
To change or add groupings to a report, do the following steps:
♦ Click on the View dropdown list in the upper left of the report window and select Layout.
♦ Click on Add a group beneath the blue Group, Sort, and Total bar at the bottom of the report window.
♦ Select the name of the field you wish to sort on. (In our screenshot example, we chose the Area field.)
The newly grouped report appears and can be tweaked further. We added subtotals to each Area grouping by selecting More > and adding a footer and specifying that the sales be subtotaled.