Question 1

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Accepted Answer

A)  In(10,20) 
B)   >10
C)  Between #10 and 20#
D)  Between 10 and 20E) None of the above
F) A) and D)

Question 3

Which of the following requires you to enter the specific criteria value when you run the query?

Accepted Answer

A)  simple query
B)  summary query
C)  parameter query
D)  Expression BuilderE) B) and C)
F) C) and D)

Question 4

The word "Between" is a comparison operator that you can use in your criterion expressions.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following functions converts a value to uppercase?

Accepted Answer

A)  Left
B)  UCase
C)  iif
D)  RoundE) A) and D)
F) A) and C)

Question 6

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Accepted Answer

A)  Contains "love"
B)  Like *"love"*
C)  Like "* love"
D)  Like "* love *"E) A) and B)
F) A) and C)

Question 7

A table finds data in your database by allowing you to ask a question.

Accepted Answer

A) True 
 B)False

Question 8

Functions are pre-built procedures that perform a specific task.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Accepted Answer

A)  function
B)  aggregate function
C)  formula expression
D)  calculated fieldE) A) and D)
F) B) and D)

Question 10

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is used to locate data in a database?

Accepted Answer

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

Question 12

Use the ? wildcard character to match any number of characters.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is the most common type of query?

Accepted Answer

A)  select query
B)  summary query
C)  simple query
D)  parameter queryE) B) and D)
F) None of the above

Question 14

When creating a query,you are limited to how many fields you can put into the Design grid.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  5
B)  $5
C)  5t
D)  5nE) B) and C)
F) A) and D)

Question 16

Which of the following functions finds a specific number of characters from the left of the field?

Accepted Answer

A)  Left
B)  UCase
C)  iif
D)  RoundE) A) and B)
F) B) and C)

Question 17

To test a query,run it and then compare the results to your expected results.

Accepted Answer

A) True 
 B)False

Question 18

Queries you create using the Query Design button automatically open in Design view.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following functions finds the total value of a field?

Accepted Answer

A)  Avg
B)  Sum
C)  Count
D)  MaxE) A) and D)
F) All of the above

Exam 8: Integrating Applications

Which of the following functions finds a specific number of characters from the left of the field?

Correct Answer
verified

Use the ? wildcard character to match any number of characters.

Correct Answer
verified

When creating a query,you are limited to how many fields you can put into the Design grid.

Correct Answer
verified

Which of the following requires you to enter the specific criteria value when you run the query?

Correct Answer
verified

To test a query,run it and then compare the results to your expected results.

Correct Answer
verified

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Correct Answer
verified

The word "Between" is a comparison operator that you can use in your criterion expressions.

Correct Answer
verified

Which of the following functions converts a value to uppercase?

Correct Answer
verified

Which of the following functions finds the total value of a field?

Correct Answer
verified

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

Correct Answer
verified

Functions are pre-built procedures that perform a specific task.

Correct Answer
verified

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Correct Answer
verified

A table finds data in your database by allowing you to ask a question.

Correct Answer
verified

Queries you create using the Query Design button automatically open in Design view.

Correct Answer
verified

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Correct Answer
verified

Which of the following is used to locate data in a database?

Correct Answer
verified

Which of the following is the most common type of query?

Correct Answer
verified

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Correct Answer
verified

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

Correct Answer
verified

Exam 8: Integrating Applications

Which of the following functions finds a specific number of characters from the left of the field?

Correct AnswerverifiedShow Answer

Use the ? wildcard character to match any number of characters.

Correct AnswerverifiedShow Answer

When creating a query,you are limited to how many fields you can put into the Design grid.

Correct AnswerverifiedShow Answer

Which of the following requires you to enter the specific criteria value when you run the query?

Correct AnswerverifiedShow Answer

To test a query,run it and then compare the results to your expected results.

Correct AnswerverifiedShow Answer

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Correct AnswerverifiedShow Answer

The word "Between" is a comparison operator that you can use in your criterion expressions.

Correct AnswerverifiedShow Answer

Which of the following functions converts a value to uppercase?

Correct AnswerverifiedShow Answer

Which of the following functions finds the total value of a field?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Functions are pre-built procedures that perform a specific task.

Correct AnswerverifiedShow Answer

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Correct AnswerverifiedShow Answer

A table finds data in your database by allowing you to ask a question.

Correct AnswerverifiedShow Answer

Queries you create using the Query Design button automatically open in Design view.

Correct AnswerverifiedShow Answer

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Correct AnswerverifiedShow Answer

Which of the following is used to locate data in a database?

Correct AnswerverifiedShow Answer

Which of the following is the most common type of query?

Correct AnswerverifiedShow Answer

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Correct AnswerverifiedShow Answer

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

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