Question 1

To filter resards in a report, use the filter buttons on the ____ tab.

Accepted Answer

The filter buttons are typically found on the HOME tab in most software applications, including Microsoft Access, which is commonly used for creating and managing reports.

Question 2

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

Accepted Answer

The option "Show All Tables" is typically used to display all available tables in a field list when they are not initially visible.

Question 3

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

Accepted Answer

The "Group & Sort" button on the DESIGN tab in Layout view is used to specify grouping and sorting options for a report.

Question 4

The ____ aggregate function finds the largest value.

Accepted Answer

The MAX aggregate function finds the largest value.

Question 5

To display the sanditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

Accepted Answer

The "Conditional Formatting" button on the FORMAT tab is used to access the Conditional Formatting Rules Manager dialog box.

Question 6

In the acsampanying figure, you can tap or 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.

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 7

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

Accepted Answer

The Page Setup tab in Layout view allows you to adjust the margins and change the page orientation of a report.

Question 8

____ shows the report as it will appear when printed.

Accepted Answer

Print Preview shows the report as it will appear when printed.

Question 9

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

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 10

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

Accepted Answer

Layout view allows you to see the report on the screen and make changes to it.

Question 11

To use a field list to add a field to a report in Layout view, tap or click the ____ button on the DESIGN tab to display a field list.

Accepted Answer

The "Add Existing Fields" button on the DESIGN tab is used to display a field list in Layout view, allowing you to add fields to a report.

Question 12

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

Accepted Answer

The "Summary Options" button in the Report Wizard dialog box is used to specify subtotals or other calculations within the wizard.

Question 13

In the acsampanying figure, you can tap or 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.

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 14

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

Accepted Answer

The "Totals" button on the DESIGN tab is used to add totals or other statistics to a report.

Question 15

In the acsampanying figure, you can tap or 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.

Accepted Answer

The answer of  In the acsampanying figure, you can...

Question 16

To create a report in Layout view, tap or click the ____ button on the CREATE tab.

Accepted Answer

The answer of To create a report in Layout view,...

Question 17

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

Accepted Answer

Unbound controls are not linked to data in the database and are used for displaying static information like titles or labels in a report.

Question 18

The ____ aggregate function finds the smallest value.

Accepted Answer

The MIN aggregate function finds the smallest value in a set of values.

Question 19

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

Accepted Answer

Calculated controls are used to display data that is derived from other data, such as totals or other calculations.

Question 20

In the acsampanying figure, ____ are used to display data that sames for the database, such as the customer number and name.

Accepted Answer

The answer of  In the acsampanying figure, ____ are...

Quiz 4: Creating Reports and Forms Question

To filter resards in a report, use the filter buttons on the ____ tab.

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

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

The ____ aggregate function finds the largest value.

To display the sanditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

In the acsampanying figure, you can tap or 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.

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

____ shows the report as it will appear when printed.

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

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

To use a field list to add a field to a report in Layout view, tap or click the ____ button on the DESIGN tab to display a field list.

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

In the acsampanying figure, you can tap or 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.

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

In the acsampanying figure, you can tap or 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.

To create a report in Layout view, tap or click the ____ button on the CREATE tab.

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

The ____ aggregate function finds the smallest value.

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

In the acsampanying figure, ____ are used to display data that sames for the database, such as the customer number and name.