BIS245 BIS 245 final exam, BIS245 final exam
    BIS245 BIS 245 final exam, BIS245 final exam

BIS245 BIS 245 final exam, BIS245 final exam

$21.99

Complete the multichoice questions:

. (TCO 2) A validation rule (Points : 4)
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.2. (TCO 2) An example of a multiple value field would be (Points : 4)
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.3. (TCO 2) A logical data validation method is a(n) (Points : 4)
birth date field that cannot exceed a hire date.
entered number less than 100 will not display.
field left blank will display with a default of zero.
social security number entered as 111223333 is displayed as 111-22-3333.

Question 4.4. (TCO 2) An input mask that will only allow for digits from 0 to 9 and the + or - sign is (Points : 4)
AA.
99.
##.
00.

Question 5.5. (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is (Points : 4)
?.
A.
L.
#.

Question 6.6. (TCO 5) To edit a form, use the (Points : 4)
design view.
datasheet view.
layout view.
layout view or design view.

Question 7.7. (TCO 5) A form type that displays records in a tabular format, but has more editing options is a(n) (Points : 4)
datasheet form.
multiple items form.
split form.
subform.

Question 8.8. (TCO 5) All of the following are form creation tools EXCEPT (Points : 4)
blank form.
form design.
form layout.
form wizard.

Question 9.9. (TCO 5) The title for a form should be placed in the (Points : 4)
details area.
form header.
textbox in the details area.
textbox in the form header.

Question 10.10. (TCO 5) All of the following are aggregate functions EXCEPT (Points : 4)
average.
count.
minimum.
subtract.

(TCO 1) Which object would you use to enter, delete, or modify data?

(TCO 1) Which object would you use to retrieve customers who live in Germany and the United States?

(TCO 1) To design a report you should do all of the following EXCEPT

(TCO 1) Which of the following is NOT a Report Section?

(TCO 1) A Detail line is used to

(TCO 2) For the following image, which of the following is TRUE?

(TCO 2) A symbol used in ER diagrams for an entity is a

(TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a

(TCO 3) Summarized data in an easy-to-read view is known as a

(TCO 3) Which of the following is NOT true of a property?

(TCO 4) Which of the following does NOT describe the following one-to-one relationship?

(TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics?

(TCO 5) A calculated control

(TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties?

(TCO 6) Data aggregates

(TCO 7) When making vertical data comparisons, you should use the following chart.

(TCO 7) Discrete data

(TCO 8) A switchboard is a

(TCO 9) To secure an Access database, all of the following should be done EXCEPT

(TCO 9) All of the following describe a certification authority EXCEPT

(TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms and reports?

(TCO 4) The term "cascading" refers to

(TCO 1) Describe three-tier architecture. Explain the functions performed by each tier.

(TCO 2) Explain business logic and describe how it relates to a relational database

(TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain (1) how that normal form is often violated by inexperienced database designers and (2) how to correct such a violation of that normal form

(TCO 4) Explain 1NF, 2NF, and 3NF as related to database design