Question

difference between select query and parameter query​

Answer 1

Explanation:

A select query is the most common type of query. ... A parameter query is a query that when run displays its own dialog box prompting you for information, such as criteria for retrieving records or a value you want to insert in a field.

Answer 2

Answer:

• Select Query:-

The select query helps in retrieving of data from one or more tables.

It displays the records in a data sheet.

It also helps in grouping the data to calculate the sum, average, etc.

• Parameter Query:-

It is like select query but it asks for input before it runs.

This query uses the input as criteria that controls the result.

It retrieves the data from the table according to the input.

There are other twosearch types of queries namely action query and crosstab query.

In short, the action query helps in creating new tables and changing the data by adding, deleting and updating the data.

Similarly, in short, the crosstab query helps in categorising the data in terms of two categories that is row headings and the column headings.