Bis 245 Week 8 Final Exam

BIS 245 Week 8 Final Exam

Purchase here

http://devrycourse.com/BIS%20245/bis-245-week-8-final-exam

Product Description

1. (TCO 1) To delete the filter shown below

(Points : 5)

click Filter in the Sort & Filter group and select Clear Filter.

click Remove Filter in the Sort & Filter group.

right click on any number in the Quantity column and select Clear filter from Quantity.

right click on any record in the table and select Clear filter from Quantity.

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

Criteria

Form

Query

Table

3. (TCO 1) To design a report you should do all of the following EXCEPT (Points : 5)

draw a paper design of the report.

identify all sources of data, fields and groups.

nput the data.

select a reporting tool.

4. (TCO 1) All of the following filters work EXCEPT (Points : 5)

filter by selection with an equal condition.

filter by selection with a comparison operator.

filter by selection with an edit operator.

filter by form with a comparison operator.

5. (TCO 1) A Detail line is used to (Points : 5)

print more detailed information on one record only.

provide additional field information on a record.

repeat data for each record in the record source.

All of the above

6. (TCO 2) Which of the following is not a database system? (Points : 5)

Hierarchical

Network

Relational

SQL

7. (TCO 2) A symbol used in ER diagrams for an entity is a (Points : 5)

box.

diamond.

line.

triangle.

8. (TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a (Points : 5)

caption.

default value.

input mask.

rule.

9. (TCO 3) Summarized data in an easy-to-read view is known as a (Points : 5)

design.

PivotTable.

eport.

table

10. (TCO 3) Which of the following is NOT true of indexed property? (Points : 5)

An example of a setting is Yes (No Duplicates).

Indexing a...