• Append records from one table to another table using an append query
  • Change records as a group using an update query
  • Create a new table from the results of a query with a make-table query
  • Delete a group of records with a query
  • OpenQuery Action
  • Preview records affected by a make-table, delete, append, or update query
  • Run a make-table, append, delete, or update query
  • RunSQL Method
  • View the results of a make-table, append, or delete query
  • View the results of an update query
  • Work with tables or indexes by using an SQL data-definition query
  • BeginTrans, CommitTrans, and RollbackTrans Methods (ADO)