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 51

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following functions converts a value to uppercase?

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

E) B) and C)
F) A) and D)

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) C) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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