Question 1

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Accepted Answer

A) Like "9?????????" 
B) Like "9*" 
C) Contains "9?????????" 
D) Contains #9*# 
A) Like "9?????????" 
B) Like "9*" 
C) Contains "9?????????" 
D) Contains #9*#

Question 2

Which of the following keys opens or closes the Property Sheet?

Accepted Answer

A) F2 
B) F4 
C) F5 
D) F12 
A) F2 
B) F4 
C) F5 
D) F12

Question 3

Which of the following indicates which fields have been included in the query?

Accepted Answer

A) select query 
B) summary query 
C) Expression Builder 
D) Design grid 
A) select query 
B) summary query 
C) Expression Builder 
D) Design grid

Question 4

What is a summary query? What functions are commonly used in summary queries?

Accepted Answer

Sometimes the question that you want ans

Question 5

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

Accepted Answer

A) True 
 B)False

Question 6

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

Accepted Answer

A) True 
 B)False

Question 7

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

Accepted Answer

A) True 
 B)False

Question 8

The Count function finds the total value of a field.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following parameters is the most user-friendly?

Accepted Answer

A) [Enter the Music Genre] 
B) [ ] 
C) [Genre?] 
D) {Genre?} 
A) [Enter the Music Genre] 
B) [ ] 
C) [Genre?] 
D) {Genre?}

Question 10

Which of the following comparison operators means "Similar to this value"?

Accepted Answer

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

Question 11

After you create a query,what must you do in order to see the results?

Accepted Answer

A) select the table to include in the query 
B) select the fields to include in the query 
C) enter criterion into the query 
D) run the query 
A) select the table to include in the query 
B) select the fields to include in the query 
C) enter criterion into the query 
D) run the query

Question 12

Which of the following will you likely use when entering a parameter query that contains wildcards?

Accepted Answer

A) Zoom box 
B) Expression Builder 
C) Zoom box or Expression Builder 
D) compound criteria 
A) Zoom box 
B) Expression Builder 
C) Zoom box or Expression Builder 
D) compound criteria

Question 13

A parameter query asks you to enter the specific criteria value when you run the query.

Accepted Answer

A) True 
 B)False

Question 14

What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?

Accepted Answer

Many times the questions that you want t

Question 15

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

Accepted Answer

A) 5 
B) $5 
C) 5t 
D) 5n 
A) 5 
B) $5 
C) 5t 
D) 5n

Question 16

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

Accepted Answer

A) table size 
B) data type of the field 
C) parameter text 
D) calculated field 
A) table size 
B) data type of the field 
C) parameter text 
D) calculated field

Question 17

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

Accepted Answer

A) Query Design Wizard 
B) parameter query 
C) aggregate function 
D) IntelliSense 
A) Query Design Wizard 
B) parameter query 
C) aggregate function 
D) IntelliSense

Question 18

Which of the following comparison operators means "Contained in this list of values"?

Accepted Answer

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

Question 19

What is true of values entered on the same Criteria row of the Design grid?

Accepted Answer

A) create an AND condition 
B) create an OR condition 
C) create a NULL condition 
D) create a NOT NULL condition 
A) create an AND condition 
B) create an OR condition 
C) create a NULL condition 
D) create a NOT NULL condition

Question 20

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

Accepted Answer

A) In(love) 
B) Like "love" 
C) "Like Love" 
D) ="love" 
A) In(love) 
B) Like "love" 
C) "Like Love" 
D) ="love"

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Which of the following keys opens or closes the Property Sheet?

Which of the following indicates which fields have been included in the query?

What is a summary query? What functions are commonly used in summary queries?

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

The Count function finds the total value of a field.

Which of the following parameters is the most user-friendly?

Which of the following comparison operators means "Similar to this value"?

After you create a query,what must you do in order to see the results?

Which of the following will you likely use when entering a parameter query that contains wildcards?

A parameter query asks you to enter the specific criteria value when you run the query.

What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?

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

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

Which of the following comparison operators means "Contained in this list of values"?

What is true of values entered on the same Criteria row of the Design grid?

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

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 criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Which of the following keys opens or closes the Property Sheet?

Which of the following indicates which fields have been included in the query?

What is a summary query? What functions are commonly used in summary queries?

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

The Count function finds the total value of a field.

Which of the following parameters is the most user-friendly?

Which of the following comparison operators means "Similar to this value"?

After you create a query,what must you do in order to see the results?

Which of the following will you likely use when entering a parameter query that contains wildcards?

A parameter query asks you to enter the specific criteria value when you run the query.

What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?

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

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

Which of the following comparison operators means "Contained in this list of values"?

What is true of values entered on the same Criteria row of the Design grid?

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

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