Question 1

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)   Simple

Question 2

________ is a feature that can change the column width of the data to match the widest data entered in that field.

Accepted Answer

A)   AutoFit
B)   Form fit
C)   Field size
D)   Fit by selection

Question 3

A ________ query is used when you want to find records with the same specific value.

Accepted Answer

A)   Find Duplicates
B)   Crosstab
C)   Find Unmatched
D)   Simple

Question 4

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Accepted Answer

A)   Count
B)   Sum
C)   Minimum
D)   Maximum

Question 5

________ is a tool in Access that can help you format your calculated fields correctly.

Accepted Answer

A)   Navigation Pane
B)   Expression Builder
C)   Property Sheet
D)   Navigation bar

Question 6

Relationship lines are the lines connecting the tables that represent relationships.

Accepted Answer

A) True 
 B)False

Question 7

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ field is a field used to determine the order of the records.

Accepted Answer

The answer of A(n)________ field is a field used to...

Question 9

Which of the following is NOT true about the Find Unmatched query wizard?

Accepted Answer

A)   The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records.
B)   The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.
C)   The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables.
D)   If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically. B

Question 10

To search for a word that begins with "ar" you would enter ________.

Accepted Answer

A)   ar?
B)   ar#
C)   ar!
D)   ar* D

Question 11

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 12

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Accepted Answer

A)   use the Find command
B)   filter by selection
C)   use the Replace command
D)   use the Navigation bar B

Question 13

________ equate the values in a table or another query to the criteria value you set up in a query.

Accepted Answer

A)   Comparison operators
B)   Is Null criteria
C)   Search criteria
D)   Query operators

Question 14

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

Accepted Answer

A)   Count
B)   Sum
C)   Minimum
D)   Maximum

Question 15

The query window in Design view allows you to specify the data you want to see by building a query by example.

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)   In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts.
B)   The second and subsequent fields are called secondary sort fields.
C)   The first field you choose to sort by is called the primary sort field.
D)   You can have one field sorted in ascending order and another in descending order.

Question 17

Match between columns
                        Premises: Text filter
Find Duplicates query
AutoFit
Find Unmatched query
Crosstab query

Accepted Answer

The Answer of Used to describe one field in terms is...

Question 18

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 button

Question 19

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Accepted Answer

A)   composite key
B)   orphan
C)   wildcard
D)   duplicate key

Exam 13: Queries and Data Access

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

Correct Answer
verified

________ is a feature that can change the column width of the data to match the widest data entered in that field.

Correct Answer
verified

A ________ query is used when you want to find records with the same specific value.

Correct Answer
verified

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Correct Answer
verified

________ is a tool in Access that can help you format your calculated fields correctly.

Correct Answer
verified

Relationship lines are the lines connecting the tables that represent relationships.

Correct Answer
verified

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

Correct Answer
verified

A(n)________ field is a field used to determine the order of the records.

Correct Answer
verified

Which of the following is NOT true about the Find Unmatched query wizard?

Correct Answer
verified
B

To search for a word that begins with "ar" you would enter ________.

Correct Answer
verified
D

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 Answer
verified

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Correct Answer
verified
B

________ equate the values in a table or another query to the criteria value you set up in a query.

Correct Answer
verified

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

Correct Answer
verified

The query window in Design view allows you to specify the data you want to see by building a query by example.

Correct Answer
verified

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

Correct Answer
verified

Match the following terms with their definition.

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

Correct Answer
verified

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

Correct Answer
verified

A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Correct Answer
verified

Exam 13: Queries and Data Access

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

Correct AnswerverifiedShow Answer

________ is a feature that can change the column width of the data to match the widest data entered in that field.

Correct AnswerverifiedShow Answer

A ________ query is used when you want to find records with the same specific value.

Correct AnswerverifiedShow Answer

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Correct AnswerverifiedShow Answer

________ is a tool in Access that can help you format your calculated fields correctly.

Correct AnswerverifiedShow Answer

Relationship lines are the lines connecting the tables that represent relationships.

Correct AnswerverifiedShow Answer

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

Correct AnswerverifiedShow Answer

A(n)________ field is a field used to determine the order of the records.

Correct AnswerverifiedShow Answer

Which of the following is NOT true about the Find Unmatched query wizard?

Correct AnswerverifiedB

To search for a word that begins with "ar" you would enter ________.

Correct AnswerverifiedD

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

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Correct AnswerverifiedB

________ equate the values in a table or another query to the criteria value you set up in a query.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The query window in Design view allows you to specify the data you want to see by building a query by example.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Match the following terms with their definition.

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

Correct AnswerverifiedShow Answer

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

Correct AnswerverifiedShow Answer

A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

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
B

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified