BIS 245 Final Exam

Question 1 (CO 1) A foreign key is a value that can connect two tables simultaneously. a unique value that identifies each row within a table. another name for a candidate key. a field in one table that is also the primary key of another table. Question 2 (CO 1) In what situation would Excel be a better choice than Access? You have a limited amount of data or must do a complicated calculation. You have an extensive amount of data. You need to maintain constant connectivity to an external database. You require a relational view of your data. Question 3 (CO 1) The navigation pane allows you to open tables. open views. filter by datatype. filter by group and navigate to category. Question 4 (CO 1) Filters are used to do all of the following except a filter can be removed by selecting remove filter from the sort & filter group. all records in a table will be displayed if all of the filters are removed. filter effects are cumulative. it does not matter whether you apply a filter or a sort first.