Question 1

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

Accepted Answer

A)  
B) > 
D) >=

Question 2

SQL stands for ____.

Accepted Answer

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

Question 3

Filters are used to select a subset of records in a datasheet.

Accepted Answer

A) True 
 B)False

Question 4

Compare the capabilities of queries and filters.

Accepted Answer

The answer of Compare the capabilities of queries and filters....

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

Accepted Answer

The answer of Filter By ____________________ filters records based on...

Question 8

This button helps search for data in a single field or in all fields.

Accepted Answer

A) Find 
B) Sort Ascending 
C) Filter By String 
D) Filter By Criteria

Question 9

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel creates a query using the Name, Day of the Week, and Subdivision fields.He wants to sort the records by day of the week, beginning with Monday and ending with Sunday.He decides to number each day of the week: 1=Monday, 2=Tuesday, and so forth. 
a. Will his idea work? 
b. Why or why not? 
c. Should he plan to sort in ascending or descending order?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 10

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 11

Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.

Accepted Answer

A) True 
 B)False

Question 12

A(n)____ is a saved view of the data whose criteria is not discarded when you close the datasheet.

Accepted Answer

A) Query 
B) Filter 
C) Find 
D) Union

Question 13

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 14

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

Question 15

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

Accepted Answer

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

Question 16

A join line is also called a ____ line.

Accepted Answer

A) Query 
B) Link 
C) Connection 
D) Objectivity

Question 17

In Query Design View, record selectors are thin gray bars above the field names.

Accepted Answer

A) True 
 B)False

Question 18

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 19

____ 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

Question 20

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

Exam 2: Building and Using Queries

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

SQL stands for ____.

Filters are used to select a subset of records in a datasheet.

Compare the capabilities of queries and filters.

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

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

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

This button helps search for data in a single field or in all fields.

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

Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.

A(n) ____ is a saved view of the data whose criteria is not discarded when you close the datasheet.

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

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

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

A join line is also called a ____ line.

In Query Design View, record selectors are thin gray bars above the field names.

A filter can be used to create calculated fields.

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

In the figure above, item 3 points to ____.