Adding a Page Number

You may want to include page numbers at the bottom of your report for reference. Under the Insert menu, select the Page Numbers option.

By Admin

Access Query Tips

Use indexes on the fields in the criteria section when using the query design screen. In other words, index the fields on the right hand side of a where clause.

By Admin

Setting a Page Header

A Page Header is the text that displays at the top of the report page. To create a Page Header, select the ‘Label’ icon from the Toolbox. The Label icon has the capital and small letter A's.

By Admin

Saving a Report

The final step is to save the report object. Note: This can be done at any time during report creation.

By Admin

Main Form and Subform Concepts

The relational data refers to one-to-many relationship between records that are stored in separate tables. A one-to-many relationship is an association between two tables in which the primary key value of each record in the primary table corresponds ...

By Admin