Access 3

Sep 25th, 2023

4.7 (114 reviews)

45 test answers

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

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

1 of 45

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

Don’t waste time

You can get a custom paper by one of our expert writers.

Get your custom essay

Helping students since 2015

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

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

Access 3

Haven't found what you need?