Access Unit B
False
A filter can be used to create calculated fields. True/False
B. Link
A join line is also called a(n) _____ line. A. Query B. Link C. Connection D. Objectivity
True
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. True/False
True
A query can be used to create calculated fields. True/False
A. Logical View
A query datasheet is sometimes called a _____ of the data. A. Logical view B. Duplicate copy C. Table simulator D. Warehouse
A. Query
A(n) _____ is a saved object within the datasheet. A. Query B. Filter C. Find D. Union
A. Filter
A(n) _______ is temporary view of the data that is removed when you close the datasheet. A. Filter B. Query C. Grid D. Sort
A. Data
Access saves ______ automatically as you move from record to record. A. Data B. Queries C. Tables D. All of the above
True
By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake. True/False
A. Syntax
Criteria _____ is the term for rules by which criteria must be entered in a query. A. Syntax B. Formatting C. Sorting D. Filtering by Form
False
Deleting a field from a query also deletes it from the underlying table. True/False
True
Enter OR criteria on different Criteria rows in the query design grid. True/False
True
Filters are used to select a subset of records in a datasheet. True/False
C. Freeze
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
B. Lists
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
D. Structured Query Language
SQL stands for _____. A. Structured Query Lingo B. Standard Query Lingo C. Standard Query Language D. Structured Query Language
B. Selection
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
C. Filter
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
False
The asterisk (*) is the wildcard used to represent one and only one character in criteria. True/False
False
The easiest way to filter the records for an exact match is to use the Filter By Form feature. True/False
True
The question mark (?) is the wildcard character which stands for any single character in criteria. True/False
C. Asterisk (*)
The wildcard character that stands for any group of characters is the _____. A. Period (.) B. Semicolon (;) C. Asterisk (*) D. Plus sign (+)
B. Question mark (?)
The wildcard character that stands for any single character is the ______. A. Ampersand (&) B. Question mark (?) C. Exclamation mark (!) D. Caret (^)
True
To add, delete, or change fields in a query, you use Query Design View. True/False
True
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. True/False
False
To filter for comparative data, use the Filter By Selection feature. True/False
B. Is Not Null
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. *<>*
D. >=
To find numbers greater than or equal to 500, use which comparison operator? A. <> B. <= C. >> D. >=
A. Field selctor
To move a field in the query design grid, click its _____, and the n drag it left or right. A. Field selector B. Field key C. Field string D. Field tag
C. Save As
Use the _____ command to save the current object with a new name. A. Datasheet B. View C. Save As D. Save
B. Added to the next available position in the query design grid
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
A. >
Which of the following comparison operators means "greater than"? A. > B. >= C. < D. <=
D. <=
Which of the following comparison operators means "less than or equal to"? A. > B. >= C. < D. <=
D. <>
Which of the following comparison operators means "not equal to"? A. +=+ B. =/= C. <<>> D. <>
True
You enter and edit data in a query datasheet in the same way you do in a table datasheet True/False
A. Criteria
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
D. Is Not Null
_____ 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
A. Criteria
______ 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
