Access 3

25 July 2022
4.7 (114 reviews)
45 test answers

Unlock all answers in this set

Unlock answers (41)
question
The default query type for Access is the Crosstab query. ____________________
answer
False
question
To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________
answer
True
question
Hiding a field in Datasheet view removes the field from the current table. ____________________
answer
False
question
When a question is asked of a database using a select query, the answer is returned as a data sheet. ____________________
answer
True
question
It is more efficient to use the Query Wizard for common, informational queries than to design your own query. ____________________
answer
False
question
Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ____________________
answer
True
question
It is not possible to create a query from more than one table. ____________________
answer
False
question
Fields included in a query may be modified after the query is saved. ____________________
answer
True
question
Logical operators must be used in order to combine two or more conditions in a query. ____________________
answer
True
question
Results of a query are narrowed by using the Or logical operator. ____________________
answer
False
question
The contents of query datasheet are permanent. ____________________
answer
False
question
The process of rearranging records in a specified order or sequence is referred to as sorting. ____________________
answer
True
question
Access may base queries on one or more tables or queries. ____________________
answer
True
question
A sort field is unique if more than one record can have the same value for the sort field. __________________
answer
False
question
The most simple technique to use for filtering records is Filter By Form. ____________________
answer
False
question
Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________
answer
False
question
Expression Builder is found in the Query Setup group on the DESIGN tab. ____________________
answer
True
question
Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.
answer
Run
question
The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.
answer
maintaining
question
Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?
answer
editing mode
question
Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?
answer
Ctrl+Home
question
The ____ command removes the display of one or more fields in Datasheet view.
answer
Hide Fields
question
Which view must be used to delete an entire record?
answer
Datasheet
question
A query based on more than one table is a(n) ____query.
answer
multitable
question
Queries based on more than one table, must have a ____ field.
answer
common
question
A field with the Short Text data type sorted in descending order will display the data in which order?
answer
Z to A
question
Data may be sorted in a table datasheet, a form, and a ____.
answer
query datasheet
question
When the sort field data for each record in a database is different, the sort field is ____.
answer
unique
question
The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.
answer
primary
question
In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.
answer
leftmost
question
The comparison operator, < >, is used to insert a condition that means ____.
answer
not equal to
question
In the criterion, <=250, the operator will return values for the specified field that are ____.
answer
less than or equal to 250
question
To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.
answer
rename
question
A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.
answer
expression
question
The + symbol is an example of a(n) ____ operator.
answer
arithmetic
question
A calculated field is formatted using the ____ for the field.
answer
Property Sheet
question
Which aggregate function would be used to calculate the lowest field value for the selected records?
answer
Minimum
question
Which aggregate function supports the Yes/No field data type?
answer
Count
question
Which comparison operator matches a pattern that includes wildcards?
answer
Like
question
The ___________________ command allows hidden fields to be redisplayed.
answer
Unhide Fields
question
The default name for a new Access query is ____________________.
answer
Query1
question
Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.
answer
navigation
question
A ____________________ is a set of records that answers the question resulting from a query.
answer
recordset
question
The ascending sort order for the Date/Time data type sorts dates from ____________________.
answer
oldest to most recent date
question
A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.
answer
filter