Question 1

Which of the following functions rounds a value?

Accepted Answer

A) Left 
B) UCase 
C) iif 
D) Round 
A) Left 
B) UCase 
C) iif 
D) Round

Question 2

What name does Access assign to new queries?

Accepted Answer

A) Query 
B) Query1 
C) QueryData1 
D) QueryResults1 
A) Query 
B) Query1 
C) QueryData1 
D) QueryResults1

Question 3

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

Accepted Answer

A) hello 
B) "hello" 
C) *hello* 
D) #hello# 
A) hello 
B) "hello" 
C) *hello* 
D) #hello#

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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# 
A) =Ca 
B) ="Ca" 
C) =(Ca) 
D) =#Ca#

Question 6

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

Accepted Answer

A) constant 
B) parameter 
C) criterion 
D) function 
A) constant 
B) parameter 
C) criterion 
D) function

Question 7

What should you use to write criterion?

Accepted Answer

A) criterion 
B) Like comparison 
C) wildcard symbols 
D) expression 
A) criterion 
B) Like comparison 
C) wildcard symbols 
D) expression

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) File 
B) Home 
C) Create 
D) Database Tools 
A) File 
B) Home 
C) Create 
D) Database Tools

Question 11

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

Question 12

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 above 
A) at the end 
B) at the beginning 
C) at the beginning and end 
D) any of the above

Question 13

What is a parameter query and when is it useful?

Accepted Answer

What if you wanted to locate all the alb

Question 14

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

Accepted Answer

A) (*) 
B) (#) 
C) (?) 
D) ($) 
A) (*) 
B) (#) 
C) (?) 
D) ($)

Question 15

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

Accepted Answer

A) F6 
B) F8 
C) F10 
D) F12 
A) F6 
B) F8 
C) F10 
D) F12

Question 16

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 17

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 function 
A) AND operator 
B) OR operator 
C) Total row 
D) Count function

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) NULL 
A) AND 
B) OR 
C) NOT 
D) NULL

Question 19

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

Accepted Answer

A)  
B) Between 
C) In 
D) Like 
A)  
B) Between 
C) In 
D) Like

Question 20

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) 9 
A) 1 
B) 3 
C) 6 
D) 9

Which of the following functions rounds a value?

What name does Access assign to new queries?

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

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

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

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

What should you use to write criterion?

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

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

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

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

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

What is a parameter query and when is it useful?

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

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

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

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

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?

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

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?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 8: Integrating Applications

Which of the following functions rounds a value?

What name does Access assign to new queries?

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

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

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

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

What should you use to write criterion?

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

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

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

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

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

What is a parameter query and when is it useful?

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

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

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

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

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?

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

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?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters