BIS 245 Quiz Week 5

$4.75

BIS 245 Quiz Week 5 
(CO 2) Using an input mask is complex, however, MS Access provides common input masks, such as…

SKU: BIS 245 Quiz Week 5 DeVry Categories: , Tags: , ,

Description

BIS 245 Quiz Week 5

BIS 245 Quiz Week 5

A+

(CO 2) A validation rule

Can prohibit values from being entered that may not meet a criterion.

Compares a field to a table.

Is an error message that appears when a value is incorrectly entered into a field.

Makes a value entered into a field appear in a particular format.

(CO 2) A field can be added to a report to

Values for two or more fields.

Show a default value.

Appear in a predefined dropdown list.

Add a picture or logo.

(CO 2) Using an input mask is complex, however, MS Access provides common input masks, such as

Phone number or social security number.

Social security number and date and time.

Phone number and address.

Social security number and last name.

(CO 2) A label wizard enables you to create

Reports.

A table.

Mailing labels.

A new window.

(CO 2) An input mask placed on a form will apply to

All forms based on that table.

All forms in the database.

All forms based on that table and the table itself.

That specific form only.

(CO 5) To edit a form, use the

design view.

datasheet view.

layout view.

layout view or design view.

(CO 5) A multiple items form displays

multiple records in a tabular layout similar to a datasheet.

a formula that displays the result.

information from only a query.

a macro to process field information.

(CO 2) A default value is

A predefined list of values that can be selected by the user.

A value that cannot be lower or higher than the selected limit.

A specific value that automatically appears in a field and has edit capabilities.

A specific value that automatically appears in a field that cannot be changed by the user.

(CO 2) Validation text is

An error message that provides instruction on what to fix when an incorrect value is entered into a field.

A list of predefined values that can be entered in a field.

A comparison of values entered in two fields.

A field that requires a value of characters or text only.

(CO 2) An input mask

Allows one record to have more than two field values.

Allows the user to type a social security number as 111223333 and it would display as 111-22-3333.

Confirms that a value greater than 100 is a valid value.

Is a list of values that are previously defined from which the user can select one item.

(CO 2) Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables?

Design view

Fields group

Lookup group

Lookup wizard

(CO 2) An input mask that will NOT accept a letter (A to Z) in a field value is

?

A

L

#

(CO 5) All of the following are performed in the design view of a form except

Adding pictures, lines, calculations, and controls.

Changing the size of the form sections.

Entering a data value.

Modifying the properties of a form.

(CO 5) A form type that displays records in a tabular format, but has more editing options is a(n)

Datasheet form.

Multiple items form.

Split form.

subform.

(CO 5) If you click on the form tool, you will open a(n)

Existing form.

New form in design view.

New form in layout view.

Wizard to design a form.

(CO 5) A split form is best defined as

Most effective when run again on one table.

A form that combines two views of the same record source. Sections may be displayed differently depending on the view.

Can perform complex What-if analyses.

Require a macro in order to be effective.

(CO 5) A form is altered in what view?

Layout view or design view

Database view

Datasheet view

Table view

(TCO 2) A required field that is used in entering data is a field that

Appears with a specific value

Can be left blank

Cannot be left blank

Is selected from a list of values

(TCO 2) An example of a lookup is

one to a million

2010

AL, CA, NC, NY, TX

SSN, Date, 111-22-3333, AZ

(TCO 2) Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is

>

<>

(TCO 2) Which of the following below will provide the current computer data as a default?

–/–/–

CurrentDate()

Date

Date()

(TCO 2) Which of the following is NOT an example of a table event?

Add

Delete

Edit

View

(TCO 5) All of the following are performed in the design view of a form EXCEPT

Adding pictures, lines, calculations, and controls

Changing the size of the form sections

Entering a data value

Modifying the properties of a form

(TCO 5) A bound control

Is a textbox that is connected to a field in a query or a table

Contains a formula that displays the result

Is used to display aggregate information

Uses a macro to process field information

(TCO 5) All of the following are form creation tools EXCEPT

Blank form

Form design

Form layout

Form wizard

(TCO 5) In the design view of a form, which of the following would NOT be performed?

Add calculations, controls, pictures, and lines

Change the size of a form section

Enter a data value

Modify the properties of the form

(TCO 5) Use the Arrange Form Layout Tool to

Change the form layout

Move fields

Insert space

All of the above