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 process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A) reconstructing
B) maintaining
C) developing
D) editing

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

A query based on more than one table is a(n) ____query.

A) multiple
B) advanced
C) relationship
D) multitable

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

To locate a specific field value or part of a field value, a user may search a table datasheet, a query datasheet, or a form using the ____________________.

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.   ____________________

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

A calculated field created in a query generates results when ____.

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

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

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

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

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

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

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