Preview records affected by a make-table, delete, append, or update query

• In query Design view, click View on the toolbar to display the query in Datasheet view.

  For this query	The datasheet displays
  Update	The fields to be updated.
  Delete	The records to be deleted.
  Make-table	The fields to be included in the new table.
  Append	The records to be added to another table.