When you pose a question to Access, or any other database management system the question is called a _____. A ______ is simply a question represented in a way that Access can understand.
Two special _________ are available in Microsoft Access. _______ are symbols that represent any character or combination of characters.
The other wildcard symbol is the __________ which represents any individual character.
To do this, you create a _________, which is a QUERY that prompts for input whenever it is run. Are especially useful in cases where the same QUERY is run frequently with slight changes to one or more or the QUERY'S criteria. By using _________ rather than specific values, you can enter the values for the criterion as the QUERY is run, rather than having to change the QUERY design.
If you want something other than the exact match you must enter the appropriate _________. The __________ are > (greater than), >= ( greater than or equal to ), Not (not equal to), <(less than), and <= (less than or equal to).
Often you will have more than one criterion that the data for which you are searching must satisfy. This type of criterion is called a __________________.
Two types of compound criteria exist : In an ________, each individual criterion must be true in order for the com pound criterion to be true.
Primary Sort Key
If you are sorting on more than one field (such as sorting by an amount paid within trainer number), the more important field (Trainer Number) is called the __________.
Access will draw a line called a, _______, between matching fields in the two tables indicating that the tables are related.
The ________ indicate which records appear in a JOIN of the query. You modify the ________ by right-clicking on the join line.
Is a function that performs some mathematical ________ against a group of records.
Sometimes queryies include ______, which means groups of records are created that share some common characteristic.
Cross Tab Query
________ are useful for summarizing data; the result (or the middle) calculates a statistics (sometimes sum, average, count, etc.)
You need to ______ the tables that is to find records in the two tables that have identical values in matching fields.
To omit duplicates from a query, use the _______ and change the Unique Values property to Yes.
Answer Field Name:[Field Name]Operator[Field Name]
What is the "syntax" for a calculated field entry?
In order to create a parameter query, you enter a prompt on the Criteria line of the design grid, enclosed in _____.
To find all companies that start with a J, what would you enter on the criteria line of the appropriate field?
To find all Technicians with the last name of Johnson or Johnsen, what would you enter on the criteria line of the approriate field?
When entering a numerical criterion, is it necessary to enter the dollar signs and comma separators?
To create an OR query, enter the criteria on ______; one criterion goes on the criteria line and the other goes on the or line.
Which one represents a row that includes a check box to control which fields appear in the results of query?
To chance the caption for a field in a query, select the ______ button and enter the new caption on the appropriate line.