Exam 1: Access: Introduction to Access

Only the most complex databases have more than one table.

To view or modify a table's structure you would go to what view?

Match the following terms with their description: I. Form II. Report III. Macro IV. Sort V. Filter A. A way of displaying data in which the data cannot be changed B. Changes the order of how records are displayed C. Using this is the normal way of entering data D. Limits the amount of data displayed E. A stored set of commands

Match the following terms with their description: I. Navigation Pane II. Object III. Primary key IV. Record V. Relationship A. A component which makes the database function B. A complete collection of all fields about one entity C. A connection between tables using a common field D. That which uniquely identifies records in a table E. An interface that lists Access objects

Before you can password protect a database you must open it in ________ mode.

Normally Access uses a(n)________ Documents interface.

Using Filter by Form allows you to filter on ________ criteria.

Pressing the ________ key when you are in the last field in the last record will enter a new record.

When you click the Enable Content warning, the database is now ________.

Be careful before you delete a record from a table.

A customer's cell phone would be an example of a ________.

Which of the following is not a valid comparison operator?