Question 1

The first field you choose to sort by is called the ________ field.

Accepted Answer

The answer of The first field you choose to sort...

Question 2

________ are the lines connecting the tables that represent relationships.

Accepted Answer

The answer of ________ are the lines connecting the tables...

Question 3

To search for a three-letter word that starts with "t" and ends with "p" you would enter ________.

Accepted Answer

A)  t?p
B)  t#p
C)  t*p
D)  t!pE) A) and B)
F) A) and C)

Question 4

Which of the following is NOT true about changing field names in a query?

Accepted Answer

A)  Field names in aggregate queries are a composite of the selected aggregate function and the table field name.
B)  The field names assigned in an aggregate query can easily be changed either before or after the query is run.
C)  You must keep the original field name in the query design grid so Access knows what field to perform the calculation on.
D)  The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed.E) C) and D)
F) B) and C)

Question 5

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

Accepted Answer

A)  total row
B)  aggregate row
C)  Function pane
D)  statistics buttonE) B) and D)
F) B) and C)

Question 6

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

Accepted Answer

A)  Count
B)  Average
C)  Minimum
D)  MaximumE) B) and C)
F) C) and D)

Question 7

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

Accepted Answer

A)  Special operators
B)  Comparison operators
C)  Aggregate functions
D)  Is Null criteriaE) A) and B)
F) B) and C)

Question 8

Which of the following is NOT a method used to add fields to a query design grid?

Accepted Answer

A)  Drag
B)  Double-click the title bar
C)  Click,Shift,Click
D)  Single-click field nameE) C) and D)
F) B) and D)

Question 9

A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

A) True 
 B)False

Question 10

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is known as the multiplier effect.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT true regarding calculated fields?

Accepted Answer

A)  The result of the calculated field is displayed each time you run the query.
B)  A calculated field can be added to a query using the fields in the query or even fields in another table or query in the database.
C)  The calculation can use a combination of numbers and field values,which allows you flexibility in how you perform the calculation.
D)  A calculated field is stored in the table once the query is saved.E) All of the above
F) B) and C)

Question 12

A ________ query is used when you want to describe one field in terms of two or more fields in the table.

Accepted Answer

A)  Find Duplicates
B)  Crosstab
C)  Find Unmatched
D)  SimpleE) A) and C)
F) None of the above

Question 13

Which of the following is NOT true about using aggregate functions in a query?

Accepted Answer

A)  Aggregate functions can be used in queries to perform calculations on selected fields and records.
B)  By default,the query design grid has a place to enter aggregate functions.
C)  One advantage to using aggregate functions in queries,rather than just a total row,is that you can group criteria and then calculate the aggregate functions for a group of records.
D)  Each column or field can calculate only one aggregate function.E) B) and C)
F) A) and D)

Question 14

The second and subsequent fields you choose to sort by are called ________ fields.

Accepted Answer

The answer of The second and subsequent fields you choose...

Question 15

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is NOT true about sorting query results on multiple fields?

Accepted Answer

A)  You can have one field sorted in ascending order and another in descending order.
B)  The first field you choose to sort by is called the primary sort field.
C)  The second and subsequent fields are called secondary sort fields.
D)  In Datasheet view,you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts.E) A) and D)
F) A) and C)

Question 17

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Accepted Answer

A) True 
 B)False

Question 18

The ________ operator matches text values by using wildcards.

Accepted Answer

The answer of The ________ operator matches text values by...

Question 19

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

Accepted Answer

A)  AND
B)  OR
C)  NOT
D)  BETWEENE) None of the above
F) A) and C)

Question 20

A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.

Accepted Answer

The answer of A(n)________ query is used when you want...

Exam 3: Workshop 3: Queries and Data Access

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

Correct AnswerverifiedShow Answer

A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Correct AnswerverifiedShow Answer

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

Correct AnswerverifiedShow Answer

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Correct AnswerverifiedShow Answer

A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.

Correct AnswerverifiedShow Answer

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

Correct AnswerverifiedShow Answer

Which of the following is NOT true regarding calculated fields?

Correct AnswerverifiedShow Answer

Which of the following is NOT a method used to add fields to a query design grid?

Correct AnswerverifiedShow Answer

The ________ operator matches text values by using wildcards.

Correct AnswerverifiedShow Answer

Which of the following is NOT true about sorting query results on multiple fields?

Correct AnswerverifiedShow Answer

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Correct AnswerverifiedShow Answer

A ________ query is used when you want to describe one field in terms of two or more fields in the table.

Correct AnswerverifiedShow Answer

To search for a three-letter word that starts with "t" and ends with "p" you would enter ________.

Correct AnswerverifiedShow Answer

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

Correct AnswerverifiedShow Answer

The second and subsequent fields you choose to sort by are called ________ fields.

Correct AnswerverifiedShow Answer

Which of the following is NOT true about using aggregate functions in a query?

Correct AnswerverifiedShow Answer

Which of the following is NOT true about changing field names in a query?

Correct AnswerverifiedShow Answer

The first field you choose to sort by is called the ________ field.

Correct AnswerverifiedShow Answer

________ are the lines connecting the tables that represent relationships.

Correct AnswerverifiedShow Answer

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is known as the multiplier effect.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified