FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Integrating Applications

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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

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

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

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

Describe the usefulness of the Unique Values property.

Which of the following is a valid criterion for the Number 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 functions counts the number of records that have a value in the field?

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

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

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

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

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

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

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