BIS 245 Final Exam 100% Correct Answers



(TCO 1) Which object would you use to enter, delete, or modify data?

(TCO 1) Which object would you use to retrieve customers who live in Germany and the United States?

(TCO 1) To design a report you should do all of the following EXCEPT

(TCO 1) Which of the following is NOT a Report Section?

(TCO 1) A Detail line is used to

(TCO 2) For the following image, which of the following is TRUE?

(TCO 2) A symbol used in ER diagrams for an entity is a

(TCO 3) A property that provides a “user friendly” name to a column in Datasheet View is a

(TCO 3) Summarized data in an easy-to-read view is known as a

(TCO 3) Which of the following is NOT true of a property?

(TCO 4) Which of the following does NOT describe the following one-to-one relationship?

(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?

(TCO 5) A calculated control

(TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties?

(TCO 6) Data aggregates

(TCO 7) When making vertical data comparisons, you should use the following chart.

(TCO 7) Discrete data

(TCO 8) A switchboard is a

(TCO 9) To secure an Access database, all of the following should be done EXCEPT

(TCO 9) All of the following describe a certification authority EXCEPT

(TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms and reports?

(TCO 4) The term “cascading” refers to

(TCO 1) Describe three-tier architecture. Explain the functions performed by each tier.

(TCO 2) Explain business logic and describe how it relates to a relational database.

(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.

(TCO 4) Explain 1NF, 2NF, and 3NF as related to database design.