Exam 2: Introduction to Access

When you double-click a query, the interface looks like a(n) ________.

Only the most complex databases have more than one table.

Using the Back Up Database utility only saves the structure of the database, not the content.

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

As long as your data is accurate there is no real need to print preview your reports.

The ________ data type is generated by Access whenever a new record is created.

Using the Compact and Repair Database utility on a regular basis is good practice.

How many records do most forms display?

Which of the following produces a subset of your data?

You can create a(n) ________ from your own database so that you can reuse its structure whenever you need.

Tables, queries, forms, and reports are all considered to be ________.

A ________ allows you to select only the records you want.

What allows you to add components to an existing database, rather than creating an entire new database?

Naming a table carefully is very important because it is the only way to describe what data that table contains.

A good practice is to make backups of your databases on different storage devices.

What are the two ways you can view a table?

The ________ filter operator will give you the smallest number hits.

Match the following terms with their description: I. Compact and Repair Database II. Database III. Datasheet view IV. Design view V. Module A. A view which displays an object's structure B. An advanced object within VBA C. A utility that makes a database smaller and fixes errors D. A way of displaying data in a row/column grid E. A collection of data organized as useful information

What interface element shows you the various objects in your database?

When you enter a field into a database, you are entering ________.