Jump to content

How to Create Reports in Access 2010

  kbnotes's Photo
Posted Mar 28 2010 11:43 AM

Here's an easy way to create reports in Access 2010:

Reports give you the ability to present your table and query data in an accessible format. In some ways, reports and forms are very similar—both types of database objects let you display your table records and query results at one record per page, in a series of columns or rows, or in a custom layout you create in Design view. The difference between forms and reports is that in addition to presenting your table and query data, reports let you summarize your data. For example, you can create a report that not only lists every order made by every customer, but also finds the total amount of all orders for a particular customer. It’s possible to do the same thing with queries, but the Report Wizard streamlines the process greatly, saving you time and effort while producing valuable information.

Although it might be possible to generate useful reports from the data in a single table or query, it’s very likely that you’ll want to combine data from more than one table or query into a single report. For example, you might have product data in one table and supplier data in another table, and then want to create a report where full supplier contact information accompanies the product information. You can do that by creating a report using the Report Wizard:

  • Click the Create tab.
  • Click Report Wizard.
  • Click the down arrow and then choose the first table or query from which you want to draw values for the report.
  • Click a field in the Available Fields box and then click either of the following buttons: Add to add the selected field or Add All to add all fields to the report.
  • Click Next. If you created a report based on a query that reads in primary key values from more than one table, a wizard page appears asking you to select a preliminary grouping criteria for the report’s records. Click the name of the field by which you want to group and then click Next.
  • If necessary, click the first field by which you want to group the report’s contents and then click Add. Repeat to add grouping levels.
  • Click Next.
  • Click the first field’s down arrow, and click the first field by which you want to sort the report’s contents.
  • If necessary, click the sort options button to toggle between Ascending or Descending.
  • Click Next.
  • Use the controls on the remaining wizard pages to select a layout, page orientation, style, and name for the report. When you’re done, click Finish.

Here’s a tip: You can remove fields from the Selected Fields pane of the Report Wizard by clicking the field name and then clicking either Remove, to remove the selected field, or clicking Remove All, to remove all fields.

(From the forthcoming Microsoft® Access® 2010 Plain & Simple.)

2 Replies

  Excalibur25's Photo
Posted May 16 2012 03:56 PM

So how would you go about having a report that has different fields from three different tables on one report ? Would this need to be have a relationship in order for this to happen?
  lauraisabella's Photo
Posted Jan 17 2014 12:21 AM

You can easily create different types of reports in Microsoft Office Access, ranging from the simple to the complex. you will usually find it is easiest to create your report by using the Report Wizard. The Report Wizard is a feature in Access that guides you through a series of questions and then generates a reports based on your answers.