Question 1

Which of the following is the most common type of query?

Accepted Answer

A) select query 
B) summary query 
C) simple query 
D) parameter query 
A) select query 
B) summary query 
C) simple query 
D) parameter query

Question 2

When creating a query,you are limited to how many fields you can put into the Design grid.

Accepted Answer

A) True 
 B)False

Question 3

A table finds data in your database by allowing you to ask a question.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following functions finds a specific number of characters from the left of the field?

Accepted Answer

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

Question 5

Which of the following functions finds the total value of a field?

Accepted Answer

A) Avg 
B) Sum 
C) Count 
D) Max 
A) Avg 
B) Sum 
C) Count 
D) Max

Question 6

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Accepted Answer

A) Contains "love" 
B) Like *"love"* 
C) Like "* love" 
D) Like "* love *" 
A) Contains "love" 
B) Like *"love"* 
C) Like "* love" 
D) Like "* love *"

Question 7

Use the ? wildcard character to match any number of characters.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Accepted Answer

A) function 
B) aggregate function 
C) formula expression 
D) calculated field 
A) function 
B) aggregate function 
C) formula expression 
D) calculated field

Question 9

Which of the following functions converts a value to uppercase?

Accepted Answer

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

Question 10

To test a query,run it and then compare the results to your expected results.

Accepted Answer

A) True 
 B)False

Question 11

Functions are pre-built procedures that perform a specific task.

Accepted Answer

A) True 
 B)False

Question 12

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Accepted Answer

A) True 
 B)False

Question 13

Queries you create using the Query Design button automatically open in Design view.

Accepted Answer

A) True 
 B)False

Question 14

The word "Between" is a comparison operator that you can use in your criterion expressions.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Accepted Answer

A) In(10,20) B) >10< 20 C) Between #10 and 20# D) Between 10 and 20 A) In(10,20) B) >10< 20 C) Between #10 and 20# D) Between 10 and 20

Question 17

Which of the following requires you to enter the specific criteria value when you run the query?

Accepted Answer

A) simple query 
B) summary query 
C) parameter query 
D) Expression Builder 
A) simple query 
B) summary query 
C) parameter query 
D) Expression Builder

Question 18

Which of the following is used to locate data in a database?

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 19

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

Accepted Answer

A) True 
 B)False

Which of the following is the most common type of query?

When creating a query,you are limited to how many fields you can put into the Design grid.

A table finds data in your database by allowing you to ask a question.

Which of the following functions finds a specific number of characters from the left of the field?

Which of the following functions finds the total value of a field?

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Use the ? wildcard character to match any number of characters.

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Which of the following functions converts a value to uppercase?

To test a query,run it and then compare the results to your expected results.

Functions are pre-built procedures that perform a specific task.

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Queries you create using the Query Design button automatically open in Design view.

The word "Between" is a comparison operator that you can use in your criterion expressions.

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

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Which of the following requires you to enter the specific criteria value when you run the query?

Which of the following is used to locate data in a database?

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

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 is the most common type of query?

When creating a query,you are limited to how many fields you can put into the Design grid.

A table finds data in your database by allowing you to ask a question.

Which of the following functions finds a specific number of characters from the left of the field?

Which of the following functions finds the total value of a field?

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Use the ? wildcard character to match any number of characters.

Which of the following gets its value from a calculation instead of a value that is entered into a field?

Which of the following functions converts a value to uppercase?

To test a query,run it and then compare the results to your expected results.

Functions are pre-built procedures that perform a specific task.

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Queries you create using the Query Design button automatically open in Design view.

The word "Between" is a comparison operator that you can use in your criterion expressions.

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

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Which of the following requires you to enter the specific criteria value when you run the query?

Which of the following is used to locate data in a database?

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

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