MS-Access / Getting Started

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.

[Previous] [Contents] [Next]