DeVry  BIS 245

 WEEK 5 QUIZ

Question 1. (TCO 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.

Question 2. (TCO 2) An example of a multiple value field would be

a criteria comparison of values in two or more fields.

a default value that appears automatically.

something that appears in a predefined dropdown list.

when more than one data item can be accepted in a single field.

Question 3. (TCO 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.

Question 4. (TCO 2) An input mask that will only allow for digits from 0 to 9 and the + or – sign is

AA.

99.

##.

00.

Question 5. (TCO 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. (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.

Question 7. (TCO 5) A calculated control is

a bound box.

a text box containing a description.

an unbound box that the user will fill in with a numeric value.

contains a formula that displays the result.

Question 8. (TCO 5) A datasheet form

is a form that allows the user to change the appearance of the form.

and a table are the same thing.

entry by a user is always linked to the content of a table.

provides the user with the same look as a table.

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

Question 10. (TCO 5) All of the following are aggregate functions EXCEPT

average.

count.

minimum.

subtract.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.