Exam 4: Using Reports Question

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

Marshall plans to generate reports from an Access table using the Report Wizard. The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice. How could Marshall design a report to quickly organize his equipment by most expensive to least expensive?

In the figure above, what button is identified as item 3?

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

In the figure above, what button is identified as item 4?

In the expression =Sum([Price]), the ____________________ function is used.

Which report creation tool is similar to the Form Wizard?

In the figure above, item 2 points to the ____ section.

Marshall plans to generate reports from an Access table using the Report Wizard. The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice. What feature of Report Design View would Marshall use to change sorting and grouping orders?

Koch labels are the most common manufacturer of labels, and therefore the default choice.

In the figure above, item 1 points to the ____ section.

Which report view's primary purpose is to quickly review the first page of the report?

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

The Group Header and Group Footer section can be turned on or off in which pane?

In the figure above, item 5 points to the ____.

The same expression in different report sections will calculate using a different number of records.

Which of the following is the correct expression to count the number of records using a field named City?

The Alternate Back Color property helps differentiate parts of the report by allowing you to specify a new color for every other time that the section prints.

In the figure above, what button is identified as item 1?

A(n)____________________ is a built-in formula such as Sum or Count.