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...

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

A. shrink B. size C. scale D. scroll

Computer Science & Information Technology

In the commercial and office environment, the most widely used broadband technology is ____.

A. ATM B. token-ring C. Ethernet D. SONET

Computer Science & Information Technology

Which option would clear a PivotTable filter on a State field?

A. Select the filter arrow on the Rows header and select clear filter. B. Select the filter arrow on the Columns header and select clear filter. C. Drag the State field off the FILTERS area. D. Click the funnel icon to the right of the State filter and then select All and then click OK.

Computer Science & Information Technology

Which scheduling algorithm was noted as having a high variance in turnaround time?

What will be an ideal response?

Computer Science & Information Technology