BIS 245 BIS245 Final Exam with Answers (DeVry)

BIS 245 BIS245 Week 8 Final Exam

1. (TCO 1) A database management system (DBMS) is a collection of programs that
2. (TCO 1) You should use Access over Excel when:
3. (TCO 1) Access should be used instead of Excel when
4. (TCO 1) The view in Access which looks similar to an Excel spreadsheet is
5. (TCO 1) Which view best describes the image below?
6. (TCO 2) To add, delete, and edit a record (the actual data), use
7. (TCO 2) Types of relationships between tables do NOT include
8. (TCO 1) To display a subset of records based on certain criteria, use which of the following?
9. (TCO 2) Which of the following is NOT a data type in Access?
10. (TCO 2) In an ER diagram, a crow's foot is used
11. (TCO 2) Another name for a column in an Access table is
12. (TCO 3) A relational table includes the following conditions EXCEPT
13. (TCO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?
14. (TCO 3) Which data type will increment automatically each time a new record is entered into a table?
15. (TCO 3) The field property that ensures that the field is not empty is
16. (TCO 4) All of the following make good candidates for a FIELD on an employee table EXCEPT
17. (TCO 4) Which of the following is NOT an Access data type?
18. (TCO 2) Which of the following is a property that determines how much physical storage the field requires in the database?
19. (TCO 2) In a relational database, entities are
20. (TCO 2) All of the following are questions to ask in the process of identifying Entities EXCEPT
21. (TCO 2) Which of the following is NOT a step in the Database Life Cycle?  (See Week 3 Lecture)
22. (TCO 2) All of the following should be considered in designing a relational database EXCEPT
23. (TCO 2) A one-to-many relationship is
24. (TCO 2) An associative table is
25. (TCO 3) Which of the following does NOT describe data redundancy?
26. (TCO 4) Attributes are represented as
27. (TCO 4) Which is NOT true of validation rules?
28. (TCO 4) Which statement is true when referential integrity is enforced?
29. (TCO 1) When designing a database, you should
30. (TCO 2) When constructing criteria for a query, you should use
31. (TCO 2) In Access, query results are displayed in which view?
32. (TCO 2) Which of the following is not a recommended practice for designing multi-table queries?
33. (TCO 2) The command language used with relational databases is
34. (TCO 2) The term cardinality refers to
35. (TCO 2) Validation text
36. (TCO 2) You can add records (data) through the
37. (TCO 6) Which of the following does NOT describe data redundancy?
38. (TCO 6) Which of the following is true about a crosstab query?
39. (TCO 2) A default value is
40. (TCO 2) When entering data into a field, which of the following would require the user to input a value that is higher than a zero?
41. (TCO 2) An input mask
42. (TCO 2) An input mask that will only allow for digits from 0 to 9 and the + or - sign is
43. (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is
44. (TCO 5) To edit a form, use the
45. (TCO 5) All of the following are performed in the design view of a form EXCEPT
46. (TCO 5) Which statement below best describes how designers and users work with forms?
47. (TCO 5) In the design view of a form, which of the following would NOT be performed?
48. (TCO 5) All of the following are aggregate functions EXCEPT
49. (TCO 1) When creating a report, which of the following should you should consider?
50. (TCO 1) Which of the following is NOT a Report Wizard Layout type?
51. (TCO 1) All of the following are report sections EXCEPT
52. (TCO 1) Which report section would be used to summarize grouped field data at the end of each group?
53. (TCO 1) A report can be created from
54. (TCO 1) By default, Print Preview will
55. (TCO 1) When designing a report, make sure that your report
56. (TCO 7) Data mining refers to
57. (TCO 7) A Drill button is used to
58. (TCO 7) All of the following are Aggregate Functions EXCEPT