Exam 18: Finalizing 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.

When you use a form to add or change the data in a record, you have to use the Refresh All button on the ____ tab to update the corresponding table.

The ____________________ layout places field labels at the top of a column, which makes it appear like a table.

In a ____ relationship, one record from a table is related to many records in another table, as when one order contains many items purchased by a customer.

Access gives you the option of printing database reports.Please describe the types of information database reports often include.

Case 18-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. -Over time, as the data in the database changes, the Web version will ____.

Click the Open (blank) record button to add a new record._________________________

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

-Referring to the figure above, in order to print the Products Query report, you will 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.

Case 18-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. -To get started, Darcy opens the report she wants to convert to a Web page and then clicks the ____ tab.

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

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.

You can organize your data into ____ using a table, which is the best way to view the data contained in a large number of records.

Layout View provides maximum flexibility for designing a form, but requires more time on your part._________________________

____ a report to open it.

As with other Web pages, your report must be in ____ format to be accessible to Web browsers.

In database terminology, a link between two tables is called a(n) ____.

The Columnar form layout places field labels at the top of a column, which makes it appear like a table._________________________

You are limited to one grouping level per report.