Question 1

An advantage of a query is that you can select only the fields you wish to view instead of working with all of the fields of several large tables.

Accepted Answer

A) True 
 B)False

Question 2

Filter By ____________________ is the fastest way to filter records for an exact match.

Accepted Answer

The answer of Filter By ____________________ is the fastest way...

Question 3

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 4

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 5

The upper portion of Query Design View shows a table's ____________________ list.

Accepted Answer

The answer of The upper portion of Query Design View...

Question 6

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 (+)

An advantage of a query is that you can select only the fields you wish to view instead of working with all of the fields of several large tables.

Filter By ____________________ is the fastest way to filter records for an exact match.

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.

The upper portion of Query Design View shows a table's ____________________ list.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

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

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

Getting Started With Microsoft Office 2010 Question

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 2: Building and Using Queries

An advantage of a query is that you can select only the fields you wish to view instead of working with all of the fields of several large tables.

Filter By ____________________ is the fastest way to filter records for an exact match.

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.

The upper portion of Query Design View shows a table's ____________________ list.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

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

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

Getting Started With Microsoft Office 2010 Question

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters