Show Me Microsoft Office 2003

When you create a report from scratch in Design view, three sections appear: Page Header, Detail, and Page Footer. Once you create the report, you need to populate it with data. You can add bound controls ”fields of data from a table or query ”directly from the Field List, or you can add other types of unbound controls ”text boxes, labels, pictures, buttons , and so on ”from the Toolbox. In Design view, you see two parts for every control: the control itself and its corresponding label. When you move a control, its corresponding label moves with it.

Create or Modify a Report in Design View

In the Database window, click Reports on the Objects bar, and then click New, or click a report, and then click Design; skip step 2.

In the New Report dialog box, click Design View, select the table or query on which to base the report, and then click OK.

Use the Toolbox and Field List to create or modify a report in Design view.

To view or hide headers and footers, click the View menu, and then click Report Header/Footer or Page Header/Footer.

Add a Bound Control

Display the report in Design view, select the fields you want to include from the Field List; press Shift or Ctrl while you click to select multiple fields.

Drag the selected field or fields to the section in which you want the field to appear. Two boxes appear for each field: one containing the label and one for the field values.

Add an Unbound Control

Display the report in Design view, and then click the Toolbox button to the control you want to add, such as a text box, a horizontal line, or a shape.

Drag to draw a box in the location where you want the control to appear.

Did You Know?

You can create an unbound report . Create a report without choosing a table or query on which it is based. Such reports are called unbound reports. A dialog box is an example of an unbound report.

Adjust Page or Section Spacing

Display the report or form in Design view whose page or section size you want to change.

Position the mouse pointer over the edge of the page or section.

Drag the resize pointer to a new location.

Did You Know?

You can display or hide the ruler and grid . The ruler and grid provide guides to help you arrange your controls. Click the View menu, and then click to select Ruler or Grid.

Категории