2025

Create a report based on all fields of the All the customers query. Save the report as AllCustomersReport.

2027

Delete the CustomersReport report.

2042

Change the Report Header of the CustomersReport report from CustomersReport to Report for all our customers without changing format. Maximize the width of the textbox to display the whole new text. Save but do not close the report.

2043

Move the textbox which displays the date =Now() within the open report, setting its possition in 0" from left and in 0" from top of the page footer.

2044

On the text box which displays the text Customers Report in the current report change the font color of the text to black.

2051

Save and close the report.

2107

Create a report based on the Products table that will display all of its fields in Tabular layout sorting the Description field in ascending order. Save the report as r1

2108

Change the positions of the Code and Description fields in the R_Products report, so that the Description field is displayed first followed by Code field. Adapt their respective labels. Save and close the report.

2109

Move the label which displays the text Products to 0" from top and 0" from left (within the current Section) in the R_Products report.
Then increase the label width to be equal to the report width. Also, set alignment to center. Save and close the report.

2110

Delete both the Code text box from the Detail and its respective label in the R_Products report. Format the Price text box in Standard style with 2 decimal places. Save and close the report.

2111

Create a new report which will be based on the query r_orders in which all the fields will appear. Grouping level based on the field CustomersCode. Ascending ordering according to Description, with summary of sum of the field TotalValue and sum of the field Quantity (show detail and summary without percentage calculations). Save the report under the name r_orders and close it.

2112

Insert one more text box in the CustomersCode footer section of the R_Orders report to display the average of the TotalValue field. Insert the same text box in Footer section of the report too. Make sure both of the boxes are displayed in 12pt Arial Black font. Save and close the report.

2125

Create a report based on all fields of the r_orders query grouped by the CustomersCode field. The report will display the maximum of the TotalValue. Accept the default properties and save the report under the name All_Orders. Finally, close the report.

2126

The data of the open report are grouped and sorted by CustomersCode in ascending order. Change the grouping field from CustomersCode to ItemCode and the sorting type from ascending to descending. Save and close the report.

2844

Move the text box which displays the date, to the Report Footer of the R_Products report.

2846

Create a new report named PerCustomer that will display all fields of the OrdersSummary query, grouped by Full Name and sorted by Date. Also display the average of the TotalValue field values for each customer.

11051

A report is used …

11764

If you wanted to print selected information from a table or query, which of the following objects would you use?