BIS245 Final Exam New Version

BUY BIS245 Final Exam New Version

(TCO 1) Which of the following is NOT an Access interface element? (Points : 5)

Criteria

Navigation Pane

Status Bar

Title Bar

Question 4.4. (TCO 1) Filters are used to do all of the following EXCEPT (Points : 5)

a filter can be removed by selecting Remove Filter from the Sort & Filter group.

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

filter effects are cumulative.

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

Question 5.5. (TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5)

report tool.

report design.

report wizard.

blank report.

Question 6.6. (TCO 2) Which of the following is not a database system? (Points : 5)

Hierarchical

Network

Relational

SQL

Question 7.7. (TCO 3) Which of the following should be considered when designing a database? (Points : 5)

How calculated fields are used

Store data in its smallest parts

The relationship between attribute keys

The relationships between records

Question 8.8. (TCO 3) All of the following describe a caption property EXCEPT (Points : 5)

allows for placing spaces between words.

can take the place of a field name in Datasheet View.

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

the caption appears in Datasheet, Report, and Form views.

Question 9.9. (TCO 3) All of the following summarize characteristics of a PivotTable EXCEPT (Points : 5)

can display information that is typically found in Datasheet totals.

can only be created from a table.

data is organized and summarized in an easy-to-read view.

is created by dragging fields from a field list into appropriate drop zones.

Question 10.10. (TCO 3) Which of the following does NOT describe a caption property? (Points : 5)

A label can substitute for a field name in Datasheet View.

The caption appears in Datasheet View, Form, and Report.

The label allows spaces between words.

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

Question 11.11. (TCO 4) Which function is used to isolate a specific portion of a date such as year, month, or day in a date field? (Points : 5)

Date

DateDiff

DateParse

DatePart

1. (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? (Points : 5)

Datasheet Form

Multiple Items Form

Split Form

Subform

Question 2.2. (TCO 5) A bound control (Points : 5)

always contains a label.

contains text and number values entered by the user.

is unique and contains a data field from another underlying source.

must contain a formula.

Question 3.3. (TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties? (Points : 5)

Function

Identifier

Operator

Value

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

11

16

18

50

Question 5.5. (TCO 7) Which term best describes demographics? (Points : 5)

It is a bar code on a card that contains information about you.

It defines population into segmented groups such as age, income, gender, and race.

It is the quantity of merchandise a store will purchase.

It is tracking customer purchases.

Question 6.6. (TCO 7) Discrete data (Points : 5)

are easily scaled.

are used to measure time or money.

cannot be subdivided into meaningful information.

may be subdivided into smaller and smaller units.

Question 7.7. (TCO 8) All of the following describe a Navigation Form EXCEPT (Points : 5)

click the Create tab and then Navigation in the Forms group to create a Navigation form.

is another term for a Switchboard Manager.

helps users open forms and reports.

has the look and feel of a Web form.

Question 8.8. Of the following security techniques available in Microsoft Access to keep a database application safe, which choice would make the database virtually impossible to break into: (Points : 5)

Creating a menu system

Encrypting and password-protecting the database

Digitally signing and publishing the database

Saving the database as an ACCDE file

Question 9.9. (TCO 9) Database security is a specialty within computer security that protects a database application from unintended use. Unintended use includes: (Points : 5)

unauthorized viewing of data

inadvertent mistakes made by employees

malicious attacks

all of the above

Question 10.10. (TCO 10) After creating an ACCDE file, you (Points : 5)

can convert it back to its source format.

will see a "file already in use" message that continues to display to all other users.

will be able to modify forms and reports but not tables.

will need to go back to the original file if an underlying object requires a change.

Question 11.11. (TCO 4) Which of the following is NOT true of a ship date field? (Points : 5)

A ship date is considered a constant.

A ship date would be defined as a date/time field.

A ship date would be defined as a calculated field.

Date arithmetic can be applied to a ship date field.

1. (TCO 1) Let’s imagine this scenario. Development of a database system is about to start. Before development actually starts, the Director of Systems Development asks you to evaluate the database schema design and report your observations. Given this scenario what would you look for? Please discuss and explain. (Points : 40)

Question 2. 2. (TCO 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. (Points : 40)

Question 3. 3. (TCO 4) What are the advantages and disadvantages of de-normalization process. (Points : 40)

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

Question 3: Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes.

Question1: TCO 1) Justify the decision to use a Report instead of a Form to present Last Month's Sales Results to the Sales Managers at the Monthly Business Meeting.

Question 2: (TCO 2) the relational model relies on primary keys to identify entities and on foreign keys to create relationships to preserve the integrity (validity) of the keys. Discuss the two rules that ensure the integrity of keys within a database.