1/18
Looks like no tags are added yet.
A database object used to ask questions about data stored in database tables.
Query
What is produced by a query?
virtual table (result table)
Specifies the fields or custom expressions included in the query.
Field Row
Displays the name of the source table for each field.
Table Row
Allows records to be sorted in ascending or descending order.
Sort Row
Controls whether a field is displayed in the query results or hidden while still active.
Show Checkbox
Contains the conditions that must be met for a record to appear in results.
Criteria Row
Rows below the primary criteria row used to specify alternative criteria.
Or Rows
How do you perform calculations in a query?
Entering a custom column title followed by a colon and an expression in the Field row
How do you concatenate fields (like a first name and a last name) in a query?
Using the ampersand (&) or plus sign (+) operator
What does it mean to sort data in a query?
organizing the query results in a specific sequence based on values in one or more selected fields.
What are criteria in a query, how is it defined?
Help you zero in on specific items in a database so that only matching records appear in results.
Defined by entering conditions into the Criteria row of the design grid under the appropriate field.
Requires that both conditions are satisfied; conditions are entered side-by-side in the same Criteria row.
AND
Requires that one or more conditions are satisfied; conditions are entered across separate or: rows.
OR
A symbol (such as >, <, or =) used in criteria to compare values and filter data.
comparison (aka relational) operator
(such as And, Or, Xor, and Not) is used to combine, evaluate, or modify multiple conditions.
logical operator
a field that has no value assigned to it.
handled using functions like IsNull(expression), which evaluates whether an expression contains no valid data and returns -1 (True) or 0 (False).
Null field
What is a parameter driven query?
A type of query where the user provides the criterion at run time instead of in advance.
specialized queries used to change data in underlying tables and modify the database.
Action queries