BIS 245 Week 8 Final Exam
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.
This study source was downloaded by 100000830246019 from CourseHero.com on 07-16-2022 14:52:19 GMT -05:00
https://www.coursehero.com/file/11221823/BIS-245-Week-8-Final-Exam/
, 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.
This study source was downloaded by 100000830246019 from CourseHero.com on 07-16-2022 14:52:19 GMT -05:00
https://www.coursehero.com/file/11221823/BIS-245-Week-8-Final-Exam/
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.
This study source was downloaded by 100000830246019 from CourseHero.com on 07-16-2022 14:52:19 GMT -05:00
https://www.coursehero.com/file/11221823/BIS-245-Week-8-Final-Exam/
, 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.
This study source was downloaded by 100000830246019 from CourseHero.com on 07-16-2022 14:52:19 GMT -05:00
https://www.coursehero.com/file/11221823/BIS-245-Week-8-Final-Exam/
