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.
Question 5
(CO 1) Which one of the following report sections appear once on every report page?
Report header section
, Report footer section
Page footer section
Detail section
Question 6
(CO 2) A table is also recognized as a(n)
cardinality.
domain.
entity.red
key.
Question 7
(CO 2) A symbol used in ER diagrams for an entity is a
box.
diamond.
line.
triangle.
Question 8
(CO 3) All of the following are reasons to save first name and last name as separate fields except
fewer fields are used.
first name could be used in a salutation.
last name could be used in a salutation.
you can sort on last name then first name.
Question 9
(CO 3) A functional dependency is
a logical relationship between attributes of a table.
a logical primary key.
a composite key.
a unique identifier.
Question 10
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.
Question 5
(CO 1) Which one of the following report sections appear once on every report page?
Report header section
, Report footer section
Page footer section
Detail section
Question 6
(CO 2) A table is also recognized as a(n)
cardinality.
domain.
entity.red
key.
Question 7
(CO 2) A symbol used in ER diagrams for an entity is a
box.
diamond.
line.
triangle.
Question 8
(CO 3) All of the following are reasons to save first name and last name as separate fields except
fewer fields are used.
first name could be used in a salutation.
last name could be used in a salutation.
you can sort on last name then first name.
Question 9
(CO 3) A functional dependency is
a logical relationship between attributes of a table.
a logical primary key.
a composite key.
a unique identifier.
Question 10
