Question 1. Which object would you use to enter, delete, or modify data?

Criteria

Form

Query

Table

Question 2. In what situation would Excel be a better choice than Access?

You have a limited amount of data.

You have an extensive amount of data.

You need to maintain constant connectivity to an external database.

You require a relational view of your data.

Question 3. All of the following are Report Wizard Layout types EXCEPT

block.

outline.

stepped.

summary.

Question 4. All of the following filters work EXCEPT

filter by selection with an equal condition.

filter by selection with a comparison operator.

filter by selection with an edit operator.

filter by form with a comparison operator.

Question 5. A report creation tool that will automatically pull in the fields from a table or query is the

report tool.

report design.

report wizard.

blank report.

Question 6. A field that uniquely identifies each record in a table is a

link.

relationship.

primary key.

foreign key.

Question 7. Which of the following should be considered when designing a database?

How calculated fields are used

Store data in its smallest parts

The relationship between attribute keys

The relationships between records

Question 8. All of the following describe a caption property EXCEPT

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. All of the following summarize characteristics of a PivotTable EXCEPT

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. Which of the following is NOT true of a property?

A property is an object's characteristic or attribute.

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

A property sheet is used to make changes.

Design properties are displayed in Datasheet View.

Question 11. When building a calculated field, formulas can be created using the

form wizard.

expression builder.

report builder.

table wizard.

Part 2-

Question 1. When certain attributes cannot be entered into a database without the existence of other attributes; such as not being able to add a new course to the schedule unless a student is enrolled in the course, then this would be an illustration of:

Insert anomaly

1:M relationship

Update anomaly

Foreign Keys

Question 2. A calculated control

contains a formula that displays the result.

is a bound box.

is a text box containing a description.

is an unbound box that the user will fill in with a numeric value.

Question 3. Which of the following is a term used to describe the names of controls, fields, or properties?

Function

Identifier

Operator

Value

Question 4. Which of the following expressions is NOT correct?

Cost: [Price] * [Qty]

DiscountAmt = [Price] * [Qty] * [Discount]

PrPerSqFt: [SalePr] / [SqFt]

Sales: [GP] * [Qty]

Question 5. To display data as percentages of a whole, use the following chart.

Bar

Line

Pie

Scatter Plot

Question 6. Effective PivotTables and PivotCharts are usually based on a

form.

query.

report.

table.

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

Question 8. 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.

Question 9. A digital signature

helps ensure that a file has not been tampered with and will be safe to open.

is used with database files exclusively.

is a tracking system of a file.

must be obtained from a certification authority such as VeriSign.

Question 10. After creating an ACCDE file, you

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. Which statement below is NOT true of the one-to-many relationships?

It is the least used type of relationship.

OrderID is a unique identification number that would be used in the Orders table and Order Details table.

Each record in the Orders table may match one, more than one, or no records in the Order Details table.

Each record in a Orders table matches only one record in the Customers table.

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

Question 2. Explain entity integrity and referential integrity. Give an example of each.

Question 3. 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 4. If you were given an ERD that contained an M:N relationship between Orders and Products, what would you need to do in order to create the tables and relationship in Access?