Question 1

What is the name for a hardcoded value entered into a formula?

Accepted Answer

A)  constant
B)  parameter
C)  criterion
D)  functionE) A) and D)
F) All of the above

Question 2

When you build a query you must tell Access where to find the data.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following keyboard shortcuts opens the Save As dialog box?

Accepted Answer

A)  F6
B)  F8
C)  F10
D)  F12E) A) and C)
F) A) and B)

Question 4

Which of the following wildcard characters matches any number of characters?

Accepted Answer

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

Question 5

Which of the following tabs do you use to create a query?

Accepted Answer

A)  File
B)  Home
C)  Create
D)  Database ToolsE) All of the above
F) C) and D)

Question 6

When structuring a criteria expression with a parameter that includes one or more wildcards,where can the wildcards be positioned?

Accepted Answer

A)  at the end
B)  at the beginning
C)  at the beginning and end
D)  any of the aboveE) C) and D)
F) A) and D)

Question 7

What name does Access assign to new queries?

Accepted Answer

A)  Query
B)  Query1
C)  QueryData1
D)  QueryResults1E) A) and B)
F) All of the above

Question 8

How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch who were hired after January 1,2014?

Accepted Answer

A)  1
B)  3
C)  6
D)  9E) A) and C)
F) A) and B)

Question 9

What is a parameter query and when is it useful?

Accepted Answer

What if you wanted to locate all the alb...

Question 10

What should you use to write criterion?

Accepted Answer

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

Question 11

Which of the following functions rounds a value?

Accepted Answer

A)  Left
B)  UCase
C)  iif
D)  RoundE) A) and D)
F) All of the above

Question 12

Which of the following is added to the Design grid of a summary query?

Accepted Answer

A)  AND operator
B)  OR operator
C)  Total row
D)  Count functionE) A) and B)
F) All of the above

Question 13

Which of the following is true about the Simple Query Wizard?

Accepted Answer

A)  It doesn't allow you to take advantage of all of the options available when creating a query.
B)  It lets you take full advantage of all the options available when creating a query.
C)  It provides great flexibility when creating queries.
D)  Most people create queries using the Simple Query Wizard.E) All of the above
F) None of the above

Question 14

You can create a query in Design view or with the Query Wizard.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following criterion expressions searches for a State field that is equal to Ca?

Accepted Answer

A)  =Ca
B)  ="Ca"
C)  =(Ca) 
D)  =#Ca#E) None of the above
F) C) and D)

Question 16

At times no records will display when you run a query.

Accepted Answer

A) True 
 B)False

Question 17

For each data type,what are the rules related to entering specific criterion values?

Accepted Answer

You can add a criterion into a query to ...

Question 18

Which of the following logical operators requires that a record meet all of the individual conditions specified in order to be included in the results?

Accepted Answer

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

Question 19

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

Accepted Answer

A)  hello
B)  "hello"
C)  *hello*
D)  #hello#E) All of the above
F) None of the above

Question 20

Which of the following comparison operators means "Between these two values"?

Accepted Answer

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

Exam 8: Integrating Applications

Which of the following comparison operators means "Between these two values"?

Correct AnswerverifiedShow Answer

For each data type,what are the rules related to entering specific criterion values?

Correct AnswerverifiedYou can add a criterion into a query to ...View AnswerShow Answer

When structuring a criteria expression with a parameter that includes one or more wildcards,where can the wildcards be positioned?

Correct AnswerverifiedShow Answer

At times no records will display when you run a query.

Correct AnswerverifiedShow Answer

When you build a query you must tell Access where to find the data.

Correct AnswerverifiedShow Answer

Which of the following is true about the Simple Query Wizard?

Correct AnswerverifiedShow Answer

Which of the following is added to the Design grid of a summary query?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following functions rounds a value?

Correct AnswerverifiedShow Answer

Which of the following criterion expressions searches for a State field that is equal to Ca?

Correct AnswerverifiedShow Answer

Which of the following keyboard shortcuts opens the Save As dialog box?

Correct AnswerverifiedShow Answer

Which of the following wildcard characters matches any number of characters?

Correct AnswerverifiedShow Answer

What name does Access assign to new queries?

Correct AnswerverifiedShow Answer

Which of the following tabs do you use to create a query?

Correct AnswerverifiedShow Answer

What is the name for a hardcoded value entered into a formula?

Correct AnswerverifiedShow Answer

You can create a query in Design view or with the Query Wizard.

Correct AnswerverifiedShow Answer

What should you use to write criterion?

Correct AnswerverifiedShow Answer

Which of the following logical operators requires that a record meet all of the individual conditions specified in order to be included in the results?

Correct AnswerverifiedShow Answer

What is a parameter query and when is it useful?

Correct AnswerverifiedWhat if you wanted to locate all the alb...View AnswerShow Answer

How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch who were hired after January 1,2014?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
You can add a criterion into a query to ...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
What if you wanted to locate all the alb...
View Answer

Correct Answer
verified