Question 1

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

Accepted Answer

You can use the Like comparison operator...

Question 2

To create a new query,use the Create tab.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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) None of the above
F) A) and D)

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

Question 6

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

Accepted Answer

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

Question 7

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 8

Which of the following represents the correct order of operations?

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False  True

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 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) C) and D)
F) All of the above

Question 12

In what view do query results display?

Accepted Answer

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

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

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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A calculated field is a field that gets ...

Question 17

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

Question 18

Access refers to formulas as criterion.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

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

Exam 8: Integrating Applications

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

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

To create a new query,use the Create tab.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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 logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

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

Which of the following represents the correct order of operations?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

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

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

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

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

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

Correct AnswerverifiedShow Answer

Access refers to formulas as criterion.

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

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

Correct AnswerverifiedB

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
While the Simple Query Wizard is useful ...
View Answer

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

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
The vast majority of databases contain m...
View Answer

Correct Answer
verified
B