Deck 3: Building and Using Queries

Question 1

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

Answer 1

True

Question 2

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

A) fix
B) post
C) freeze
D) view

Answer 2

C

Question 3

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

Answer 3

True

Question 4

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

Question 5

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Question 6

Query Design View presents the fields you can use for a query in small windows called field ____.

A) glossaries
B) lists
C) links
D) catalogs

Question 7

To filter for comparative data, use the Filter By Selection feature.

Question 8

A query can be used to create calculated fields.

Question 9

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Question 10

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

A) criteria
B) posts
C) versioning
D) indices

Question 11

SQL stands for ____.

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

A) logical view
B) duplicate copy
C) table simulator
D) warehouse

Question 16

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

Question 17

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

Question 18

A filter can be used to create calculated fields.

Question 19

Access saves ____ automatically as you move from record to record.

A) data
B) queries
C) tables
D) all of the above

Question 20

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

Question 21

In the accompanying figure, "StateName" and "Price" are ____ names.

A) table
B) report
C) field
D) query

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

A join line is also called a(n) ____ line.

A) query
B) link
C) connection
D) objectivity

Question 24

The bottom button in the accompanying figure ____.

A) sorts records in descending order
B) sorts records in ascending order
C) helps you navigate to the first, previous, next, last, or new record
D) removes the current sort order

Question 25

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

A) ampersand (&)
B) question mark (?)
C) exclamation mark (!)
D) caret (^)

Question 26

The ____ button provides a list of values in the selected field that can be used to customize a filter.

A) Values
B) Selection
C) Filter
D) Advanced

Question 27

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

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

Question 28

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

A) filter
B) query
C) grid
D) sort

Question 29

A(n) ____ is a saved object within the datasheet.

A) query
B) filter
C) find
D) union

Question 30

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

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

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

Question 32

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 33

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 34

The accompanying figure shows the query in ____ View.

A) Criteria
B) Design
C) Field
D) None of the above

Question 35

In the accompanying figure, "StateName" and "StateAbbreviation" appear in the States ____ list.

A) title
B) field
C) category
D) entry

Question 36

____ are tests 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 37

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

A) query
B) objectivity
C) connection
D) link

Question 38

To move a field in the query design grid, click its ____, and then drag it left or right.

A) field selector
B) field key
C) field string
D) field tag

Question 39

The top button in the accompanying figure ____.

A) sorts records in descending order
B) sorts records in ascending order
C) helps you select a single record or all records in a datasheet
D) removes the current sort order

Question 40

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

A) Comparative
B) Selection
C) Comparison
D) Advanced

Question 41

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Question 42

Compare the capabilities of queries and filters.

Question 43

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

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

Question 44

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

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

Question 45

Explain the difference between AND and OR criteria.

Question 46

SQL is the acronym for "Simple Query Language." _________________________

Question 47

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Question 48

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

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

Question 49

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

Question 50

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

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

Question 51

A(n) ____________________ answers a question about the information in the database.

Question 52

____________________ are limiting conditions you set in the query design grid.

Question 53

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

Question 54

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

Question 55

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

Question 56

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

Question 57

Discuss adding or deleting a table in a query.

Question 58

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

Question 59

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

Question 60

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

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

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Question 63

By default, the printout of a datasheet contains the object name and current date in the footer. ____________________

Question 64

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
The lower pane in Query Design View

Question 65

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes. _________________________

Question 66

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Used to search for a pattern

Question 67

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Creates a datasheet of selected fields and records from one or more tables

Question 68

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Limiting conditions used to narrow the number of records on a datasheet

Question 69

To make a page wider than it is tall, use landscape orientation. _________________________

Question 70

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Creates a temporary subset of records

Question 71

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

Question 72

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Criterion that finds all records where no entry has been made in the field

Question 73

Match each term with the statement that best describes it.
a.Is Null
e.datasheet
b.wildcard
f.filter
c.sorting
g.criteria
d.query
h.query grid
Putting records in ascending or descending order based on a field's values

Question 74

Case 2-1
Daniel Arno owns a lawn and landscape business with many clients. Occasionally, he wants to filter the data about his customers in various ways.
Daniel uses a one-character code to indicate which day of the week certain customers of his have their lawns cut. Which of the following wildcard characters could he use to search for a single character (e.g., F for Friday)?

A) *
B) &
C) ?
D) %

Question 75

Case 2-1
Daniel Arno owns a lawn and landscape business with many clients. Occasionally, he wants to filter the data about his customers in various ways.
Daniel wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

A) Find
B) Like
C) Search
D) Near