Microsoft Access Query Types

• Update
  • Make global changes to data in one or more tables
  • Add, change, or delete specified value
• Append
  • Add records from one or more tables to the end of an existing table
  • Useful for appending old records to the end of history or archive table
• Delete
  • Deletes a group of records from one or more tables on the basis of some specified (or non-existent) values in one or more fields

Previous slide

Next slide

Back to first slide

View graphic version