Logo 
Search:

MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

Differentiate between crosstab query & Action query.

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 3431

Answer:

A crosstab query displays summarized values (sums, counts, and averages) from one field in a table and groups them by one set of facts listed down the left side of the datasheet and another set of facts listed across the top of the datasheet.

An action query is a query that makes changes to many records in just one operation. There are four types of action queries: delete, update, append, and make-table.Delete query is used to delete records ,Update query is used to make some universal changes/updation, Apend query is used to append records from a query/table to some existing table and Make-table query is used to create a new table from all or part of the data in one or more tables.

Share: 
 

Didn't find what you were looking for? Find more on Differentiate between crosstab query & Action query. Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: