Free E-Books

The process of creating a report
involves several steps:
n Defining the report layout
n Assembling the data
n Creating the report design using the Access Report Design window
n Printing or viewing the report
Defining the report layout
You should begin by having a general idea of the layout of your report. You can define the layout in
your mind, on paper, or interactively using the Access Report Designer. Good reports can first be
laid out on paper, showing the controls needed and the placement of the controls. Very often, an
Access report is expected to duplicate an existing paper report used by the application??™s consumers.
Assembling the data
After you have a general idea of the report layout, you should assemble the data needed for the
report. Access reports use data from two primary sources: a single database table, or a recordset produced
by the query. You can join many tables in a query and use the query??™s recordset as the record
source for your report. A query??™s recordset appears to an Access report as if it were a single table.


Pages:
683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707