Question 1

To find numbers greater than or equal to 500, use which comparison operator?

Accepted Answer

A)  # 
B)  > 
D)  >= 
A)  # 
B)  > 
D)  >=

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

Match between columns
                        Premises: Creates a datasheet of selected fields and records from one or more tables
The lower pane in Query Design View
Criterion that finds all records where no entry has been made in the field
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines
Creates a temporary subset of records
Limiting conditions used to narrow the number of records on a datasheet
Putting records in ascending or descending order based on a field's values
Used to search for a pattern

Accepted Answer

The Answer of query and Is Null and sorting and is...

Question 6

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

Question 7

Criteria ____ is the term for rules by which criteria must be entered in a query.

Accepted Answer

A)  Syntax 
B)  Formatting 
C)  Sorting 
D)  Filter by Form 
A)  Syntax 
B)  Formatting 
C)  Sorting 
D)  Filter by Form

Question 8

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Like 
B)  Is Null 
C)  And 
D)  Is Not Null 
A)  Like 
B)  Is Null 
C)  And 
D)  Is Not Null

Question 11

Which of the following comparison operators means "greater than"?

Accepted Answer

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

Question 12

The wildcard character that stands for any single character is the ____.

Accepted Answer

A)  ampersand (&) 
B)  question mark (?) 
C)  exclamation mark (!) 
D)  caret (^) 
A)  ampersand (&) 
B)  question mark (?) 
C)  exclamation mark (!) 
D)  caret (^)

Question 13

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 14

Access saves ____ automatically as you move from record to record.

Accepted Answer

A)  data 
B)  queries 
C)  tables 
D)  all of the above 
A)  data 
B)  queries 
C)  tables 
D)  all of the above

Question 15

SQL stands for ____.

Accepted Answer

A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language 
A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language

Question 16

Compare the capabilities of queries and filters.

Accepted Answer

* Queries are saved as objects in the da

Question 17

To filter for comparative data, use the Filter By Selection feature.

Accepted Answer

A) True 
 B)False

Question 18

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 19

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li

Question 20

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

Accepted Answer

A)  Find 
B)  Like 
C)  Search 
D)  Near 
A)  Find 
B)  Like 
C)  Search 
D)  Near

To find numbers greater than or equal to 500, use which comparison operator?

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.

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

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

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

Criteria ____ is the term for rules by which criteria must be entered in a query.

A filter can be used to create calculated fields.

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

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

Which of the following comparison operators means "greater than"?

The wildcard character that stands for any single character is the ____.

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

Access saves ____ automatically as you move from record to record.

SQL stands for ____.

Compare the capabilities of queries and filters.

To filter for comparative data, use the Filter By Selection feature.

A query can be used to create calculated fields.

Discuss adding or deleting a table in a query.

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

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

To find numbers greater than or equal to 500, use which comparison operator?

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.

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

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

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

Criteria ____ is the term for rules by which criteria must be entered in a query.

A filter can be used to create calculated fields.

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

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

Which of the following comparison operators means "greater than"?

The wildcard character that stands for any single character is the ____.

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

Access saves ____ automatically as you move from record to record.

SQL stands for ____.

Compare the capabilities of queries and filters.

To filter for comparative data, use the Filter By Selection feature.

A query can be used to create calculated fields.

Discuss adding or deleting a table in a query.

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

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