BIS 245 Week 8 Final Exam

Question: (TCO 1) Which object would you use to enter, delete, or modify data? Question: (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Question: (TCO 1) To design a ...

Question: (TCO 1) Which object would you use to enter, delete, or modify data? Question: (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Question: (TCO 1) To design a report you should do all of the following EXCEPT Question: (TCO 1) Which of the following is NOT a Report Section? Question: (TCO 1) A Detail line is used to Question: (TCO 2) For the following image, which of the following is TRUE? Question: (TCO 2) A symbol used in ER diagrams for an entity is a Question: (TCO 3) A property that provides a “user friendly” name to a column in Datasheet View is a Question: (TCO 3) Summarized data in an easy-to-read view is known as a Question: (TCO 3) Which of the following is NOT true of a property? Question: (TCO 4) Which of the following does NOT describe the following one-to-one relationship? Page 2 Question: (TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics? Question: (TCO 5) A calculated control Question: (TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties? Question: (TCO 6) Data aggregates Question: (TCO 7) When making vertical data comparisons, you should use the following chart. Question: (TCO 7) Discrete data Question: (TCO 8) A switchboard is a Question: (TCO 9) To secure an Access database, all of the following should be done EXCEPT Question: (TCO 9) All of the following describe a certification authority EXCEPT Question: (TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms…..? Question: (TCO 4) The term “cascading” refers to Explanatory Question: (TCO 1) Describe three-tier architecture. Explain the functions performed by each tier. Question: (TCO 2) Explain business logic and describe how it relates to a relational database. Question: (TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain (1) how that normal form is often violated by inexperienced database designers and (2) how to correct such a violation of that normal form. Question: (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design.