Question 1

A(n) ____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

Accepted Answer

A)  Filter 
B)  Query 
C)  Grid 
D)  Sort

Question 2

In the figure above, item 3 points to ____.

Accepted Answer

A)  The title field 
B)  A field list 
C)  The Category field 
D)  A criteria entry

Question 3

Use the ____ command to save the current object with a new name.

Accepted Answer

A)  Datasheet 
B)  View 
C)  Save Object As 
D)  Save

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

To search for a pattern, you can use a ____________________ 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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A)  Ampersand (&) 
B)  Question mark (?) 
C)  Exclamation mark (!) 
D)  Caret (^)

Question 8

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

Accepted Answer

A)   
B)  > 
D)  >=

Question 9

Define sorting, filtering, and finding.

Accepted Answer

The answer of Define sorting, filtering, and finding....

Question 10

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

Accepted Answer

A)  Period (.) 
B)  Semicolon (;) 
C)  Asterisk (*) 
D)  Plus sign (+)

Question 11

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

Accepted Answer

The answer of In Query Design View, the query design...

Question 12

Which of the following comparison operators means "not equal to"?

Accepted Answer

A)  +=+ 
B)  =/= 
C)  > 
D)

Question 13

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 14

Match between columns
                        Premises: Used to search for a pattern
The lower pane in Query Design View
Criterion that finds all records where no entry has been made in the field
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
Creates a temporary subset of records
Rules that determine how criteria is entered
Creates a datasheet of selected fields and records from one or more tables

Accepted Answer

The Answer of Criteria and Query grid and Is Null is...

Question 15

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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 18

In the figure above, which button indicates whether a filter is applied or not?

Accepted Answer

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

Question 19

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

Accepted Answer

A)  Criteria 
B)  Related fields 
C)  Field lists 
D)  None of the above

Question 20

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

Accepted Answer

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

Exam 2: Building and Using Queries

A(n) ____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

In the figure above, item 3 points to ____.

Use the ____ command to save the current object with a new name.

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

To search for a pattern, you can use a ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

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

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

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

Define sorting, filtering, and finding.

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

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

Which of the following comparison operators means "not equal to"?

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

Match each term with the statement that best describes it.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

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

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.

In the figure above, which button indicates whether a filter is applied or not?

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

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