Question 1 5 pts (TCO 1) A foreign key is a value that can connect two tables simultaneously. a unique value that identifies each row within a table....

Question 1

(TCO 1) A foreign key is

a value that can connect two tables simultaneously.

a unique value that identifies each row within a table.

another name for a candidate key.

a field in one table that is also the primary key of another table.

Flag this Question

Question 2

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

Criteria

Form

Query

Table

Flag this Question

Question 3

(TCO 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 Design tool

Report tool

Blank Report tool

Report Wizard tool

Flag this Question

Question 4

(TCO 1) Filters are used to do all of the following EXCEPT

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.

Flag this Question

Question 5

(TCO 1) Which one of the following report sections appear once on every report page?

Report Header section

Report Footer section

Page Footer section

Detail section

Flag this Question

Question 6

(TCO 2) The number of records in a relationship is a(n)

cardinality.

domain.

entity.

key.

Flag this Question

Question 7

(TCO 2) A single Crow's Foot at the left-most end of a relationship line would indicate

a many-to-many relationship.

a one-to-many relationship.

a one-to-one relationship.

no relationship.

Flag this Question

Question 8

(TCO 3) All of the following are reasons to save first name and last name as separate fields EXCEPT

fewer fields are used.

first name could be used in a salutation.

last name could be used in a salutation.

you can sort on last name then first name.

Flag this Question

Question 9

(TCO 3) Attributes are better defined as

a column.

a description of an entity.

a characteristic of an entity.

All of the above

Flag this Question

Question 10

(TCO 3) Which of the following does NOT apply to the following relationship image?

Image Description: Three Tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products.

A one-to-many relationship is applied.

The display is showing the Design view of relationships.

One table is not joined to the other two tables.

A join exists on two primary keys.

Flag this Question

Question 11

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

structural

functional

referential

transitive

Flag this Question

Question 12

(TCO 5) All of the following describe form usage EXCEPT

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

a form can show data from only one table.

forms restrict data entry to one record at a time.

you can create Access forms to match paper forms.

Flag this Question

Question 13

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

Validation rule

Validation text

Indexed

Expression

Flag this Question

Question 14

(TCO 6) Which of the following describes a poor design consideration for a form?

Arrange controls closely together or in a sequence that is easy to read by the user.

Each form should have a different theme.

Make labels descriptive and clear.

Right-align labels followed by a colon and left-align bound controls.

Flag this Question

Question 15

(TCO 6) The benefit of a relationship is to

efficiently combine data from related tables.

facilitate how Access will manage the relationship.

determine which fields to include in each table.

minimize data redundancy.

Flag this Question

Question 16

(TCO 9) Default normalization form 4 takes place

when third normal-form has one and only one candidate key, which is a primary key.

when third normal-form includes several candidate keys.

when all candidate keys are identified.

when all tables are related.

Flag this Question

Question 17

(TCO 2) Which of the following statements best describes data mining?

It is the determining of future volume of sales.

It is the predicting of future customer buying behavior.

It is identifying patterns or relationships through a process of analyzing large quantities of data.

It is tracking customer purchasing behavior.

Flag this Question

Question 18

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

form

utility

switchboard

object

Flag this Question

Question 19

(TCO 9) Open Exclusive means that

a password is required to open the Access database.

only one person has access to the Access database at any time.

only selected persons can have access to the Access database.

two or more people cannot open the same Access database at the same time.

Flag this Question

Question 20

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

unauthorized viewing of data.

inadvertent mistakes made by employees.

malicious attacks.

All of the above

Flag this Question

Question 21

(TCO 10) ACCDE files

deny users permission to create and change forms and reports within a database.

deny users permission to create forms and reports but will allow them to modify forms and reports.

give users permission to create and change forms and reports within a database.

give users permission to fully access a database.

Flag this Question

Question 22

(TCO 4) The term cascading refers to

data changes travel from one table to another.

data is put in sequential order.

queries can retrieve data at a faster rate.

records are arranged in order.

Flag this Question

Question 23

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

HTML EditorKeyboard Shortcuts

 12ptParagraph

p

Flag this Question

Question 24

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

HTML EditorKeyboard Shortcuts

 12ptParagraph

p

Flag this Question

Question 25

1. (TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explainhow that normal form is often violated by inexperienced database designers and
2. how to correct such a violation of that normal form.

HTML EditorKeyboard Shortcuts

 12ptParagraph

p

Flag this Question

Question 26

(TCO 4) Explain a one-to-many relationship and provide two examples.