Question

name the available queries in ms access 2007

Answer 1

Following are the types of Queries available in MS Access Database :

1. Select Query

2. Crosstab Query

3. Action Query  -  Update, Delete, Append

4. Aggregate Query

Answer 2

Answer :

Four types of queries that are available in the MS access 2007.

1. Select query

2. Action query

3. Parameter query

4. Aggregate query

Explanation:

1. Select query

It is used to select the data from one or multiple tables and it displays that which you are needed.  

2. Action query

Action query is used to change the data based on some specific criteria.And it is used to delete the record, update the records and append the data from one table to other table.

3. Parameter Query

We can pass a parameter from one query to other queries such as action query and select query, it is used to get whatever result that you want. The parameter may be a value or a condition.

4. Aggregate query

It is different type of query and it associated with other queries such as action, select or parameter. Instead of passing parameters, it added the items by using selected groups. For example, function such as sum, avg min, max, group by etc.