1. (TCO 1) A foreign key is: (Points : 5) a value which 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.2. (TCO 1) In what situation would Access be a better choice than Excel? (Points : 5) You have a limited amount of data. You have an extensive amount of data. You need to conduct extensive statistical analyses on your data. You require a flat file view of your data. Question 3.3. (TCO 1) When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. (Points : 5) Label Tool Tabular Layout Report Blank Report Tool Report Wizard Question 4.4. (TCO 1) Most of the printed documents generated by managers using Access will come from ______________. (Points : 5) tables queries forms reports Question 5.5. (TCO 1) Which of the following is NOT one of the query wizards in Access: (Points : 5) Find Duplicates Query Simple Query Multi Tabular Query Crosstab Query Question 6.6. (TCO 2) A field that uniquely identifies each record in a table is a (Points : 5) link. relationship. primary key. foreign key. Question 7.7. (TCO 2) A single crow's foot at the left-most end of a relationship line would indicate a (Points : 5) many-to-many relationship. one-to-many relationship. one-to-one relationship. no relationship. Question 8.8. (TCO 2) Which of the following is supported by a primary key? (Points : 5) Changeable over time May be null Unique Updateable Question 9.9. (TCO 2) A symbol used in ER diagrams for an entity is a (Points : 5) box. diamond. line. triangle. Question 10.10. (TCO 3) All of the following summarize characteristics of a PivotChart EXCEPT (Points : 5) a PivotChart is created automatically each time a PivotTable is created. changes made to a PivotTable will be made automatically to the PivotChart. some chart types are bar, line, column, pie, scatter, doughnut, and radar. PivotChart elements are modified in the Design View. Question 11.11. (TCO 4) When building a calculated field, formulas can be created using the (Points : 5) form wizard. expression builder. report builder. table wizard.