Question 1

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 2

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

Accepted Answer

A)  > 
B)  >= 
C) .. 
D) . 
A)  > 
B)  >= 
C) .. 
D) .

Question 3

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

Question 4

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 5

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Accepted Answer

A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced 
A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced

Question 6

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

Accepted Answer

A) True 
 B)False

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

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

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

A query can be used to create calculated fields.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

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

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

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

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

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

A query can be used to create calculated fields.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

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

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