Access Unit B- Building and Using Queries Test
In the figure above, which button indicates whether a filter is applied or not?
3
In the figure above, which button would you use to filter for more than one criterion?
4
In the figure above, which button would you use to filter for an exact match?
5
In the figure above, which button opens the Find and Replace dialogue box?
6
Which of the following comparison operators means "less than or equal to"?
<=
Which of the following comparison operators means "not equal to"?
<>
Which of the following comparison operators means "greater than"?
>
To find numbers greater than or equal 500, use which comparison operator?
>=
In the figure above, item 3 points to ___________.
A criteria entry
Which of the following is NOT true about a query?
A query is the same thing as a filter.
When you double-click a field in a field list in Query Design View, it is
Added to the next available position in the query design grid
In the figure above, item 3 could also be entered as ________.
All of the above; other answers: colorado, CoLoRaDo, or COLORADO
The wildcard character that stands for any group of characters is the ________.
Asterisk (*)
Limiting conditions used to narrow the number of records on a datasheet
Criteria
________ are rules or limiting conditions you set to determine which records will be selected in a filter or query.
Criteria
True or False: A filter can be used to create calculated fields.
False
True or False: Deleting a field from a query also deletes it from the underlying table.
False
True or False: The asterisk (*) is the wildcard used to represent one and only one character in criteria.
False
In the figure above, item 2 points to the _______.
Field list
In the figure above, item 4 points to a __________.
Field name
A(n) _______ is a temporary view of the data whose criteria are always discarded when you close the datasheet.
Filter
Creates temporary subset of records
Filter
This button helps search for data in a single field or in all fields.
Find
In the figure above, item 4 points to "Cost" as the ____________.
Fourth field of a query
To find all records where there is any entry in the field, even of the entry is 0, use which criteria?
Is Not Null
Criterion that finds all records where no entry had been made in the field
Is Null
A join line is also called a ________ line.
Link
In the figure above, item 7 points to the __________.
Link line
A query datasheet is sometimes called a __________ of the data.
Logical View
AND criteria
Must all be true for the record to be selected
A(n) _____________ is a saved view of the data whose criteria is not discarded when you close the datasheet.
Query
Creates a datasheet of selected fields and records from one or more tables
Query
The lower pane in Query Design View
Query grid
The wildcard character that stands for any single character is the ________.
Question mark (?)
In the figure above, item 5 points to the ___________.
Related fields
Use the ______ command to save the current object with a new name.
Save Object As
Putting records in ascending or descending order based on a field's values
Sorting
SQL stands for _____.
Structured Query Language
Criteria _______ is the term for rules by which criteria must be entered in a query.
Syntax
Rules that determine how criteria is entered
Syntax
True or False: A Query is commonly used as the source of data for a form or report.
True
True or False: A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.
True
True or False: A query can be used to create calculated fields.
True
True or False: Enter OR criteria on different Criteria rows in the query design grid.
True
True or False: Filters are used to select a subset of records in a database.
True
True or False: Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the rivalry sort field.
True
True or False: The question mark (?) is the wildcard character which stands for any single character in criteria.
True
True or False: To add, delete, or change fields in a query, you use Query Design View.
True
In the figure above, item 1 points to the __________.
View button
Used to search for a pattern
Wildcard
