BIS245 FINAL EXAM

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 candidat e 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. 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 (CO 3) Which of the following is NOT true of indexed property? An example of a setting is yes (no duplicates). Indexing a table speeds the retrieval time. Primary keys must be indexed. Setting the index requires each record to be scanned sequentially and saves time searching data. Question 11 (CO 4) Which of the following does NOT describe the following description of a one-to-one relationship? Description: Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols. The tables must have exactly the same fields. The Employees and New Employees tables use the same primary key. More tables can be joined to either table. It may be used for security reasons to protect data availability. Question 12 (CO 5) To edit a form, use datasheet view. wizard view. layout view. design view. Question 13 (CO 5) The following are form creation tools except blank form. form design. form layout. form wizard. Question 14 (CO 6) Queries are objects in a database based on one or more underlying forms. modules. tables. macros. Question 15 (CO 6) After running a query, which view will be shown? Datasheet Design Query Result Question 16 (CO 9) A deletion anomaly is deleting facts about one entity successfull