Question 1

In what view do query results display?

Accepted Answer

A)  Design view
B)  Datasheet view
C)  Form view
D)  Report viewE) None of the above
F) C) and D)

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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 B)
F) None of the above

Question 4

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 5

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 6

Access refers to formulas as criterion.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

You can use the Like comparison operator...

Question 8

Which of the following represents the correct order of operations?

Accepted Answer

A)  () ,^,/ ,*,-,+
B)  () ,^,*,/ ,+,-
C)  () ,^,*,/ ,-,+
D)  ^,() ,*,/ ,-,+E) B) and D)
F) A) and C)

Question 9

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

Accepted Answer

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

Question 10

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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A)  ( ) 
B)  [ ]
C)  { }
D)  / /E) A) and D)
F) B) and C) B

Question 13

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 14

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

Accepted Answer

A calculated field is a field that gets ...

Question 15

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) B) and C)
F) A) and B)

Question 16

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) A) and D)
F) C) and D)

Question 17

To create a new query,use the Create tab.

Accepted Answer

A) True 
 B)False

Question 18

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) B) and D)
F) A) and D)

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 8: Integrating Applications

In what view do query results display?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

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

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

Access refers to formulas as criterion.

Correct AnswerverifiedShow Answer

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

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

Which of the following represents the correct order of operations?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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 wildcard characters matches any single character in a specific position?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To create a new query,use the Create tab.

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

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

Correct Answer
verified
True

Correct Answer
verified

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
B

Correct Answer
verified

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

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

Correct Answer
verified