Access Chapter 4

______ shows the report as it will appear when printed.

______ shows the report on the screen but also allows you to make changes to the report.

To specify grouping and sorting for a report, click the _______ button on the Design tab in Layout view.

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The ______ option allows you to choose the length of the value on which to group.

The ______option allows you to choose values to be totaled and where they are to appear.

The _____ option allows you to customize the group title.

The ______ option allows you to indicate whether Access is to attempt to keep portions of a group together on a page.

_____ are used to display data that comes for the database, such as the client number and name.

_______ are associated with data from the database and are used to display such things as the report's title.

_____ are used to display data that is calculated from other data, such as a total.

To add totals or other statistics to a report, use the ______ button on the design tab.

To display the Conditional Formatting Rules Manager dialog box, click the ______ button on the Format tab.

To filter records in a report, use the filter buttons on the _______ tab.

To adjust the margins or change the page orientation of a report, open the report in Layout View and then click the ______ tab.

You use the ________ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

To crate a report in Layout view, click the _____ button on the create tab.

To use a field list to add a field to a report in Layout view, click the ______ button on the Design tab to display a field list.

If you open a field list and the tables do not appear in the field list, click _______.

A ______ consists of a selection of colors and fonts for the various sections in a report or form.

To add a title to a report, click create on the Ribbon and then click the _______ button on the design tab.

To find themes that are not listed in Access but are available for download, click the _______ command.

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a ______ report.

To use the Form Wizard to create a form for a table, select the table for the form in the navigation Pane, click the Create tab, and then click _______ button.

The ______ section appears at the top of the form and usually contains the form title.

The body of the form is in the ______ section

The ______ section appears at the bottom of the form and often is empty.

______ shows the form on the screen and allows you to use the form to update data.

IN ______ you cannot update the data, but you can make changes to the layout of the form.

______ allows you to make changes, but it does not show you the actual form.

To place controls on a form in a control layout, select alll the controls and click the Stacked button on the ______ tab.

To add a date to a form, click the _____ button on the Design tab.

A ______ layout arranges controls vertically with the labels to the left of the control.

A ______ layout arranges controls horizontally with the labels across the top, typically in the Form Header.

To add an additional field to a form, click the ______ button to display a field list.

To filter records on a form, click the Advanced button on the ______ tab to display the Advanced menu.

The ______ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

To clear a current filter, click _____ on the Advanced menu.

To create labels using the Label Wizard, click the ______ button on the Create tab.

A selection of colors and fonts for the various sections in a report or form.

Usually viewed on the screen.

A total for just the records in a group.

A layout that is similar to a spreadsheet with labels across the top and data in columns below the labels.

A layout that is similar to a paper form, with labels to the left of each field.

Includes group calculations but not detail Lines.

Occurs when you point to a theme.

Shows a report as it will appear when printed.

Tab on Ribbon that contains buttons to allow you to add grid lines and change layouts in Layout View.

Tab on Ribbon that contains buttons to allow you to change the page orientation in Layout View.

To create a simple report, select the table for report in the Navigation Pane, click the Create tab, and then click the _____ button in the Reports group.

To use the Report Wizard to create a report for a table, select the table for the report in the Navigation Pane, click the Create tab, and then click the _____ button.

_____ shows the report as it will appear when printed.

_____ shows the report on the screen but also allows you to make changes to the report.

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to choose the length of the value on which to group.

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to choose values to be totaled and where they are to appear.

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to customize the group title.

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to indicate whether Access is to attempt to keep portions of a group together on a page.

In the accompanying figure, _____ are used to display data that comes for the database, such as the client number and name.

_____ are not associated with data from the database and are used to display such things as the report's title.

_____ are used to display data that is calculated from other data, such as a total.

To add totals or other statistics to a report, use the _____ button on the Format tab.

The ____ aggregate function finds the smallest value.

The _____ aggregate function finds the largest value

To resize a column, point to the boundary of the column so that the mouse pointer becomes a _____ arrow.

To display the Conditional Formatting dialog box, click the _____ button on the Format tab.

To filter records in a report, use the filter buttons on the _____ tab.

To adjust the margins or change the page orientation of a report, open the report in Layout view and then click the _____ tab.

You use the _____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

To use a field list to add a field to a report, click the _____ button on the Format tab to display a field list.

If you click an Edit Table link in a field list, the table will appear in _____ view and you can make changes to it.

To delete a field from a report, click the field and then press the _____ key(s).

To create a report in Layout view without using the Report Wizard, click the Create tab, and then click _____ in the Reports group

When you add the _____ property for a multivalued field, such as Specialties Needed to a report, each value would be on a separate line.

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, click the Create tab, and then click the _____ button.

The _____ section appears at the top of the form and usually contains the form title.

The body of the form is in the _____ section.

The _____ section appears at the bottom of the form and often is empty.

_____ shows the form on the screen and allows you to use the form to update data.

In _____ you cannot update the data, but you can make changes to the layout of the form.

_____ allows you to make changes, but it does not show you the actual form.

To include horizontal and vertical gridlines on a form, click the Gridlines button on the _____ tab to display the Gridlines menu.

To change the color of the font in a control, use the _____ arrow on the Format tab to display a color palette.

To add an additional field to a form, click the _____ button to display a Field List.

To filter records on a form, click the Advanced button on the _____ tab to display the Advanced menu.

The _____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

To clear a current filter, click _____ on the Advanced menu.

To create a form in Layout view without using the wizard, click Create on the Ribbon and then click the _____ button on the Create tab.

To create a Datasheet form, click the _____ button arrow on the Create tab, and then click Datasheet.

The function of the _____ button is to tie a control to a section or another control so that it moves or resizes in conjunction with the movement or resizing of its parent.