About the data outline

Microsoft Office Access 2003

Show All Show All

About the data outline

The data outline displays a tree view of the data model of a data access page. It lists the record sources, fields, and calculated controls of a page. Because the field list of a page does not show the contents specific to a page, you can use the data outline to review the structure of a page. You can also select the objects displayed in the data outline, set their properties, define and edit relationships between record sources, and delete fields and record sources.

The following illustration shows the Orders page with two group levels. The inner group level contains fields from the OrderDetails table and a calculated control named Value. In the outer group level, the header section contains fields from the Orders table and the footer section contains a calculated total control named OrderValue.

Data access page with two group levels

The following illustration shows the data outline for the Orders page.

Data outline for Orders page

Callout 1 The RecordsetDef object, which contains one or more record sources

Callout 2 The underlying record sources

Callout 3 Primary key fields

Callout 4 Data fields

Callout 5 Aggregate field

Callout 6 Calculated field