FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

The condition "Seattle" for the field City in a student database is an example of what type of value?

A) text value
B) field value
C) comparison value
D) criteria value

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

When the sort field data for each record in a database is different,the sort field is ____.

A) ascending
B) unique
C) nonunique
D) descending

E) A) and B)
F) All of the above

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Data may be sorted in a table datasheet,a form,and a ____.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

The default name for a new Access query is ____________________.

The most simple technique to use for filtering records is Filter By Form.____________________

Which comparison operator matches a pattern that includes wildcards?

A ____________________ is a set of records that answers the question resulting from a query.

Date criteria are automatically enclosed in ____ when entered in a query design.

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Identify the letter of the choice that best matches the phrase or definition. -Operators that allow two or more conditions to be combined such as And.

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

The ____ command removes the display of one or more fields in Datasheet view.

Identify the letter of the choice that best matches the phrase or definition. -The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.