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

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

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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 criterion expressions searches for a ShippingDate field that greater than January 1,2014?

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

Describe the usefulness of the Unique Values property.

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

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

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

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

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

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

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 functions performs a comparison and does one of two alternatives?

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

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