Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see
304356.
REFERENCES
For more information about modifying query properties, click
Microsoft Access Help on the
Help menu, type
change query properties in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
You can also view this information on the World Wide Web by clicking the
Working with Queries topic on the Microsoft Access 2000 Help page at the following Microsoft Web site:
For additional information about creating crosstab queries with multiple value fields, click the article number below
to view the article in the Microsoft Knowledge Base:
209143 ACC2000: Creating a Crosstab Query with Multiple Value Fields
For additional information about creating select queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304361 ACC2000: How to Create a Select Query in Microsoft Access
For additional information about creating parameter queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304353 ACC2000: How to Create a Parameter Query in Microsoft Access
For additional information about how to convert a select query to an action query, click the article number below
to view the article in the Microsoft Knowledge Base:
304355 ACC2000: How to Convert a Select Query to an Action Query
For additional information about modifying query properties, click the article number below
to view the article in the Microsoft Knowledge Base:
304357 ACC2000: How to Modify Query Properties in Microsoft Access
To download a sample Microsoft Access database that contains over 20 query examples, including the techniques described in these articles, see the following article in the Microsoft Knowledge Base:
207626 ACC2000: Access 2000 Sample Queries Available in Download Center