Exam 11: Finalizing a Database

In a ____ relationship, a record in one table can be related to several records in another table and vice versa.

You can use the Relationships group on the ____ tab to create, view, and modify relationships between the tables in a database.

To move a label and the associated ____, click to select the object, move the pointer over the edge of the object until the pointer changes to a 4-headed arrow shape, then drag the label and data field to a new location.

Click the ____ button to sort from Z to A or high to low.

Click the FILE tab, click Print, then click Print again to display the ____.

Most of the time, you'll want to include a subset of the fields on a form.

The ____ helps you design an on-screen form in which you can enter and manipulate data for each record of a database.

Reports often include totals and subtotals as well as detailed information.

A database form allows you to view your data one record at a time.

Grouping helps arrange data when you want to produce a report containing ____.

The Form Wizard includes a section on laying out your form. Please describe the four types of form layouts.

A ____ relationship means that a record in one table is related to only one record in another table. This type of relationship is rare in the world of databases.

The ____________________ form layout places labels next to fields, and lists the fields in columns.

As the data in your database changes, the Web page version of the report automatically updates.

A(n) ____________________ allows you to view your data one record at a time, with the fields of each record arranged on your computer screen as they might be arranged on a printed form.