Identify the letter of the choice that best matches the phrase or definition.
A. Displays all records in one table that have corresponding values in the common field in another table
B. Compares the value in a field with a range of values in a criterion
C. Restricts data in a single table to create a temporary subset of records
D. Allows you to ask a question based on one or more tables in a database
E. A special type of Totals query that performs aggregate function calculations on the values of one database field and allows you to determine exactly how your summary data appears in the results
F. An arithmetic formula used to make a calculation
G. Used to test values that can only be true or false
H. A phrase, usually in the form of a question or instruction, enclosed in square brackets
I. A mathematical or statistical operation that you apply to records that meet a query’s selection criteria
J. Includes all of the records from the table on the left in Design view, even if there are no matching values for records in the table on the right
K. Lets you modify data in a table, add records to or delete records from a table, or create a new table based on expressions you enter and criteria you set
L. Includes all of the records from the table on the right in Design view, even if there are no matching values for records in the table on the left
A. inner join
B. comparison operator
C. filter
D. select query
E. crosstab query
F. expression
G. logical operator
H. parameter value
I. aggregate functions
J. left outer join
K. action query
L. right outer join
You might also like to view...
A solid line, a dash, or a dot, when used as a setting to fill the space preceding a tab stop, is a(n) ________
Fill in the blank(s) with correct word
What is stored in the \%SystemRoot%\System32\config folder?
A. Boot files B. The Registry C. Group policies D. System files
Solve the system using a graphing calculator. 
A. 
B. 
C. 
D. Infinite number of solutions
E. No solution
Case-based Critical Thinking Questions Case 2-1 Casey is using XML to store information about the students in the science classes that he teaches. He wants to design a DTD that he can use to validate the XML documents that he uses for this purpose, and he comes to you for help. Casey needs to declare an "address" element that can be used to store a student's address. If he intends to store the address as parsed character data, which of the following is an appropriate declaration for this element?
A. B. C. D.