Free E-Books

Unless you want to view all
the records from a single table, bind your report to a query. Even if you are accessing data from a
single table, using a query lets you create your report on the basis of a particular search criterion
and sorting order. If you want to access data from multiple tables, you have almost no choice but
to bind your report to a query. In the examples in this chapter, all the reports are bound to a query
(even though it is possible to bind a report to a table).
Access lets you create a report without first binding it to a table or query, but you will
have no controls on the report. This capability can be used to work out page templates
with common text headers or footers such as page numbering or the date and time, which can serve
as models for other reports. You can add controls later by changing the underlying control source of
the report.
Throughout the rest of this chapter, you learn the tasks necessary to create the Products Display
Report (a part of the first page is shown in Figure 9-21).


Pages:
711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735