Exam 4: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

A ________ is a document that displays database information in a meaningful format.

When viewing a form in Layout view, you realize that the text boxes containing the fields are too wide. Explain how you would narrow the width of the text boxes.

The ________ asks a series of questions and then uses the answers to generate a customized report.

Match each Form tool with its function: I. Blank Form II. Form Design III. Split Form IV. Form Wizard V. Form A. Creates a two-part form with a stacked and a tabular layouts B. Creates a custom form based on questions you answer C. Creates a form in a stacked layout displaying all record source fields D. Creates an empty form in Layout view E. Creates an Empty form in Design view

To sort fields in a report, you begin by clicking Group & Sort in the Group & Sort group on the DESIGN tab.

In Form view, to sort a field containing names from A to Z, click Ascending in the:

After creating a report, you view it in Layout view, you see that the report is extremely wide. You decide to narrow the state field, since the states are displayed using two-letter abbreviations. Explain how you would narrow the width of the state field.

What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance?

To sort a report, click ________ in the Grouping & Totals group to display the Group, Sort, and Total section.

When in Layout or Design view, which of the follow is NOT a form layout tab?

Give two reasons why using a form is better than using a table when adding, updating, and deleting data.

When Access creates a form with two related record sources, the main form is displayed with a stacked layout, while the subform with a datasheet layout.

Changes to data in a form are made in design view.

Pmt is an example of a(n) ________.

A subform combines two views of the same record source

Print Preview is used to see exactly what the report will look like when it is printed.

A(n) ________ layout displays fields horizontally across a form.

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

To add a calculated field to a report, you would use________ view.

Which of the following is NOT a view when working with forms?