Question 1

Quotation marks are automatically added to criteria for fields with a Date/Time data type.​

Accepted Answer

The answer of Quotation marks are automatically added to criteria...

Question 2

Discuss adding or deleting a table in a query.

Accepted Answer

The answer of Discuss adding or deleting a table in...

Question 3

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

Accepted Answer

left

Question 4

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

Accepted Answer

The answer of To move fields in the query grid,...

Question 5

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Accepted Answer

The answer of To search for a pattern, you can...

Question 6

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Accepted Answer

The answer of Filter By ____________________ is a fast and...

Question 7

In Query Design View, record selectors are thin gray bars above the field names in the query grid.

Accepted Answer

field

Question 8

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

Accepted Answer

header

Question 9

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.​

Accepted Answer

The answer of The ____________________ button provides filter features such...

Question 10

Compare the capabilities of queries and filters.

Accepted Answer

The answer of Compare the capabilities of queries and filters....

Question 11

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

Accepted Answer

The answer of To add a table's field list to...

Question 12

Is ____________________ criteria will find all records where no entry has been made in the field.

Accepted Answer

The answer of Is ____________________ criteria will find all records...

Question 13

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Accepted Answer

As you add more OR criteria, you actually increase the number of records selected. This is because each additional OR criterion allows for more potential matches, resulting in a larger dataset.

Question 14

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

Accepted Answer

table

Question 15

To make a page wider than it is tall, use landscape orientation.

Accepted Answer

Landscape orientation is wider than it is tall, while portrait orientation is taller than it is wide.

Question 16

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

Accepted Answer

Clicking the Undo button will cancel the changes made by the find-and-replace effort if it did not work correctly.

Question 17

____________________ are limiting conditions you set in the query design grid.

Accepted Answer

The answer of ____________________ are limiting conditions you set in...

Question 18

Explain the difference between AND and OR criteria.

Accepted Answer

The answer of Explain the difference between AND and OR...

Question 19

SQL is the acronym for " Simple Query Language ."

Accepted Answer

SQL stands for Structured Query Language, not Simple Query Language.

Question 20

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

Accepted Answer

The answer of ____________________ a table or query datasheet temporarily...

Quiz 2: Building and Using Queries