MS Access

Working with Reports

It's easy to print a simple list of records in a table or query just click the Print button on the toolbar. But if you want your printed hard copies to look professional and include calculations, graphics, or a customized header or footer, you'll need to create a report. Reports present information from tables and queries in a format that looks great when printed.

Reports can also summarize and analyze the information in your database. For example, a report might tell you which of your employees had used the most sick days for the past year. Here are just a few examples of how reports work well for presenting information:

  • Formatting Options: Change the type, size, and color of the fonts used in a report or add lines, boxes, and graphics.
  • Sorting and Grouping Options: Reports are great for summarizing and organizing information. For example, you could create a report to total sales by day, week, or month.
  • Combine Data from Linked Tables: One report can display data from several related tables or queries.

This tutorial explains all the ins and outs of creating and working with reports.