Here is some information about your Final Exam.

It’s time to show your skills and knowledge of what you have learned.

• The Final Exam covers COs 1–10 and all assigned chapters.

• The Final Exam is worth 270 points, consisting of the following.  

o 22 multiple choice questions, 5 points each (110 points total)

o four essay questions, 40 points each (160 points total)

• Remember to save your answers often.

• You have 3 hours and 30 minutes to complete the exam.

• Remember to submit your exam when you are finished.

• By submitting this work, I am attesting that it abides by the Student Honor Code.

Good luck!

Question 1

(CO 1) All of the following are Access objects except

• criteria.

• table.

• form.

• query.

Question 2

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

• Criteria

• Table

• Query

• Form

Question 3

(CO 1) Which one of the following tools is the quickest way to create a tabular report in MS Access based on the selected table or query?

• Report tool options

• Report Design tool

• Report Wizard tool

• Blank Report tool

Question 4

(CO 1) Filters are used to do all of the following except

• filter effects are cumulative.

• all records in a table will be displayed if all of the filters are removed.

• a filter can be removed by selecting remove filter from the sort & filter group.

• it does not matter whether you apply a filter or a sort first.

Question 5

(CO 1) Which of the following is NOT one of the query wizards in Access?

• Multitabular query

• Simple query

• Find duplicates query

• Crosstab query

Question 6

(CO 2) A table is also recognized as a(n)

• entity.

• domain.

• cardinality.

• key.

Question 7

(CO 2) SQL is a fourth-generation language that is

• flat-file oriented and nonprocedural.

• table oriented and nonprocedural.

• oriented toward static data.

• procedural and record oriented.

Question 8

(CO 3) All of the following describe a caption property except

• allows for placing spaces between words.

• can be used in place of a field name in an expression.

• the caption appears in datasheet, report, and form views.

• can take the place of a field name in datasheet view.

Question 9

(CO 3) The following data type would appear as a checkbox in a table.

• Number

• Attribute

• Yes/No

• Text

Question 10

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

• Tables, forms, queries, and reports have a set of properties.

• Design properties are displayed in datasheet view.

• A property is an object's characteristic or attribute.

• A property sheet is used to make changes.

Question 11

(CO 4) In a _____ dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time, and room number. Course would uniquely identify an instructor.

• functional

• structural

• transitive

• referential

Question 12

(CO 5) All of the following describe form usage except

• a form user should have less input errors than a table user.

• forms restrict data entry to one record at a time.

• a form can show data from only one table.

• you can create Access forms to match paper forms.

Question 13

(CO 5) Which database property type increases the efficiency of a search on the designated field in the physical database?

• Validation text

• Expression

• Indexed

• Validation rule

Question 14

(CO 6) Which of the following statements is NOT correct about a query?

• Instructions on the format to display data are saved within a query.

• Changing data values in a query will not change data values in a table.

• Instructions on which data to display are saved within a query.

• Data is not saved within a query.

Question 15

(CO 6) Using the rules for order of operations, what is the result of the following expression: (4 * 3) +1 + 4 - 2 * 3 + 5?

• 11

• 16

• 50

• 18

Question 16

(CO 9) Normalization improves

• flexibility.

• All of the above

• easier to modify.

• organization.

Question 17

(CO 2) A validation rule

• can prohibit values from being entered that may not meet a

• criterion.

• makes a value entered into a field appear in a particular

• format.

• compares a field to a table.

• is an error message that appears when a value is incorrectly

entered into a field.

Question 18

(CO 8) The _____ interface displays a menu that provides the ability to open the various objects within the database and to move easily from one object to another.

• switchboard form or navigation form

• form

• object

• utility

Question 19

(CO 9) An encrypted file is

• created by scrambling the content.

• protected by a password.

• saved with a specific file extension.

• unreadable if it is opened through a tampering tool or another program.

Question 20

(CO 9) When a user creates his or her own self-signed digital signature,

• it will prove that the creator does not own the database.

• it is created through anyone.

• only a commercial service or local server for processing will work.

• only provides users proof that the software can be trusted.

Question 21

(CO 10) The table analyzer tool does this for your database.

• Make suggestions to create another query

• Make suggestions to create another report

• Will not improve the database

• Make suggestions to minimize duplication of data

Question 22

(CO 4) Which database property type helps keep data consistent when doing data entry?

• Validation text

• Indexed

• Expression

• Validation rule

Question 23

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

Question 24

(CO 2) What is a conceptual model? Explain its importance. Conceptual models are typically made up of three main parts. Name these parts giving a full definition and purpose. Give two possible examples of each part.

Question 25

(CO 4) Conceptual design begins with a big-picture view and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step.

Question 26

(CO 4) When constructing a database, two rules are followed by the database designer to ensure the integrity of keys. Describe each rule, and discuss common violations.