
BIS 245 BIS245 Final Exam with Answers (DeVry)
BIS 245 BIS245 Week 8 Final Exam
- (TCO 1) A database management system (DBMS) is a collection of programs that
- (TCO 1) You should use Access over Excel when:
- (TCO 1) Access should be used instead of Excel when
- (TCO 1) The view in Access which looks similar to an Excel spreadsheet is
- (TCO 1) Which view best describes the image below?
- (TCO 2) To add, delete, and edit a record (the actual data), use
- (TCO 2) Types of relationships between tables do NOT include
- (TCO 1) To display a subset of records based on certain criteria, use which of the following?
- (TCO 2) Which of the following is NOT a data type in Access?
- (TCO 2) In an ER diagram, a crow's foot is used
- (TCO 2) Another name for a column in an Access table is
- (TCO 3) A relational table includes the following conditions EXCEPT
- (TCO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?
- (TCO 3) Which data type will increment automatically each time a new record is entered into a table?
- (TCO 3) The field property that ensures that the field is not empty is
- (TCO 4) All of the following make good candidates for a FIELD on an employee table EXCEPT
- (TCO 4) Which of the following is NOT an Access data type?
- (TCOÂ 2) Which of the following is a property that determines how much physical storage the field requires in the database?
- (TCO 2) In a relational database, entities are
- (TCO 2) All of the following are questions to ask in the process of identifying Entities EXCEPT
- (TCO 2) Which of the following is NOT a step in the Database Life Cycle? Â (See Week 3 Lecture)
- (TCO 2) All of the following should be considered in designing a relational database EXCEPT
- (TCO 2) A one-to-many relationship is
- (TCO 2) An associative table is
- (TCO 3) Which of the following does NOT describe data redundancy?
- (TCO 4) Attributes are represented as
- (TCO 4) Which is NOT true of validation rules?
- (TCO 4) Which statement is true when referential integrity is enforced?
- (TCO 1) When designing a database, you should
- (TCO 2) When constructing criteria for a query, you should use
- (TCO 2) In Access, query results are displayed in which view?
- (TCO 2) Which of the following is not a recommended practice for designing multi-table queries?
- (TCO 2) The command language used with relational databases is
- (TCO 2) The term cardinality refers to
- (TCO 2) Validation text
- (TCO 2) You can add records (data) through the
- (TCO 6) Which of the following does NOT describe data redundancy?
- (TCO 6) Which of the following is true about a crosstab query?
- (TCO 2) A default value is
- (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?
- (TCO 2) An input mask
- (TCO 2) An input mask that will only allow for digits from 0 to 9 and the + or - sign is
- (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is
- (TCO 5) To edit a form, use the
- (TCO 5) All of the following are performed in the design view of a form EXCEPT
- (TCO 5) Which statement below best describes how designers and users work with forms?
- (TCO 5) In the design view of a form, which of the following would NOT be performed?
- (TCO 5) All of the following are aggregate functions EXCEPT
- (TCO 1) When creating a report, which of the following should you should consider?
- (TCO 1) Which of the following is NOT a Report Wizard Layout type?
- (TCO 1) All of the following are report sections EXCEPT
- (TCO 1) Which report section would be used to summarize grouped field data at the end of each group?
- (TCO 1) A report can be created from
- (TCO 1) By default, Print Preview will
- (TCO 1) When designing a report, make sure that your report
- (TCO 7) Data mining refers to
- (TCO 7) A Drill button is used to
- (TCO 7) All of the following are Aggregate Functions EXCEPT