Viewing Your Query
After you create a query, you can open it in any of these views:
- Design view displays the Design view where you can select tables, fields, create criteria, expressions, define sort order, and all the other things you need to do to define a query.
- Datasheet view displays the fields from the query in a datasheet, just as if you were looking at a table datasheet.
- SQL view displays the query definition as a statement in SQL (Structured Query Language).
- PivotTable and PivotChart views summarize and chart the data from the query.
When you open a query, you can open it in Datasheet or Design view by selecting the query name in the Database window and clicking the Open button (for Datasheet view) or the Design button (for Design view).
When a query is already open, you can switch between Design and Datasheet views by clicking the View button (the left-most button on the toolbar). To display SQL PivotTable or PivotChart view, click the downwardpointing triangle at the right side of the View button. Choose the view you want.
In this tutorial:
- Creating Select Queries
- Types of Queries
- Creating a Query in Design View
- Creating a Query with the Simple Query Wizard
- Viewing Your Query
- Tips for Creating a Query
- Editing a Query
- Sorting a query
- Changing the format of a query field
- Limiting Records with Criteria Expressions
- Using dates, times, text, and values in criteria
- Using multiple criteria
- Using lookup fields in criteria
- Working with Multiple Related Tables
- Working with Query Datasheets
- Saving Queries