Compare and contrast the four types of action queries

What will be an ideal response?

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.

Computer Science & Information Technology

You might also like to view...

A stacked column chart displays multiple columns for each category

Indicate whether the statement is true or false

Computer Science & Information Technology

Match the project requirement terms to the descriptions

I. Functional Specification A. Related to software and hardware capabilities, such as the browser II. Functional Requirements B. Needs imposed by hardware, software, and networking III. Environmental Requirements C. Used to write out program logic using English words IV. Technical Requirements D. Needs people have for the program, both present and future V. Pseudo-Code E. Key requirements and design elements for a project

Computer Science & Information Technology