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.
Written for
- Institution
-
Devry University-Chicago
- Course
-
BIS 245
Document information
- Uploaded on
- December 2, 2023
- Number of pages
- 7
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers