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 21

Multiple Choice

Review LaterAdd Note

Review Later

____ is the default entry for each field in the Total row of the query design grid.

A) Group By
B) SUM
C) Totals
D) Maximum

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Which aggregate function supports the Yes/No field data type?

A) Count
B) Average
C) Minimum
D) Sum

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Which comparison operator matches a pattern that includes wildcards?

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

Identify the letter of the choice that best matches the phrase or definition.

A sort field is unique if more than one record can have the same value for the sort field. __________________

The default group in the Navigation Pane is ____.

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

Fields included in a query may be modified after the query is saved.  ____________________

Case-Based Critical Thinking Questions Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -When creating a query to determine which plants need full sun, which fields must be included in the query?

The comparison operator, , is used to insert a condition that means ____.

The default query type for Access is the Crosstab query.  ____________________

Statistical information such as totals and averages is calculated using ____.

The ___________________ command allows hidden fields to be redisplayed.

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Which aggregate function would be used to calculate the lowest field value for the selected records?

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

Identify the letter of the choice that best matches the phrase or definition.

The default name for a new Access query is ____________________.

The + symbol is an example of a(n) ____ operator.