With the help of an example, briefly state the meaning of parameter queries.
Answers
Explanation:
Accountancy
With the help of an example, briefly state the meaning of parameter queries.
November 22, 2019avatar
Saraswati Kumar
SHARE
ANSWER
A parameter Query is a query that asks you for one or more pieces of information before displaying the datasheet. A parameter query prompts the user to enter Parameters, or criteria through an input box, for selecting a set of records.
A parameter query is useful when there is a need to repeat the same query with different criteria. The criteria, is not constant as in the case of the simple query. While extracting the transactions to prepare ledger accounts, the same set of queries need to be executed for different account codes. Consider the following SQL statement.
PARAMETERS AccountName Text (255)(255)
SELECT Name
FROM Accounts
WHERE Code == AccountNo
In the above query, the PARAMETERS clause is meant to declare the variable Account No. This SQL statement, when executed, prompts the user to provide the value of Account No.
A query, that can be create and updated to reflect a new search entry easily is called a Parameter query.
Explanation:
- While opening a parameter query a new dialogue box will appear which will ask you type in the required search term.
- This input is then processed and the results for the search is reflected on the screen. Being simple to create makes Parameter query an advanced query option.
- Make sure your entry is prompt for the parameter query to get searched.
To learn more:
what is parameter query
https://brainly.in/question/12643323
creating parameter query with steps.
https://brainly.in/question/5833125