• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 16. Working with Simple Reports ... > Categorizing Types of Access Reports

Categorizing Types of Access Reports

Reports created by Access fall into six basic types, also called layouts, that are detailed in the following list:

  • Single-column reports— List in one long column of text boxes the values of each field in each record of a table or query. A label indicates the name of a field, and a text box to the right of the label provides the values. Access's AutoReport feature can create a single-column report with a single click of the toolbar's AutoReport button. You seldom use single-column reports because the format wastes paper.

  • Tabular reports— Provide a column for each field of the table or query and print the value of each field of the records in rows under the column header. If you have more columns than can fit on one page, additional pages print in sequence until all columns are printed; then the next group of records is printed. The AutoReport feature also can create a tabular report automatically.

  • Multicolumn reports— Created from single-column reports by using the “newspaper” or “snaking” column approach of desktop-publishing and word-processing applications. Information that doesn't fit in the first column flows to the top of the second column, and so on. The format of multicolumn tables wastes less paper, but the uses are limited because the column alignment is unlikely to correspond with what you want.

  • Groups/totals reports— The most common kind of report. Access groups/totals reports summarize data for groups of records and then add grand totals at the end of the report.

  • Mailing labels— A special kind of multicolumn report that prints names and addresses (or other multifield data) in groups. The design of the stock adhesive label on which you are printing determines how many rows and columns are on a page.

  • Unbound reports— Contain subreports based on unrelated data sources, such as tables or queries.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint