Access

Your page rank:

Total word count: 1012
Pages: 4

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

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

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

remove fields

Which view must be used to delete an entire record?

datasheet

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

common

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

unique

The AutoFilter sort method works on a(n)____ field(s).

mulitply

A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.

sort order

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 250

The condition "Seattle" for the field City in a student database is an example of what type of value?

critera value

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

include comparison operators

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

builder

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

query setup

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

count

____ is the default entry for each field in the Total row of the query design grid.

totals

Statistical information such as totals and averages is calculated using ____.

math operators

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? When creating a query to determine which plants need full sun, which fields must be included in the query?

amount of sun and went to plant

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? After creating the query, Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun, little sun, and full sun. How should Jorge enter the criteria for the exact match of full sun?

<=fullsun

orge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?

‘yes’

Data in a form may only be modified in ____ view. (

datasheet

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

desing box

Which of the following may be used as a wildcard character when searching for a value in Access?

#

A form created from two tables that have a ____ relationship creates a main form and a subform.

one to one

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

modify

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

criteria

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

the order of the fields inthe table being used for the report

Before applying a conditional format in a report, the ____ box must be selected.

field value

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box. (

ctl

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

change caption

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

change page orientation

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

primary record

To print two records from a form, select the ____ option in the Print dialog box.

range

Data in a form created from the primary table is contained in the ____.

subform

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Datasheet Layout

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

#

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

#

A form must be displayed in ____________________ view to navigate, view, and edit data.

Design

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