Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Critical Thinking Questions Case 2-1
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)?

Accepted Answer

A)  * 
B)  & 
C)  (?) 
D)  % 
A)  * 
B)  & 
C)  (?) 
D)  %

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

When you double-click a field in a field list in Query Design View, it is ____.

Accepted Answer

A)  deleted from the query 
B)  added to the next available position in the query design grid 
C)  used as the first sort order 
D)  set as the primary key field 
A)  deleted from the query 
B)  added to the next available position in the query design grid 
C)  used as the first sort order 
D)  set as the primary key field

Question 7

Compare the capabilities of queries and filters.

Accepted Answer

* Queries are saved as objects in the da

Question 8

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

Accepted Answer

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

Question 9

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 10

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

Accepted Answer

A)  Values 
B)  Selection 
C)  Filter 
D)  Advanced 
A)  Values 
B)  Selection 
C)  Filter 
D)  Advanced

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  fix 
B)  post 
C)  freeze 
D)  view 
A)  fix 
B)  post 
C)  freeze 
D)  view

Question 13

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

Accepted Answer

The answer of In Query Design View, the query design...

Question 14

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Accepted Answer

The answer of One way to create a new query...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  period (.) 
B)  semicolon (;) 
C)  asterisk (*) 
D)  plus sign (+) 
A)  period (.) 
B)  semicolon (;) 
C)  asterisk (*) 
D)  plus sign (+)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____________________ answers a question about the information in the database.

Accepted Answer

The answer of A(n) ____________________ answers a question about the...

Question 19

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order

Question 20

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

A) True 
 B)False

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

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

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

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.

When you double-click a field in a field list in Query Design View, it is ____.

Compare the capabilities of queries and filters.

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

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

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

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

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

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

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

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

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

A(n) ____________________ answers a question about the information in the database.

Explain the difference between AND and OR criteria.

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 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 2: Building and Using Queries

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

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

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

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.

When you double-click a field in a field list in Query Design View, it is ____.

Compare the capabilities of queries and filters.

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

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

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

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

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

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

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

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

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

A(n) ____________________ answers a question about the information in the database.

Explain the difference between AND and OR criteria.

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 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters