Access Chapter 2

Front 1

All of the following are suggested guidelines for table design except:

Back 1

Avoid date arithmetic.

Front 2

Which of the following determines the type of data that can be entered and the operations that can be performed on that data?

Back 2

Data type

Front 3

When entering, deleting, or editing table data:

Back 3

The table must be in Datasheet view.

Front 4

When importing data into Access, which of the following statements is true?

Back 4

You can assign a primary key while you are importing Excel data.

Front 5

The main reason to enforce referential integrity in Access is to:

Back 5

Keep invalid data from being entered into a table.

Front 6

An illustration of a one-to-many relationship would be a:

Back 6

Customer may have multiple orders.

Front 7

A query’s specifications providing instructions about which records to include must be entered on the:

Back 7

Criteria row of the query design grid.

Front 8

When adding Value criteria to the Query Design view, the value you enter must be delimited by:

Back 8

Nothing ().

Front 9

It is more efficient to make a copy of an existing query rather than create a new query when which of the following is true?

Back 9

The existing query and the new query use the same tables and fields.

Front 10

Which of the following is true for the Query Wizard?

Back 10

No criteria can be added.