Starting from Scratch—A Simple Report

In a contact tracking application, the user is going to want to look at recent events and perhaps work through a list of events that require follow-ups. Although the user could search for events in a form, the application should also provide a report that lists events by contact and shows the phone numbers the user needs. This report can be filtered by the application to print out only recent and upcoming events.

Most reports gather information from several tables, so you’ll usually design a query that brings together data from related tables as the basis for the report. In this section, you’ll build a relatively simple report to list contact events as you tour the report design facilities. The report you’ll ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.