Question 1

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

Accepted Answer

A)  Query Design Wizard
B)  parameter query
C)  aggregate function
D)  IntelliSenseE) B) and C)
F) A) and D)

Question 2

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

Accepted Answer

A)  table size
B)  data type of the field
C)  parameter text
D)  calculated fieldE) A) and B)
F) A) and D)

Question 3

What is a summary query? What functions are commonly used in summary queries?

Accepted Answer

Sometimes the question that you want ans...

Question 4

Which of the following parameters is the most user-friendly?

Accepted Answer

A)  [Enter the Music Genre]
B)  [ ]
C)  [Genre?]
D)  {Genre?}E) A) and B)
F) A) and C)

Question 5

Which of the following comparison operators means "Similar to this value"?

Accepted Answer

A)  
B)  Between
C)  In
D)  LikeE) C) and D)
F) B) and C)

Question 6

Which of the following keys opens or closes the Property Sheet?

Accepted Answer

A)  F2
B)  F4
C)  F5
D)  F12E) B) and C)
F) All of the above

Question 7

What is true of values entered on the same Criteria row of the Design grid?

Accepted Answer

A)  create an AND condition
B)  create an OR condition
C)  create a NULL condition
D)  create a NOT NULL conditionE) All of the above
F) C) and D)

Question 8

Which of the following indicates which fields have been included in the query?

Accepted Answer

A)  select query
B)  summary query
C)  Expression Builder
D)  Design gridE) B) and D)
F) B) and C)

Question 9

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

Accepted Answer

A)  In(love) 
B)  Like "love"
C)  "Like Love"
D)  ="love"E) A) and C)
F) A) and D)

Question 10

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

Accepted Answer

A) True 
 B)False

Question 11

The Count function finds the total value of a field.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following will you likely use when entering a parameter query that contains wildcards?

Accepted Answer

A)  Zoom box
B)  Expression Builder
C)  Zoom box or Expression Builder
D)  compound criteriaE) C) and D)
F) A) and C)

Question 13

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Accepted Answer

A)  Like "9?????????"
B)  Like "9*"
C)  Contains "9?????????"
D)  Contains #9*#E) C) and D)
F) A) and C)

Question 14

What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?

Accepted Answer

Many times the questions that you want t...

Question 15

After you create a query,what must you do in order to see the results?

Accepted Answer

A)  select the table to include in the query
B)  select the fields to include in the query
C)  enter criterion into the query
D)  run the queryE) C) and D)
F) A) and B)

Question 16

Which of the following comparison operators means "Contained in this list of values"?

Accepted Answer

A)  
B)  Between
C)  In
D)  LikeE) All of the above
F) None of the above

Question 17

Which of the following is a valid criterion for the AutoNumber data type?

Accepted Answer

A)  5
B)  $5
C)  5t
D)  5nE) All of the above
F) C) and D)

Question 18

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

Accepted Answer

A) True 
 B)False

Question 19

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

Accepted Answer

A) True 
 B)False

Question 20

A parameter query asks you to enter the specific criteria value when you run the query.

Accepted Answer

A) True 
 B)False

Exam 8: Integrating Applications

A parameter query asks you to enter the specific criteria value when you run the query.

Correct AnswerverifiedShow Answer

The Count function finds the total value of a field.

Correct AnswerverifiedShow Answer

Which of the following comparison operators means "Similar to this value"?

Correct AnswerverifiedShow Answer

What is a summary query? What functions are commonly used in summary queries?

Correct AnswerverifiedSometimes the question that you want ans...View AnswerShow Answer

Which of the following indicates which fields have been included in the query?

Correct AnswerverifiedShow Answer

Which of the following is a valid criterion for the AutoNumber data type?

Correct AnswerverifiedShow Answer

What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?

Correct AnswerverifiedMany times the questions that you want t...View AnswerShow Answer

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

Correct AnswerverifiedShow Answer

After you create a query,what must you do in order to see the results?

Correct AnswerverifiedShow Answer

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

Correct AnswerverifiedShow Answer

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

Correct AnswerverifiedShow Answer

Which of the following will you likely use when entering a parameter query that contains wildcards?

Correct AnswerverifiedShow Answer

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

Correct AnswerverifiedShow Answer

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

Correct AnswerverifiedShow Answer

Which of the following keys opens or closes the Property Sheet?

Correct AnswerverifiedShow Answer

Which of the following comparison operators means "Contained in this list of values"?

Correct AnswerverifiedShow Answer

Which of the following parameters is the most user-friendly?

Correct AnswerverifiedShow Answer

What is true of values entered on the same Criteria row of the Design grid?

Correct AnswerverifiedShow Answer

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

Correct AnswerverifiedShow Answer

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Sometimes the question that you want ans...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Many times the questions that you want t...
View 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