Deck 2: Create Select Queries

Full screen (f)
exit full mode
Question
A(n) ________ is a combination of fields, mathematical operators, and pre-built functions that calculates values in tables, forms, queries, and reports.

A) operator
B) expression
C) wildcard
D) comparison
Use Space or
up arrow
down arrow
to flip the card.
Question
The Access comparison operator for less than or equal to is ________.

A) >=
B) <>
C) <=
D) <
Question
The results of a query are displayed in ________ view.

A) Table
B) Datasheet
C) Layout
D) Design
Question
The Run button for executing a query is found in the ________ group under the Design tab.

A) Query Type
B) Query Setup
C) Results
D) Show/Hide
Question
Use the ________ to build expressions in a query.

A) Expression Builder
B) Formula Creator
C) Arithmetic Wizard
D) Builder Tool
Question
Criteria that contain text must be surrounded by ________.

A) * * asterisks
B) " " quotation marks
C) # # number signs
D) [ ] brackets
Question
The Query Wizard button is found in the Queries group under the ________ tab.

A) Create
B) Home
C) External Data
D) Database Tools
Question
The Access comparison operator for not equal to is ________.

A) <=
B) =!
C) <>
D) " "
Question
Which of the following is the correct order of the steps for creating a query in Design view?

A) Add the tables, add the fields, add the criteria, and run the query.
B) Add the tables, add the criteria, add the fields, and run the query.
C) Add the criteria, add the fields, add the tables, and run the query.
D) Add the fields, add the tables, add the criteria, and run the query.
Question
When two criteria are placed in different rows in the design grid, the ________ logical operator applies.

A) And
B) Null
C) Or
D) Not Null
Question
________ to add fields to the design grid.

A) Double-click
B) Copy
C) Click
D) Paste
Question
An alternative to add fields to the design grid is to ________ the field to the column.

A) double-click
B) drag
C) click
D) double-tap
Question
In expressions, field names are enclosed between ________.

A) ( ) parentheses
B) { } braces
C) " " quotation marks
D) [ ] brackets
Question
The multiplication operator is ________.

A) *
B) ×
C) @
D) ^
Question
A(n) ________ is a descriptive label given to a calculated field.

A) expression
B) alias
C) wildcard
D) property
Question
A query's ________ is used to determine how the query should be grouped and summarized.

A) Total row
B) Show Table dialog box
C) Design view
D) Criteria row
Question
When creating a query, the ________ displays the tables that the query will search.

A) query design grid
B) Print Preview
C) query design workspace
D) Quick Info
Question
Quick Info, ToolTips, and AutoComplete are displayed by the ________ feature.

A) IntelliSense
B) Print Preview
C) Live Preview
D) Advanced
Question
The ________ operator finds all numbers or dates between and including two values.

A) Middle
B) Summary
C) Between...And
D) Comes Between
Question
The ________ Wizard quickly adds fields to a new query.

A) Normal Query
B) Search Query
C) Filter Query
D) Simple Query
Question
Using the Don* criteria, which of the following would NOT be matched?

A) Adonna
B) Donna
C) Donald
D) Don
Question
When creating a query, placing two criteria in the same row indicates that the ________ logical operator applies.

A) Or
B) Null
C) And
D) Not Null
Question
All of the following are Date/Time formats EXCEPT ________.

A) Long Date
B) General Number
C) Medium Time
D) Short Date
Question
A special character used in query criteria, which allows matches for any combination of letters or characters, is called a ________.

A) floater
B) variable
C) deuce
D) wildcard
Question
The ________ operator designates which query column contains the group of values to summarize as a single record.

A) Group By
B) Greater than
C) And
D) Null
Question
You need to manually insert the Like operator when including wildcards in query criteria.
Question
The second step in creating a query in Design view is to add the fields.
Question
The ________ operator calculates the total of the values in each group.

A) Count
B) Sum
C) Avg
D) Add
Question
Criteria are case sensitive.
Question
The placement of criteria in the design grid rows does not determine whether records display.
Question
Between…And finds all numbers or dates between and including two values.
Question
A query can get its data from one or more tables, from existing queries, or from a combination of the two.
Question
________ display in the query datasheet header row.

A) Captions
B) Aliases
C) Titles
D) Legends
Question
When entering criteria that include wildcards, the ________ operator will automatically be entered.

A) Or
B) Like
C) And
D) =
Question
Using the D?n criteria, which of the following would NOT be matched?

A) Don
B) Dan
C) Din
D) Dean
Question
The × symbol indicates multiplication in an expression.
Question
Count is an example of a quantity statistic.
Question
Once a select query is created, it can be used only one time.
Question
The ________ logical operator tests whether a field is empty.

A) Is Null
B) Like
C) Is Not Null
D) True
Question
When an alias is used in an expression, it is enclosed in square brackets.
Question
If you do not type quotations marks around criteria, they will be automatically inserted.
Question
In query criteria, numbers are typically combined with comparison operators.
Question
When a value must not match, type <> and then type the value.
Question
When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.
Question
If you widen a query column in the design grid, the column will return to its original width when the query is closed.
Question
It is best practice to exclude spaces from field names.
Question
A calculated field can be assigned any of the data types other fields are assigned.
Question
The last step in creating a query in Design view is to add the tables.
Question
The Quick Info message explains the purpose of the selected AutoComplete command.
Question
When selecting the fields you want to display in the query result, choosing fields from unrelated tables will result in too many records displaying.
Question
Select queries do not change the data in the underlying table(s).
Question
If you add criteria to more than one query column, either one or the other criteria must be true for the record to be included in the query results.
Question
In expressions, field names are always enclosed by parentheses.
Question
If you do not enclose date criterion in number signs (#), they will be inserted automatically.
Question
Tables can be added to the query design workspace using the Show Table dialog box.
Question
When a query is run, the results display in Datasheet view.
Question
It is okay to include spaces in labels.
Question
By default, queries follow the relationship rules defined in the Relationships window.
Question
When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.
Question
It is NOT best practice to run a query to test it before adding criteria.
Question
The ________ logical operator creates a comparison of two criteria that is true only when both criteria outcomes are true.
Question
Average is an example of a summary statistic.
Question
The wildcard character, ________, matches any single numeric character.
Question
When two criteria are placed in the same row in the design grid, the And logical operator applies.
Question
The wildcard character, # (number sign), matches any single character.
Question
If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.
Question
When creating a query, the criteria are the ________ used to select the desired records.
Question
When a date is used as query criteria, the ________ symbol is placed before and after it.
Question
The value that displays in place of actual field names in datasheets, forms, and reports is called a caption.
Question
After you create a select query, you ________ it to see the results.
Question
Query ________ operators such as > and < are used to compare two values.
Question
The Simple Query Wizard can be used to quickly ________ fields to a new query.
Question
In a query, calculated fields begin with a descriptive label that ends with an asterisk.
Question
The Sum operator calculates the total of the values in each group.
Question
Pound signs in a numeric field indicate that the value is the right width for the column.
Question
Captions display in ________ headings in the query datasheet.
Question
In queries, calculated fields need a descriptive label used to identify a field in expressions, datasheets, or forms and reports.
Question
A(n) ________ displays a subset of the data in response to a specific question.
Question
Use the Property Sheet to adjust the number of decimal places a calculation displays in the query datasheet.
Question
Left and right square brackets are used to surround ________ names in expressions.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/96
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 2: Create Select Queries
1
A(n) ________ is a combination of fields, mathematical operators, and pre-built functions that calculates values in tables, forms, queries, and reports.

A) operator
B) expression
C) wildcard
D) comparison
B
2
The Access comparison operator for less than or equal to is ________.

A) >=
B) <>
C) <=
D) <
C
3
The results of a query are displayed in ________ view.

A) Table
B) Datasheet
C) Layout
D) Design
B
4
The Run button for executing a query is found in the ________ group under the Design tab.

A) Query Type
B) Query Setup
C) Results
D) Show/Hide
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
5
Use the ________ to build expressions in a query.

A) Expression Builder
B) Formula Creator
C) Arithmetic Wizard
D) Builder Tool
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
6
Criteria that contain text must be surrounded by ________.

A) * * asterisks
B) " " quotation marks
C) # # number signs
D) [ ] brackets
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
7
The Query Wizard button is found in the Queries group under the ________ tab.

A) Create
B) Home
C) External Data
D) Database Tools
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
8
The Access comparison operator for not equal to is ________.

A) <=
B) =!
C) <>
D) " "
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
9
Which of the following is the correct order of the steps for creating a query in Design view?

A) Add the tables, add the fields, add the criteria, and run the query.
B) Add the tables, add the criteria, add the fields, and run the query.
C) Add the criteria, add the fields, add the tables, and run the query.
D) Add the fields, add the tables, add the criteria, and run the query.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
10
When two criteria are placed in different rows in the design grid, the ________ logical operator applies.

A) And
B) Null
C) Or
D) Not Null
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
11
________ to add fields to the design grid.

A) Double-click
B) Copy
C) Click
D) Paste
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
12
An alternative to add fields to the design grid is to ________ the field to the column.

A) double-click
B) drag
C) click
D) double-tap
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
13
In expressions, field names are enclosed between ________.

A) ( ) parentheses
B) { } braces
C) " " quotation marks
D) [ ] brackets
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
14
The multiplication operator is ________.

A) *
B) ×
C) @
D) ^
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
15
A(n) ________ is a descriptive label given to a calculated field.

A) expression
B) alias
C) wildcard
D) property
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
16
A query's ________ is used to determine how the query should be grouped and summarized.

A) Total row
B) Show Table dialog box
C) Design view
D) Criteria row
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
17
When creating a query, the ________ displays the tables that the query will search.

A) query design grid
B) Print Preview
C) query design workspace
D) Quick Info
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
18
Quick Info, ToolTips, and AutoComplete are displayed by the ________ feature.

A) IntelliSense
B) Print Preview
C) Live Preview
D) Advanced
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
19
The ________ operator finds all numbers or dates between and including two values.

A) Middle
B) Summary
C) Between...And
D) Comes Between
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
20
The ________ Wizard quickly adds fields to a new query.

A) Normal Query
B) Search Query
C) Filter Query
D) Simple Query
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
21
Using the Don* criteria, which of the following would NOT be matched?

A) Adonna
B) Donna
C) Donald
D) Don
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
22
When creating a query, placing two criteria in the same row indicates that the ________ logical operator applies.

A) Or
B) Null
C) And
D) Not Null
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
23
All of the following are Date/Time formats EXCEPT ________.

A) Long Date
B) General Number
C) Medium Time
D) Short Date
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
24
A special character used in query criteria, which allows matches for any combination of letters or characters, is called a ________.

A) floater
B) variable
C) deuce
D) wildcard
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
25
The ________ operator designates which query column contains the group of values to summarize as a single record.

A) Group By
B) Greater than
C) And
D) Null
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
26
You need to manually insert the Like operator when including wildcards in query criteria.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
27
The second step in creating a query in Design view is to add the fields.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
28
The ________ operator calculates the total of the values in each group.

A) Count
B) Sum
C) Avg
D) Add
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
29
Criteria are case sensitive.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
30
The placement of criteria in the design grid rows does not determine whether records display.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
31
Between…And finds all numbers or dates between and including two values.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
32
A query can get its data from one or more tables, from existing queries, or from a combination of the two.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
33
________ display in the query datasheet header row.

A) Captions
B) Aliases
C) Titles
D) Legends
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
34
When entering criteria that include wildcards, the ________ operator will automatically be entered.

A) Or
B) Like
C) And
D) =
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
35
Using the D?n criteria, which of the following would NOT be matched?

A) Don
B) Dan
C) Din
D) Dean
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
36
The × symbol indicates multiplication in an expression.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
37
Count is an example of a quantity statistic.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
38
Once a select query is created, it can be used only one time.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
39
The ________ logical operator tests whether a field is empty.

A) Is Null
B) Like
C) Is Not Null
D) True
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
40
When an alias is used in an expression, it is enclosed in square brackets.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
41
If you do not type quotations marks around criteria, they will be automatically inserted.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
42
In query criteria, numbers are typically combined with comparison operators.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
43
When a value must not match, type <> and then type the value.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
44
When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
45
If you widen a query column in the design grid, the column will return to its original width when the query is closed.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
46
It is best practice to exclude spaces from field names.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
47
A calculated field can be assigned any of the data types other fields are assigned.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
48
The last step in creating a query in Design view is to add the tables.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
49
The Quick Info message explains the purpose of the selected AutoComplete command.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
50
When selecting the fields you want to display in the query result, choosing fields from unrelated tables will result in too many records displaying.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
51
Select queries do not change the data in the underlying table(s).
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
52
If you add criteria to more than one query column, either one or the other criteria must be true for the record to be included in the query results.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
53
In expressions, field names are always enclosed by parentheses.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
54
If you do not enclose date criterion in number signs (#), they will be inserted automatically.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
55
Tables can be added to the query design workspace using the Show Table dialog box.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
56
When a query is run, the results display in Datasheet view.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
57
It is okay to include spaces in labels.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
58
By default, queries follow the relationship rules defined in the Relationships window.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
59
When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
60
It is NOT best practice to run a query to test it before adding criteria.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
61
The ________ logical operator creates a comparison of two criteria that is true only when both criteria outcomes are true.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
62
Average is an example of a summary statistic.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
63
The wildcard character, ________, matches any single numeric character.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
64
When two criteria are placed in the same row in the design grid, the And logical operator applies.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
65
The wildcard character, # (number sign), matches any single character.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
66
If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
67
When creating a query, the criteria are the ________ used to select the desired records.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
68
When a date is used as query criteria, the ________ symbol is placed before and after it.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
69
The value that displays in place of actual field names in datasheets, forms, and reports is called a caption.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
70
After you create a select query, you ________ it to see the results.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
71
Query ________ operators such as > and < are used to compare two values.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
72
The Simple Query Wizard can be used to quickly ________ fields to a new query.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
73
In a query, calculated fields begin with a descriptive label that ends with an asterisk.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
74
The Sum operator calculates the total of the values in each group.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
75
Pound signs in a numeric field indicate that the value is the right width for the column.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
76
Captions display in ________ headings in the query datasheet.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
77
In queries, calculated fields need a descriptive label used to identify a field in expressions, datasheets, or forms and reports.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
78
A(n) ________ displays a subset of the data in response to a specific question.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
79
Use the Property Sheet to adjust the number of decimal places a calculation displays in the query datasheet.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
80
Left and right square brackets are used to surround ________ names in expressions.
Unlock Deck
Unlock for access to all 96 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 96 flashcards in this deck.