Customizing Query Properties

Access 2010 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 10-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 10-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 ...

Get Microsoft® Access® 2010 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.