Deck 2: Create Select Queries

Question 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

Answer 1

B

Question 2

The Access comparison operator for less than or equal to is ________.

A) >=
B) <>
C) <=
D) <

Answer 2

C

Question 3

The results of a query are displayed in ________ view.

A) Table
B) Datasheet
C) Layout
D) Design

Answer 3

B

Question 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

Question 5

Use the ________ to build expressions in a query.

A) Expression Builder
B) Formula Creator
C) Arithmetic Wizard
D) Builder Tool

Question 6

Criteria that contain text must be surrounded by ________.

A) * * asterisks
B) " " quotation marks
C) # # number signs
D) [ ] brackets

Question 7

The Query Wizard button is found in the Queries group under the ________ tab.

A) Create
B) Home
C) External Data
D) Database Tools

Question 8

The Access comparison operator for not equal to is ________.

A) <=
B) =!
C) <>
D) " "

Question 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.

Question 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

Question 11

________ to add fields to the design grid.

A) Double-click
B) Copy
C) Click
D) Paste

Question 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

Question 13

In expressions, field names are enclosed between ________.

A) ( ) parentheses
B) { } braces
C) " " quotation marks
D) [ ] brackets

Question 14

The multiplication operator is ________.

A) *
B) ×
C) @
D) ^

Question 15

A(n) ________ is a descriptive label given to a calculated field.

A) expression
B) alias
C) wildcard
D) property

Question 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

Question 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

Question 18

Quick Info, ToolTips, and AutoComplete are displayed by the ________ feature.

A) IntelliSense
B) Print Preview
C) Live Preview
D) Advanced

Question 19

The ________ operator finds all numbers or dates between and including two values.

A) Middle
B) Summary
C) Between...And
D) Comes Between

Question 20

The ________ Wizard quickly adds fields to a new query.

A) Normal Query
B) Search Query
C) Filter Query
D) Simple Query

Question 21

Using the Don* criteria, which of the following would NOT be matched?

A) Adonna
B) Donna
C) Donald
D) Don

Question 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

Question 23

All of the following are Date/Time formats EXCEPT ________.

A) Long Date
B) General Number
C) Medium Time
D) Short Date

Question 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

Question 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

Question 26

You need to manually insert the Like operator when including wildcards in query criteria.

Question 27

The second step in creating a query in Design view is to add the fields.

Question 28

The ________ operator calculates the total of the values in each group.

A) Count
B) Sum
C) Avg
D) Add

Question 29

Criteria are case sensitive.

Question 30

The placement of criteria in the design grid rows does not determine whether records display.

Question 31

Between…And finds all numbers or dates between and including two values.

Question 32

A query can get its data from one or more tables, from existing queries, or from a combination of the two.

Question 33

________ display in the query datasheet header row.

A) Captions
B) Aliases
C) Titles
D) Legends

Question 34

When entering criteria that include wildcards, the ________ operator will automatically be entered.

A) Or
B) Like
C) And
D) =

Question 35

Using the D?n criteria, which of the following would NOT be matched?

A) Don
B) Dan
C) Din
D) Dean

Question 36

The × symbol indicates multiplication in an expression.

Question 37

Count is an example of a quantity statistic.

Question 38

Once a select query is created, it can be used only one time.

Question 39

The ________ logical operator tests whether a field is empty.

A) Is Null
B) Like
C) Is Not Null
D) True

Question 40

When an alias is used in an expression, it is enclosed in square brackets.

Question 41

If you do not type quotations marks around criteria, they will be automatically inserted.

Question 42

In query criteria, numbers are typically combined with comparison operators.

Question 43

When a value must not match, type <> and then type the value.

Question 44

When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.

Question 45

If you widen a query column in the design grid, the column will return to its original width when the query is closed.

Question 46

It is best practice to exclude spaces from field names.

Question 47

A calculated field can be assigned any of the data types other fields are assigned.

Question 48

The last step in creating a query in Design view is to add the tables.

Question 49

The Quick Info message explains the purpose of the selected AutoComplete command.

Question 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.

Question 51

Select queries do not change the data in the underlying table(s).

Question 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.

Question 53

In expressions, field names are always enclosed by parentheses.

Question 54

If you do not enclose date criterion in number signs (#), they will be inserted automatically.

Question 55

Tables can be added to the query design workspace using the Show Table dialog box.

Question 56

When a query is run, the results display in Datasheet view.

Question 57

It is okay to include spaces in labels.

Question 58

By default, queries follow the relationship rules defined in the Relationships window.

Question 59

When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.

Question 60

It is NOT best practice to run a query to test it before adding criteria.

Question 61

The ________ logical operator creates a comparison of two criteria that is true only when both criteria outcomes are true.

Question 62

Average is an example of a summary statistic.

Question 63

The wildcard character, ________, matches any single numeric character.

Question 64

When two criteria are placed in the same row in the design grid, the And logical operator applies.

Question 65

The wildcard character, # (number sign), matches any single character.

Question 66

If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.

Question 67

When creating a query, the criteria are the ________ used to select the desired records.

Question 68

When a date is used as query criteria, the ________ symbol is placed before and after it.

Question 69

The value that displays in place of actual field names in datasheets, forms, and reports is called a caption.

Question 70

After you create a select query, you ________ it to see the results.

Question 71

Query ________ operators such as > and < are used to compare two values.

Question 72

The Simple Query Wizard can be used to quickly ________ fields to a new query.

Question 73

In a query, calculated fields begin with a descriptive label that ends with an asterisk.

Question 74

The Sum operator calculates the total of the values in each group.

Question 75

Pound signs in a numeric field indicate that the value is the right width for the column.

Question 76

Captions display in ________ headings in the query datasheet.

Question 77

In queries, calculated fields need a descriptive label used to identify a field in expressions, datasheets, or forms and reports.

Question 78

A(n) ________ displays a subset of the data in response to a specific question.

Question 79

Use the Property Sheet to adjust the number of decimal places a calculation displays in the query datasheet.

Question 80

Left and right square brackets are used to surround ________ names in expressions.