Access 3

Your page rank:

Total word count: 743
Pages: 3

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

The default query type for Access is the Crosstab query. ____________________

False

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________

True

Hiding a field in Datasheet view removes the field from the current table. ____________________

False

When a question is asked of a database using a select query, the answer is returned as a data sheet. ____________________

True

It is more efficient to use the Query Wizard for common, informational queries than to design your own query. ____________________

False

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ____________________

True

It is not possible to create a query from more than one table. ____________________

False

Fields included in a query may be modified after the query is saved. ____________________

True

Logical operators must be used in order to combine two or more conditions in a query. ____________________

True

Results of a query are narrowed by using the Or logical operator. ____________________

False

The contents of query datasheet are permanent. ____________________

False

The process of rearranging records in a specified order or sequence is referred to as sorting. ____________________

True

Access may base queries on one or more tables or queries. ____________________

True

A sort field is unique if more than one record can have the same value for the sort field. __________________

False

The most simple technique to use for filtering records is Filter By Form. ____________________

False

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

False

Expression Builder is found in the Query Setup group on the DESIGN tab. ____________________

True

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

Run

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

maintaining

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

editing mode

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Ctrl+Home

The ____ command removes the display of one or more fields in Datasheet view.

Hide Fields

Which view must be used to delete an entire record?

Datasheet

A query based on more than one table is a(n) ____query.

multitable

Queries based on more than one table, must have a ____ field.

common

A field with the Short Text data type sorted in descending order will display the data in which order?

Z to A

Data may be sorted in a table datasheet, a form, and a ____.

query datasheet

When the sort field data for each record in a database is different, the sort field is ____.

unique

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

primary

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.

leftmost

The comparison operator, < >, is used to insert a condition that means ____.

not equal to

In the criterion, <=250, the operator will return values for the specified field that are ____.

less than or equal to 250

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

rename

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.

expression

The + symbol is an example of a(n) ____ operator.

arithmetic

A calculated field is formatted using the ____ for the field.

Property Sheet

Which aggregate function would be used to calculate the lowest field value for the selected records?

Minimum

Which aggregate function supports the Yes/No field data type?

Count

Which comparison operator matches a pattern that includes wildcards?

Like

The ___________________ command allows hidden fields to be redisplayed.

Unhide Fields

The default name for a new Access query is ____________________.

Query1

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

navigation

A ____________________ is a set of records that answers the question resulting from a query.

recordset

The ascending sort order for the Date/Time data type sorts dates from ____________________.

oldest to most recent date

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

filter

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending