Question 1

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 2

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 3

To move a field in the query design grid, click its ____, and then drag it left or right.

Accepted Answer

A)  field selector 
B)  field key 
C)  field string 
D)  field tag 
A)  field selector 
B)  field key 
C)  field string 
D)  field tag

Question 4

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

Accepted Answer

A)  query 
B)  objectivity 
C)  connection 
D)  link 
A)  query 
B)  objectivity 
C)  connection 
D)  link

Question 5

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

Accepted Answer

A)  title 
B)  field 
C)  category 
D)  entry 
A)  title 
B)  field 
C)  category 
D)  entry

Question 6

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order

Question 7

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

Accepted Answer

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

Question 8

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Accepted Answer

A) True 
 B)False

Question 9

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The accompanying figure shows the query in ____ View.

Accepted Answer

A)  Criteria 
B)  Design 
C)  Field 
D)  None of the above 
A)  Criteria 
B)  Design 
C)  Field 
D)  None of the above

Question 12

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

Accepted Answer

A) > B) >= C) < D) <= A) > B) >= C) < D) <=

Question 13

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Accepted Answer

A)  filter 
B)  query 
C)  grid 
D)  sort 
A)  filter 
B)  query 
C)  grid 
D)  sort

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

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 16

SQL is the acronym for " Simple Query Language ."

Accepted Answer

A) True 
 B)False

Question 17

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

Accepted Answer

A)  Criteria 
B)  Filters 
C)  Queries 
D)  none of the above 
A)  Criteria 
B)  Filters 
C)  Queries 
D)  none of the above

Question 18

In the accompanying figure, StateName and Price are ____ names.

Accepted Answer

A)  table 
B)  report 
C)  field 
D)  query 
A)  table 
B)  report 
C)  field 
D)  query

Question 19

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 20

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

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

To move a field in the query design grid, click its ____, and then drag it left or right.

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

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

Explain the difference between AND and OR criteria.

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

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Deleting a field from a query also deletes it from the underlying table.

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

The accompanying figure shows the query in ____ View.

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

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

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

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.

SQL is the acronym for " Simple Query Language ."

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

In the accompanying figure, StateName and Price are ____ names.

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

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

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 2: Getting Started With Access 2013

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

To move a field in the query design grid, click its ____, and then drag it left or right.

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

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

Explain the difference between AND and OR criteria.

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

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Deleting a field from a query also deletes it from the underlying table.

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

The accompanying figure shows the query in ____ View.

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

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

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

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.

SQL is the acronym for " Simple Query Language ."

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

In the accompanying figure, StateName and Price are ____ names.

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

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

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters