BIS 245 Week 5 Quiz Answers

Score for this quiz: 40 out of 40

 

Question 1

 

(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.

 

 

Question 2

 

(CO 2) When entering data into a field, which of the following would require the user to input a value that is higher than a zero?

   

0

 

 

   

>0

   

=>0

   

>=0>

 

Question 3

 

(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.

 

 

Question 4

 

(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

 

 

Question 5

 

(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.

 

 

Question 6

 

(CO 5) To edit a form, use the

   

design view.

 

   

datasheet view.

 

   

layout view.

 

 

   

layout view or design view.

 

 

Question 7

 

(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.

 

 

Question 8

 

(CO 5) All of the following are form creation tools except

   

blank form.

 

   

form design.

 

 

   

form layout.

 

   

form wizard.

 

 

Question 9

 

(CO 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.

 

 

Question 10

 

(CO 5) Use the arrange form layout tool to

   

change the form layout

 

   

move fields

 

   

insert space.

 

 

   

All of the above

 

 

SmartExpert

(118)

Status NEW Posted 02 Mar 2019 06:03 PM My Price 5.00

BIS----------- 24-----------5 W-----------eek----------- 5 -----------Qui-----------z A-----------nsw-----------ers-----------

Attachments

file 1551551641-BIS 245 Week 5 Quiz Answers.docx preview (294 words )

B-----------IS -----------245----------- We-----------ek -----------5 Q-----------uiz----------- An-----------swe-----------rs ----------- Sc-----------ore----------- fo-----------r t-----------his----------- qu-----------iz:----------- 4-----------0 -----------out----------- of----------- 40----------- Â-----------  -----------Que-----------sti-----------on -----------1 -----------4 -----------/ 4----------- p-----------ts ----------- (C-----------O 2-----------) A----------- va-----------lid-----------ati-----------on -----------rul-----------e -----------Cor-----------rec-----------t! -----------  -----------  ----------- ca-----------n p-----------roh-----------ibi-----------t v-----------alu-----------es -----------fro-----------m b-----------ein-----------g e-----------nte-----------red----------- th-----------at -----------may----------- no-----------t m-----------eet----------- a -----------cri-----------ter-----------ion-----------. -----------  -----------  -----------  ----------- co-----------mpa-----------res----------- a -----------fie-----------ld -----------to -----------a t-----------abl-----------e. -----------  ----------- Â-----------  -----------is -----------an -----------err-----------or -----------mes-----------sag-----------e t-----------hat----------- ap-----------pea-----------rs -----------whe-----------n a----------- va-----------lue----------- is----------- in-----------cor-----------rec-----------tly----------- en-----------ter-----------ed -----------int-----------o a----------- fi-----------eld-----------. ----------- Â-----------  -----------mak-----------es -----------a v-----------alu-----------e e-----------nte-----------red----------- in-----------to -----------a f-----------iel-----------d a-----------ppe-----------ar -----------in -----------a p-----------art-----------icu-----------lar----------- fo-----------rma-----------t. -----------  ----------- Â-----------  -----------Que-----------sti-----------on -----------2

Not Rated(0)

• Buy Answer