Microsoft Office Tutorials and References
In Depth Information
Creating a Simple Report
Next, you’ll save the form with the name “ContractData” in the Belmont
database. Then the form will be available for later use.
5. Click the Save button
on the Quick Access Toolbar. The Save As dialog
box opens.
6. In the Form Name box, click at the end of the highlighted word “Contract,” type
Data , and then press the Enter key. Access saves the form as ContractData in the
Belmont database and closes the dialog box. The tab containing the form now
displays the name ContractData.
7. Click the Close ‘ContractData’ button
on the object tab to close the form.
Saving Database Objects
In general, it is best to save a database object—query, form, or report—only if you
anticipate using the object frequently or if it is time consuming to create because all objects
use storage space on your disk. For example, you most likely would not save a form you
created with the Form tool because you can re-create it easily with one mouse click.
(However, for the purposes of this text, you usually need to save the objects you create.)
After attending a staff meeting, Oren returns with another request. He would like to
see the information in the Contract table presented in a more readable format. You’ll help
Oren by creating a report.
Creating a Simple Report
As noted earlier, a report is a formatted printout (or screen display) of the contents of one
or more tables or queries. You’ll use the Report tool to quickly produce a report based on
the Contract table for Oren. The Report tool creates a report based on the selected table
or query.
To create the report using the Report tool:
1. With the Contract table open in Datasheet view, click the Create tab on the
Ribbon.
2. In the Reports group, click the Report button. The Report tool creates a simple
report showing every field in the Contract table and places it on a tab named
“Contract.” Again, Access assigns this name because the object you created (the
report) is based on the Contract table. See Figure 1-23.
Trouble? The records in your report might appear in a different order from the
records shown in Figure 1-23. This difference will not cause any problems.
Search JabSto ::




Custom Search