Exam 3: Building and Using Queries

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

(True/False)

4.8/5

(46)

Question 21

Match each term with the statement that best describes it. -Putting records in ascending or descending order based on a field's values

(Multiple Choice)

4.9/5

(29)

Question 22

Enter OR criteria on different Criteria rows in the query design grid.

(True/False)

4.7/5

(37)

Question 23

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

(True/False)

4.9/5

(39)

Question 24

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

(Multiple Choice)

4.9/5

(34)

Question 25

____ will find all records where there is any entry in the field, even if the entry is 0.

(Multiple Choice)

4.8/5

(34)

Question 26

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

(True/False)

4.9/5

(26)

Question 27

Daniel Arno owns a lawn and landscape business with many clients. Occasionally, he wants to filter the data about his customers in various ways. -Daniel uses a one-character code to indicate which day of the week certain customers of his have their lawns cut. Which of the following wildcard characters could he use to search for a single character (e.g., F for Friday)?

(Multiple Choice)

4.8/5

(41)

Question 28

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

(True/False)

5.0/5

(34)

Question 29

Match each term with the statement that best describes it. -Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

(Multiple Choice)

4.9/5

(37)

Question 30

-In the accompanying figure, "StateName" and "StateAbbreviation" appear in the States ____ list.

(Multiple Choice)

4.8/5

(35)

Question 31

Match each term with the statement that best describes it. -The lower pane in Query Design View

(Multiple Choice)

4.8/5

(35)

Question 32

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

(Multiple Choice)

4.9/5

(39)

Question 33

The ____ button provides a list of values in the selected field that can be used to customize a filter.

(Multiple Choice)

4.9/5

(39)

Question 34

Which of the following comparison operators means "not equal to"?

(Multiple Choice)

4.8/5

(33)

Question 35

Which of the following comparison operators means "less than or equal to"?

(Multiple Choice)

4.9/5

(40)

Question 36

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

(Short Answer)

4.8/5

(37)

Question 37

Match each term with the statement that best describes it. -Creates a temporary subset of records

(Multiple Choice)

4.8/5

(36)

Question 38

Filters are used to select a subset of records in a datasheet.

(True/False)

4.9/5

(37)

Question 39

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

(True/False)

4.9/5

(33)

Question 40

Showing 21 - 40 of 75

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Match each term with the statement that best describes it. -Putting records in ascending or descending order based on a field's values

Enter OR criteria on different Criteria rows in the query design grid.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

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

____ will find all records where there is any entry in the field, even if the entry is 0.

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

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

Match each term with the statement that best describes it. -Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

-In the accompanying figure, "StateName" and "StateAbbreviation" appear in the States ____ list.

Match each term with the statement that best describes it. -The lower pane in Query Design View

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

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Which of the following comparison operators means "not equal to"?

Which of the following comparison operators means "less than or equal to"?

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

Match each term with the statement that best describes it. -Creates a temporary subset of records

Filters are used to select a subset of records in a datasheet.

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters