Parameter+Query

= =

PARAMETER QUERY 

Parameter Query is a very useful feature of Access. It serves multiple needs by pulling out data based on a criterion that we enter each time we run the query. It also saves our time as to get the same information using simple queries we would have to create lots of queries that would filter data by the specific criteria we need. It is a fast tool to collect information for reports and forms.

** __Three way of prompting the users :__ ** __ ** 1. ** ** prompting from the criteria row ** __ __ ** 2. ** ** prompting from the field row ** __ __ ** 3. ** ** by multiple prompts ** __

=// Prompting from the criteria row //=
 * The most common type of a parameter query that we create by placing the message in square bracket in the criteria row. It can be combined with other criteria. **
 * The user will see a dialog box with a blank space to type in a criterion. **

= ** //Prompting from the field row// **  =

**This option is used in the case when we need to affect data by mathematical calculations for example to find out how the data will change when we increase it by 20%** 
 * The field parameter will let us enter a variable. **

= ** //Multiple Prompts// **  =

**It is possible to create multiple prompts with order or without it.**
 * To set up the order for our prompts we go to **
 * DESIGN-> SHOW/HIDE ->PARAMETERS **
 * And we type or copy the parameters from Criteria or Field row in the order we want them to appear. **
 * For simplicity we can also set a data type for the parameters to inform a user what type of data to enter. **

 <span style="font-family: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">
 * Parameter Query is be a very helpful tool for filtering data. Once we create it we just pick information we need at a time and have them ready in seconds. Each time we can select different criterion. It is easy, fast and suits various needs. **


 * <span style="font-family: 'Calibri','sans-serif'; font-size: 9pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Beata Marek **
 * <span style="font-family: 'Calibri','sans-serif'; font-size: 9pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">INFO273-12 **
 * <span style="font-family: 'Calibri','sans-serif'; font-size: 9pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Based on “Picture Yourself Learning Microsoft Access 2007”Faithe Wempen p65-67 **