FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

In the criterion,

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

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

Results of a query are narrowed by using the Or logical operator.

The default query type for Access is the Crosstab query.

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

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

Kyra has been asked to sort a database of cities and zip codes using a query.  The result should show records grouped by city with zip codes in ascending order within the city groups.  What is the best method for Kyra to use to achieve this result?

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

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

The process of rearranging records in a specified order or sequence is referred to as sorting . ____________________

Case-Based Critical Thinking Questions Case 3-2 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? To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query.  The Perennial field has a data type of Yes/No.  Which criterion should Jorge use in the query for the Perennial field?

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

Queries based on more than one table, must have a ____ field.

In the accompanying figure, which field represents a calculated field?

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

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

Which view must be used to delete an entire record?