How to Select Query Criteria in Access

Select queries can be created using the query design option in Access. Use select queries to select fields you want to appear in your query. This simple query is helpful when you need to see information from tables and queries. As the fields are defined in the design view of the query, the results are displayed in the query datasheet view. Select query criteria lets you further refine your query.

Instructions

1. Open Access 2010, and select a database. Click the "File" tab and select "Open." Review the recently used databases in the file menu. Select a database from the list to open it.

2. Click the "Create" tab, and select "Query Design." The "Show Table" dialog box opens. Add a table to the query by clicking the table name and selecting "Add." Close the "Show Table" dialog box by clicking the "Close" button.

3. Add fields to the query by clicking the field name and dragging the name to the query. Add criteria to your query in the "Criteria" field. For example, if you want to see the orange widgets in your collections, change the criteria of your widget color to "Orange."

4. Run the query by clicking the "Run" icon. Review the orange widgets in your simple Access query.

References

• Microsoft: Examples of query criteria

Resources

• Microsoft: Access How To & Help