How to Make Multi-Column Reports in Microsoft Access 2007
Lisa Mills
January 17, 2011
One of the inherent uses of using the database software is that one can create reports in it. Access 2007 report is available in 2 report formats i.e. tabular format and columnar format. A tabular report is more likely same as a data sheet which most of the people have seen in the Excel 2007 or any other spreadsheet program. On the other hand, a columnar report provides a single column to every record. One can also make multi-column reports in 2007 version of Microsoft Access.
A multi-column report allows you to report the data in a neat and efficient way within a single page. If you want to set one report, then keep in mind that you page will be going to divide into two or more columns in which your data will appear. Into the layout mode, you will be only working with single column. The effect of multi-column will appear in the print or preview option of the multi-column report page.
One thing should be very clear that the margins you will set in your "master column" will automatically apply to each and every column on the page. The only thing you need to determine is the visible width of each margin. Ensure that data should not exceed the width as established by you. One can find the horizontal ruler which is present at the top of the master column which shows the width of your column. Another way of setting the width is going in the Layout > Ruler command. Once your width is set and adjusted, then you are all set to enter the data.
If you want to make any adjustments to the page setup, column setup or printing options, then you can use the "Page Setup" tab. To do changes in the column setup, go to Column tab under the Page Setup dialogue box. From the Grid Setting, you can set the number according to your need and moreover you can also set the column and row spacing. Spacing is the space between the rows or column; so it is very essential to set the appropriate spacing so that the work looks more pleasant.
When you are finished with setting up of your multi-column report, then click Ok and preview the report to see that it appears in the same way as you want.
Author writes for access report, report in ms access and access 2007 report.
A multi-column report allows you to report the data in a neat and efficient way within a single page. If you want to set one report, then keep in mind that you page will be going to divide into two or more columns in which your data will appear. Into the layout mode, you will be only working with single column. The effect of multi-column will appear in the print or preview option of the multi-column report page.
One thing should be very clear that the margins you will set in your "master column" will automatically apply to each and every column on the page. The only thing you need to determine is the visible width of each margin. Ensure that data should not exceed the width as established by you. One can find the horizontal ruler which is present at the top of the master column which shows the width of your column. Another way of setting the width is going in the Layout > Ruler command. Once your width is set and adjusted, then you are all set to enter the data.
If you want to make any adjustments to the page setup, column setup or printing options, then you can use the "Page Setup" tab. To do changes in the column setup, go to Column tab under the Page Setup dialogue box. From the Grid Setting, you can set the number according to your need and moreover you can also set the column and row spacing. Spacing is the space between the rows or column; so it is very essential to set the appropriate spacing so that the work looks more pleasant.
When you are finished with setting up of your multi-column report, then click Ok and preview the report to see that it appears in the same way as you want.
Author writes for access report, report in ms access and access 2007 report.
Print
Email
