Question 1

To move fields in the query grid, drag the field ____________________.

Accepted Answer

The answer of To move fields in the query grid,...

Question 2

In the figure above, which button would you use to filter for more than one criterion?

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5 
A)  2 
B)  3 
C)  4 
D)  5

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)  Logical View 
B)  Duplicate Copy 
C)  Table Simulator 
D)  Warehouse 
A)  Logical View 
B)  Duplicate Copy 
C)  Table Simulator 
D)  Warehouse

Question 5

In the figure above, item 4 points to a ____.

Accepted Answer

A)  Field name 
B)  Primary key fields 
C)  Design view 
D)  Tables 
A)  Field name 
B)  Primary key fields 
C)  Design view 
D)  Tables

Question 6

In the figure above, item 2 points to the ____.

Accepted Answer

A)  Criteria cells 
B)  Datasheet view 
C)  Field list 
D)  Design grid 
A)  Criteria cells 
B)  Datasheet view 
C)  Field list 
D)  Design grid

Question 7

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of To add a table's field list to...

Question 9

____ are rules 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 10

A query is commonly used as the source of data for a form or report.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Each time a query is opened, it displays a current view of the latest updates to the database.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

____ 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 16

In the figure above, item 4 points to "Cost" as the ____.

Accepted Answer

A)  Fourth field of a query 
B)  Date/Time field 
C)  Query design grid 
D)  None of the above 
A)  Fourth field of a query 
B)  Date/Time field 
C)  Query design grid 
D)  None of the above

Question 17

In the figure above, item 1 points to the ____.

Accepted Answer

A)  Grid button 
B)  Table button 
C)  View button 
D)  Report button 
A)  Grid button 
B)  Table button 
C)  View button 
D)  Report button

Question 18

____________________ means temporarily isolating a subset of records in a table or query.

Accepted Answer

The answer of ____________________ means temporarily isolating a subset of...

Question 19

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

Accepted Answer

The answer of A(n) ____________________ is a database object that...

To move fields in the query grid, drag the field ____________________.

In the figure above, which button would you use to filter for more than one criterion?

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

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

In the figure above, item 4 points to a ____.

In the figure above, item 2 points to the ____.

A query can be used to create calculated fields.

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

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

A query is commonly used as the source of data for a form or report.

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

Each time a query is opened, it displays a current view of the latest updates to the database.

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

SQL stands for ____.

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

In the figure above, item 4 points to "Cost" as the ____.

In the figure above, item 1 points to the ____.

____________________ means temporarily isolating a subset of records in a table or query.

A filter can be used to create calculated fields.

A(n) ____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

Getting Started With Access 2.0

Using Forms

Using Reports Question

Getting Started With Microsoft

Web Apps: Working With Windows Live and Office Web Apps

Filters

Exam 2: Building and Using Queries

To move fields in the query grid, drag the field ____________________.

In the figure above, which button would you use to filter for more than one criterion?

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

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

In the figure above, item 4 points to a ____.

In the figure above, item 2 points to the ____.

A query can be used to create calculated fields.

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

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

A query is commonly used as the source of data for a form or report.

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

Each time a query is opened, it displays a current view of the latest updates to the database.

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

SQL stands for ____.

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

In the figure above, item 4 points to "Cost" as the ____.

In the figure above, item 1 points to the ____.

____________________ means temporarily isolating a subset of records in a table or query.

A filter can be used to create calculated fields.

A(n) ____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

Getting Started With Access 2.0

Using Forms

Using Reports Question

Getting Started With Microsoft

Web Apps: Working With Windows Live and Office Web Apps

Filters