preview

Bis 245 Week 8 Final Exam

Better Essays

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 …show more content…

to manage and optimize the database.
8. (TCO 9) A good password should have (Points : 5) a combination of five letters.

a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.

a word or name that is easy to remember by the user, such as the name of your children.

part of your account name.
9. (TCO 9) All of the following describe a certification authority EXCEPT (Points : 5) a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database.

a certification authority is a commercial company that is highly regulated in most countries.

a fee is charged for the service of issuing and validating identities using a digital signature.

certification authority companies establish their own rules and regulations that users must follow.
10. (TCO 10) To examine the efficiency and performance of an Access database, you should (Points : 5) migrate the database out of Access and into a larger DBMS.

move the database to its own dedicated server.

redesign your database applying 3NF principles.

use the Performance Analyzer and Table Analyzer to optimize the performance of the database.
11. (TCO 4) Which statement below is NOT true of the one-to-many relationships?
(Points : 5) t is the least used type of relationship.

OrderID is a unique identification number that would be used in the Orders

Get Access