CIT105- ACCESS Quiz 3

Your page rank:

Total word count: 1326
Pages: 5

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

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

A. Table Name

B. Custom

C. Query Name

D. Relationship

B. Custom

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

A. Group By

B. SUM

C. Totals

D. Maximum

A. Group By

A calculated field created in a query generates results when ____.

A. the database is opened

B. the query’s underlying table is opened

C. when a report is created

D. when the query is run

D. when the query is run

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

A. Property Sheet

B. Criteria

C. Expression Builder

D. Operator

A. Property Sheet

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

A. builder

B. expression

C. operator

D. query

B. expression

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

A. sort order

B. condition

C. operator

D. match

B. condition

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

A. A to Z

B. lowest to highest

C. Z to A

D. highest to lowest

C. Z to A

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

A. multiple

B. advanced

C. relationship

D. multitable

D. multitable

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

A. report

B. query datasheet

C. record

D. related table

B. query datasheet

Date criteria are automatically enclosed in ____ when entered in a query design.

A. quotes

B. parenthesis

C. brackets

D. number signs

D. number signs

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.

A. leftmost

B. rightmost

C. adjacent to the leftmost field

D. adjacent to the rightmost field

A. leftmost

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

A. less than 250

B. equal to 250

C. less than or equal to 250

D. greater than or equal to 250

C. less than or equal to 250

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?

A. =>full sun

B. <=fullsun

C. <> full sun

D. "full sun"

D. "full sun"

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

A. Yes

B. >No

C. check=yes

D. ‘yes’

A. Yes

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?

A. Plant Name and When to Plant

B. Amount of Sun and Annual

C. Plant Name and Amount of Sun

D. Amount of Sun and When to Plant

C. Plant Name and Amount of Sun

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

A. common

B. similar

C. text

D. calculated

A. common

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

A. Run

B. Append

C. Show

D. Design

A. Run

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

A. comparison operators

B. mathematical operators

C. aggregate functions

D. logical functions

C. aggregate functions

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

A. Hide Fields

B. Unhide Fields

C. Remove Fields

D. Display Fields

A. Hide Fields

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

A. arithmetic

B. logical

C. comparison

D. calculation

A. arithmetic

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

A. multiple

B. 10 fields

C. adjacent

D. single

D. single

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

A. greater than

B. And

C. less than

D. not equal to

D. not equal to

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

A. text value

B. field value

C. comparison value

D. criteria value

A. text value

The default group in the Navigation Pane is ____.

A. Object Type

B. All Access Objects

C. Table

D. Design Grids

B. All Access Objects

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

A. Query Type

B. Show/Hide

C. Query Setup

D. Results

C. Query Setup

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

A. table

B. chronological

C. primary

D. adjacent

C. primary

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

A. reconstructing

B. maintaining

C. developing

D. editing

D. editing

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)

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.

A. SUM

B. New Row

C. Totals

D. Add All

C. Totals

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

A. modify

B. rename

C. delete the existing query

D. include comparison operators

B. rename

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

A. ascending

B. unique

C. nonunique

D. descending

B. unique

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

A. Count

B. Average

C. Minimum

D. Sum

A. Count

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

A. Average

B. Minimum

C. Maximum

D. Count

B. Minimum

Which comparison operator matches a pattern that includes wildcards?

A. Between…And…

B. Or

C. Not

D. Like

D. Like

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

A. Tab

B. Home + Up Arrow

C. Up Arrow

D. Ctrl+Home

D. Ctrl+Home

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

A. navigation mode

B. design mode

C. editing mode

D. selection mode

C. editing mode

Which view must be used to delete an entire record?

A. Design

B. Query

C. Navigation

D. Datasheet

D. Datasheet

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