Computer Science, asked by satvikshyam9gmailcom, 6 months ago

B. Which are the two types of queries? Explain each.​

Answers

Answered by gautamkumargupta692
1

Answer:

Parameter Query: A query that asks you for one or more pieces of information before displaying the datasheet.

AutoLookup Query: A query that fills in information for you. (AutoLookup queries are covered later in this tutorial.)

Action Query: Action queries change your data based on some set of criteria. Action queries can delete records, update data, append data from one or more tables to another table, and make a new table.

Crosstab Query: Most tables in Access, including ones generated by queries, have records down the side and field names across the top. Crosstab queries produce tables with the values from one field down the side and values from another field across the top of the table.

A crosstab query performs a calculation - it sums, averages, or counts data that is categorized in two ways, as defined by the row and column labels.

Answered by kantaprasadsharma561
0

Explanation:

thanks for free points..

Similar questions