Question 1

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

Accepted Answer

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

Question 2

In the simplest criterion expression,when you only enter the criteria value,Access evaluates this criterion as an "equal to" comparison.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following groups of commands lets you insert and delete fields in the Design grid?

Accepted Answer

A) Query Wizard 
B) Query Design 
C) Query Setup 
D) Expression Builder 
A) Query Wizard 
B) Query Design 
C) Query Setup 
D) Expression Builder

Question 4

Which of the following functions counts the number of records that have a value in the field?

Accepted Answer

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

Question 5

Describe the usefulness of the Unique Values property.

Accepted Answer

A well-designed database is structured t

Question 6

How does Access evaluate a criterion expression that just includes a criteria value?

Accepted Answer

A) equal to 
B) not equal to 
C) equal to or greater than 
D) equal to or less than 
A) equal to 
B) not equal to 
C) equal to or greater than 
D) equal to or less than

Question 7

Which of the following criterion expressions searches for a ShippingDate field that greater than January 1,2014?

Accepted Answer

A)  >1/ 1/ 2014 
B)  >"1/ 1/ 2014" 
C)  >#1/ 1/ 2014# 
D)  >=#1/ 1/ 2014# 
A)  >1/ 1/ 2014 
B)  >"1/ 1/ 2014" 
C)  >#1/ 1/ 2014# 
D)  >=#1/ 1/ 2014#

Question 8

How many fields does Access allow you to add to the Design grid?

Accepted Answer

A) 5 or fewer 
B) 10 or fewer 
C) 15 or fewer 
D) as many as you like 
A) 5 or fewer 
B) 10 or fewer 
C) 15 or fewer 
D) as many as you like

Question 9

Making changes to the data shown in Datasheet view of a query changes the actual table data.

Accepted Answer

A) True 
 B)False

Question 10

When you use a wildcard,the criterion of your expression must be enclosed in parentheses.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following keyboard shortcuts opens the Expression Builder dialog box?

Accepted Answer

A) F2 
B) Ctrl+F2 
C) Alt+F2 
D) Shift+F2 
A) F2 
B) Ctrl+F2 
C) Alt+F2 
D) Shift+F2

Question 12

What are the general steps involved with creating,running,and editing a query in Query Design?

Accepted Answer

You can create a new query from the Crea

Question 13

To see the results of a query,you must run it.

Accepted Answer

A) True 
 B)False

Question 14

When building a query,you are limited to adding one table to the Query Design window.

Accepted Answer

A) True 
 B)False

Question 15

It is possible to display the results of a query in sorted order.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following can you change in Datasheet view of a query?

Accepted Answer

A) font type 
B) font size 
C) column width 
D) all of the above 
A) font type 
B) font size 
C) column width 
D) all of the above

Question 17

The Like comparison operator can help you find records containing data that is similar to,or like,the criterion value.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

Which of the following functions performs a comparison and does one of two alternatives?

Accepted Answer

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

Question 20

Which of the following wildcard characters matches any single character numeric digit?

Accepted Answer

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

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

In the simplest criterion expression,when you only enter the criteria value,Access evaluates this criterion as an "equal to" comparison.

Which of the following groups of commands lets you insert and delete fields in the Design grid?

Which of the following functions counts the number of records that have a value in the field?

Describe the usefulness of the Unique Values property.

How does Access evaluate a criterion expression that just includes a criteria value?

Which of the following criterion expressions searches for a ShippingDate field that greater than January 1,2014?

How many fields does Access allow you to add to the Design grid?

Making changes to the data shown in Datasheet view of a query changes the actual table data.

When you use a wildcard,the criterion of your expression must be enclosed in parentheses.

Which of the following keyboard shortcuts opens the Expression Builder dialog box?

What are the general steps involved with creating,running,and editing a query in Query Design?

To see the results of a query,you must run it.

When building a query,you are limited to adding one table to the Query Design window.

It is possible to display the results of a query in sorted order.

Which of the following can you change in Datasheet view of a query?

The Like comparison operator can help you find records containing data that is similar to,or like,the criterion value.

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

Which of the following functions performs a comparison and does one of two alternatives?

Which of the following wildcard characters matches any single character numeric digit?

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 a valid criterion for the Long Text data type?

In the simplest criterion expression,when you only enter the criteria value,Access evaluates this criterion as an "equal to" comparison.

Which of the following groups of commands lets you insert and delete fields in the Design grid?

Which of the following functions counts the number of records that have a value in the field?

Describe the usefulness of the Unique Values property.

How does Access evaluate a criterion expression that just includes a criteria value?

Which of the following criterion expressions searches for a ShippingDate field that greater than January 1,2014?

How many fields does Access allow you to add to the Design grid?

Making changes to the data shown in Datasheet view of a query changes the actual table data.

When you use a wildcard,the criterion of your expression must be enclosed in parentheses.

Which of the following keyboard shortcuts opens the Expression Builder dialog box?

What are the general steps involved with creating,running,and editing a query in Query Design?

To see the results of a query,you must run it.

When building a query,you are limited to adding one table to the Query Design window.

It is possible to display the results of a query in sorted order.

Which of the following can you change in Datasheet view of a query?

The Like comparison operator can help you find records containing data that is similar to,or like,the criterion value.

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

Which of the following functions performs a comparison and does one of two alternatives?

Which of the following wildcard characters matches any single character numeric digit?

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