access t3

Your page rank:

Total word count: 472
Pages: 2

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

results of a query may be viewed at any time by clicking the __ button in the results group on the ribbon

run

the query type that gives access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

query by example (QBE)

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 data sheet view

hide fields

in the accompanying figure, how is the match type specified to find the characters "1638"

entire field value

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

data may be sorted in a table data sheet, 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 based on the sort field that is _ in the design grid of the query window

leftmost

the criteria entered in the figure above are an example which logical operator?

and

based on the criterion for the birthdate field in the above image, the query will return all patients with a birth date _

on or before 12/31/1956

the + symbol is an example of a _ operator

arithmetic

the expression builder dialog box is available from which group on the query design tab on the ribbon?

query setup

a calculated field is formatted using the _ for the field

property sheet

a calculated field created in a query generates results when _

when the query is run

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 type data?

count

to add a row labeled "total" to a query design click the _ button in the show/hide group on the design tab on the ribbon

totals

_ is the default entry for each field in the total row of the query design grid

group by

the default group in the navigation pane is

all access objects

which comparison operator matches a pattern that includes wildcards?

like

statistical information such as totals and averages is calculated using _

aggregate functions

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