IS201: Queries [Midterms]

0.0(0)
Studied by 3 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/18

encourage image

There's no tags or description

Looks like no tags are added yet.

19 Terms

1
New cards

A database object used to ask questions about data stored in database tables.

Query

2
New cards

What is produced by a query?

virtual table (result table)

3
New cards

Specifies the fields or custom expressions included in the query.

Field Row

4
New cards

Displays the name of the source table for each field.

Table Row

5
New cards

Allows records to be sorted in ascending or descending order.

Sort Row

6
New cards

Controls whether a field is displayed in the query results or hidden while still active.

Show Checkbox

7
New cards

Contains the conditions that must be met for a record to appear in results.

Criteria Row

8
New cards

Rows below the primary criteria row used to specify alternative criteria.

Or Rows

9
New cards

How do you perform calculations in a query?

Entering a custom column title followed by a colon and an expression in the Field row

10
New cards

How do you concatenate fields (like a first name and a last name) in a query?

Using the ampersand (&) or plus sign (+) operator

11
New cards

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.

12
New cards

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.


13
New cards

Requires that both conditions are satisfied; conditions are entered side-by-side in the same Criteria row.

AND

14
New cards

Requires that one or more conditions are satisfied; conditions are entered across separate or: rows.

OR

15
New cards

A symbol (such as >, <, or =) used in criteria to compare values and filter data.

comparison (aka relational) operator

16
New cards

(such as And, Or, Xor, and Not) is used to combine, evaluate, or modify multiple conditions.

logical operator

17
New cards
  • 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

18
New cards

What is a parameter driven query?

A type of query where the user provides the criterion at run time instead of in advance.

19
New cards

specialized queries used to change data in underlying tables and modify the database.

Action queries