FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Getting Started With Access 2013

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

To add, delete, or change fields in a query, you use Query Design View.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

A query datasheet is sometimes called a ____ of the data.

A) logical view
B) duplicate copy
C) table simulator
D) warehouse

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Use the ____ command to save the current object with a new name.

By default, the printout of a datasheet contains the object name and current date in the footer .

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet.

A(n) ____ is a saved object within the datasheet.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

The bottom button in the accompanying figure ____.

The top button in the accompanying figure ____.

A join line is also called a(n) ____ line.

To move fields in the query grid, drag the field ____________________.

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes.

The question mark (?) is the wildcard character which stands for any single character in criteria.

The record selector button is to the right of a record in a datasheet.

The wildcard character that stands for any group of characters is the ____.

____________________ a table or query datasheet temporarily displays only those records that match given criteria.