The easiest way to create a query is to use the query wizard. The Simple Query Wizard begins by prompting you to select the database fields you need. You can select fields from tables. You can also select fields from preexisting queries. For example, if you were retrieving a list of baseball players from an National League table, the wizard would prompt you to choose fields to include in your query, such as each player’s name, team, etc.

The wizard also enables you to group and summarize data, which isn't necessary for simple queries but can help you analyze more complex data.

After you create your query, the wizard can run it, or the wizard can take you to Design view. In Design view you can specify criteria and refine your query. For example, you could specify in Design view that the retrieved list show only players in the American League and that it be sorted by the player’s last names.

The Simple Query Wizard begins by prompting you to select the database fields you need. You can select fields from tables. You can also select fields from preexisting queries. For example, if you were retrieving a list of baseball players from an National League table, the wizard would prompt you to choose fields to include in your query, such as each player’s name, team, etc. The wizard also enables you to group and summarize data, which isn't necessary for simple queries but can help you analyze more complex data. After you create your query, the wizard can run it, or the wizard can take you to Design view. In Design view you can specify criteria and refine your query. For example, you could specify in Design view that the retrieved list show only players in the American League and that it be sorted by the player’s last names.

Understanding Databases|Terms|Parts | Creating a Database | Creating a Table |
Creating a Report | Creating a Query | Woodbridge Campus Homepage |

Last update April 25, 2005
© Diane D. Mickey, 2005
email:  dmickey@nvcc.edu