Question 1

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following symbols must you use when defining a parameter query?

Accepted Answer

A)  ( ) 
B)  [ ]
C)  { }
D)  / /E) A) and C)
F) All of the above B

Question 3

Which symbol must be used to specify criterion for the Date/ Time data type?

Accepted Answer

A)  ($) 
B)  (?) 
C)  (*) 
D)  (#) E) B) and C)
F) B) and D)

Question 4

In the Design grid,what must you delete in order to delete a field?

Accepted Answer

A)  a column
B)  a row
C)  a table
D)  none of the aboveE) A) and B)
F) All of the above

Question 5

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

Accepted Answer

A)  AND
B)  OR
C)  NOT
D)  NULLE) A) and B)
F) A) and C)

Question 6

When might you want to create a query based on multiple tables? What should you be careful of when creating a creating based on multiple tables?

Accepted Answer

The vast majority of databases contain m...

Question 7

What is a calculated field? Where are calculated fields stored?

Accepted Answer

A calculated field is a field that gets ...

Question 8

Which of the following properties directs Access to only display records that don't include duplicated values?

Accepted Answer

A)  Unique Records
B)  Unique Values
C)  Null Records
D)  Null ValuesE) A) and B)
F) A) and C)

Question 9

Which of the following finds data in your database by allowing you to ask a question?

Accepted Answer

A)  calculated field
B)  compound criteria
C)  query
D)  parameterE) B) and C)
F) A) and B)

Question 10

Which of the following wildcard characters matches any single character in a specific position?

Accepted Answer

A)  (*) 
B)  (#) 
C)  (?) 
D)  ($) E) None of the above
F) B) and C)

Question 11

What is the difference between creating a query using the Query Design Wizard or Query Design?

Accepted Answer

While the Simple Query Wizard is useful ...

Question 12

Explain what you know about using wildcards in a parameter query.

Accepted Answer

You can use the Like comparison operator...

Question 13

A summary query uses a Total row that is added into the Design grid of the query.

Accepted Answer

A) True 
 B)False

Question 14

To create a new query,use the Create tab.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following should you add to a query to search for records that meet a specific value?

Accepted Answer

A)  criterion
B)  Like comparison
C)  wildcard symbols
D)  expressionE) A) and C)
F) B) and C)

Question 16

In what view do query results display?

Accepted Answer

A)  Design view
B)  Datasheet view
C)  Form view
D)  Report viewE) C) and D)
F) B) and C)

Question 17

Access refers to formulas as criterion.

Accepted Answer

A) True 
 B)False

Question 18

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Accepted Answer

A) True 
 B)False  True

Question 19

You can create a query that combines both the AND and OR operators.

Accepted Answer

A) True 
 B)False  True

Question 20

Which of the following represents the correct order of operations?

Accepted Answer

A)  () ,^,/ ,*,-,+
B)  () ,^,*,/ ,+,-
C)  () ,^,*,/ ,-,+
D)  ^,() ,*,/ ,-,+E) B) and D)
F) None of the above

Exam 8: Integrating Applications

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Correct AnswerverifiedShow Answer

Which of the following symbols must you use when defining a parameter query?

Correct AnswerverifiedB

Which symbol must be used to specify criterion for the Date/ Time data type?

Correct AnswerverifiedShow Answer

In the Design grid,what must you delete in order to delete a field?

Correct AnswerverifiedShow Answer

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

Correct AnswerverifiedShow Answer

When might you want to create a query based on multiple tables? What should you be careful of when creating a creating based on multiple tables?

Correct AnswerverifiedThe vast majority of databases contain m...View AnswerShow Answer

What is a calculated field? Where are calculated fields stored?

Correct AnswerverifiedA calculated field is a field that gets ...View AnswerShow Answer

Which of the following properties directs Access to only display records that don't include duplicated values?

Correct AnswerverifiedShow Answer

Which of the following finds data in your database by allowing you to ask a question?

Correct AnswerverifiedShow Answer

Which of the following wildcard characters matches any single character in a specific position?

Correct AnswerverifiedShow Answer

What is the difference between creating a query using the Query Design Wizard or Query Design?

Correct AnswerverifiedWhile the Simple Query Wizard is useful ...View AnswerShow Answer

Explain what you know about using wildcards in a parameter query.

Correct AnswerverifiedYou can use the Like comparison operator...View AnswerShow Answer

A summary query uses a Total row that is added into the Design grid of the query.

Correct AnswerverifiedShow Answer

To create a new query,use the Create tab.

Correct AnswerverifiedShow Answer

Which of the following should you add to a query to search for records that meet a specific value?

Correct AnswerverifiedShow Answer

In what view do query results display?

Correct AnswerverifiedShow Answer

Access refers to formulas as criterion.

Correct AnswerverifiedShow Answer

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Correct AnswerverifiedTrue

You can create a query that combines both the AND and OR operators.

Correct AnswerverifiedTrue

Which of the following represents the correct order of operations?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The vast majority of databases contain m...
View Answer

Correct Answer
verified
A calculated field is a field that gets ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
While the Simple Query Wizard is useful ...
View Answer

Correct Answer
verified
You can use the Like comparison operator...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
True

Correct Answer
verified