Exam 6: Access

To see what the report will look like when it is printed, you should change to the ________ view.

The ________ occurs when Access joins two tables that do not have a common field.

To stop editing a record and revert it back to what it was before editing, you press ________.

When you close a program, if you have made changes to the file, a dialog box opens, asking if you wish to ________ your changes.

To compare the values in a table or query to a specific criteria value you set up in the query, you use ________ operators.

You can tell when you are in navigation mode, because the text of a field is selected and highlighted.

To switch between a filtered table and a whole table, use the ________ or the Filtered indicator.

The keyboard shortcut used to access Help is the ________ key.

A built-in combination of color and font is called a(n)________.

When you create a form using two tables with a one-to-many relationship between the tables, Access will automatically use the common field between the tables to create the form.

In Access, the relationship information is stored in the ________ window.

If you are not using the same foreign key in two different tables to create a many-to-many relationship, you must use a ________ table to create the relationship.

When data has a unique identifier included as part of the data, this is called a(n)________ key.

There is an upper limit of 155 characters for a text field.

________ view is only for viewing and changing data in a form.

The view that allows you to view all records in a table at one time is the design view.

You should add fields to the report wizard in the order in which you want the fields to appear in the report.

When you add relationships to tables, you can work with two or more ________ in the same query, report, or form.

Judy needs to create brochures, newsletters and postcards for her home business. She should use the Microsoft ________ program.

A paper copy of a document, spreadsheet, or presentation is called a(n)________.