Deck 2: Building and Using Queries

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

In the figure above,  item 3 could also be entered as ____.

A) colorado
B) COLORADO
C) CoLoRaDo
D) All of the above

Question 5

The question mark (?) is the wildcard character which stands for any single character in criteria.

Question 6

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

Question 7

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

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

Question 8

A join line is also called a ____ line.

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

Question 9

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

Question 10

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

Question 11

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

Question 12

A query can be used to create calculated fields.

Question 13

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Question 14

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

Question 15

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

Question 16

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

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

Question 17

SQL stands for ____.

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

Question 18

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

Question 19

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

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

Question 20

A filter can be used to create calculated fields.

Question 21

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

A) Like
B) Is Null
C) And
D) Is Not Null

Question 22

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

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

Question 23

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

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

Question 24

When you double-click a field in a field list in Query Design View, it is

A) Deleted from the query
B) Added to the next available position in the query design grid
C) Used as the first sort order
D) Set as the primary key field

Question 25

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

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

Question 26

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

A) Criteria
B) Filters
C) Queries
D) None of the above

Question 27

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

A) Records
B) Link line
C) Datasheet
D) Tables

Question 28

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

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

Question 29

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

A) 0
B) Is Not Null
C) *=*
D) * *

Question 30

In the figure above, which button opens the Find and Replace dialog box?

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

Question 31

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

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

Question 32

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

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

Question 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

Criteria ____ is the term for rules by which criteria must be entered in a query.

A) Syntax
B) Formatting
C) Sorting
D) Filter by Form

Question 37

In the figure above, item 3 points to ____.

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

Question 38

In the figure above, which button would you use to filter for an exact match?

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

Question 39

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

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

Question 40

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

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

Question 41

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

Question 42

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

Question 43

Compare the capabilities of queries and filters.

Question 44

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

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

Question 45

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

Question 46

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

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

Question 47

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

Question 48

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

Question 49

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

Question 50

Define sorting, filtering, and finding.

Question 51

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

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

Question 52

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

Question 53

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

Question 54

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

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

Question 55

Explain the difference between AND and OR criteria.

Question 56

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.

Question 57

Is ____________________ criteria will find all records where no entry has been made in the field.

Question 58

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.

Question 59

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

Question 60

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

Question 61

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

Question 62

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?

Question 64

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

Question 65

SQL is the acronym for " simple query language ".

Question 66

The record selector button is to the right of a record in a datasheet.

Question 67

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

Question 68

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 wants to build a query that will show each customer name, day of the week (if specific), and subdivision.What criterion should he use to quickly find his customers whose day of the week varies?