Compare and contrast the four types of action queries

Question

What will be an ideal response?

Answer 1

A Make Table query selects data from one or more tables, and then automatically loads the resulting dataset into a new table once you run the query. That new table can exist in the database that you have open and build a new table within the opened database or create it within the same database. You can also create the make table query in one database and then have Access build the table in another database.
You can use an Append query when you need to add new records to an existing table by using data from other sources, such as an Excel workbook, a Word document, a text file, or another database. An Append query selects records from one or more data sources and copies the selected records to an existing table.
An Update query can be used to add, change, or delete data in one or more existing records. Update queries are similar to the Find and Replace dialog box, but much more powerful.
You also have the option of using a Delete query depending on the type of deletion you need to perform. A Delete query is used to remove entire records from a table at one time. Delete queries remove all the data in each field, including the primary key. A Delete query cannot be used to delete an entire table from the database.