BIS-245 Final Exam

BIS-245 Final Exam

Author: Christine Farr


(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

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.