Customizing Query Properties

Access 2007 provides a number of properties associated with queries that you can use to control how a query runs. To open the property sheet for queries, click in the upper part of a Query window in Design view outside of the field lists and then click the Property Sheet button in the Show/Hide group of the Design contextual tab. Figure 8-41 shows the property sheet Access provides for select queries.

The property sheet for select queries lets you customize the way the query works.

Figure 8-41. The property sheet for select queries lets you customize the way the query works.

Use the Description property to document what the query does. This description appears next to the query name when you view query ...

Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.