|Total of questions: 187|
|Total of questions: 187|
|First steps (10 questions)|
|Basic Functions (11 questions)|
|Indexes (2 questions)|
|Table Design (30 questions)|
|Relationships (17 questions)|
|Forms (33 questions)|
|Queries 1 (29 questions)|
|Queries 2 (29 questions)|
|Reports (19 questions)|
|DIPLOMA level questions (7 questions)|
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.
Insert a new text box in the footer of the report that will display the total of records.
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.
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.
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.
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.
Modify the R_Orders1to1 report so that every customer record starts in a new page.
Insert a new text box in the R_Orders1to1 report that will calculate the total of the TotalValue field. Make sure this item is displayed once in the last page of the report.
In the CustomerID footer of the R_Orders report insert a new text box which will calculate the percentage of the customer’s TotalValue in the final TotalValue.
Insert a new text box which will calculate the total of the TotalValue field in the footer of the R_Orders report. Insert one more text box to calculate the total number of the orders.
Insert a new text box that will calculate the total of the TotalValue field for every client in the CustomerID footer of the R_Orders report. Insert one more text box to calculate the total number of the orders placed by every client. Save the report.
Delete the subreport from the Customers report.
Insert the subreport named R_Orders in the Detail section of the Customers report. Use the CustomerID field to link your main form to this one. Save the report.
Apply the appropriate changes to the R_Orders report so that the bottom part of every page contains both the current date and time in one text box and the page number in another, in the following format: Page 1 of 5
Insert a text box in the Detail section of the R_Orders2 report that will display the product of the Price value by the Quantity value for every order in Euro number format.
In the R_Orders3 report modify the text box which displays Surname in the appropriate way to display Surname and Firstname separated by a space between them.
Insert a text box in the CustomerID footer section of the R_Orders report, that will display the percentage of every customer in the turnover. Make sure the resulting output is displayed in percentage form with two decimal places.
Apply the appropriate changes to the R_Orders4 report so that every customer entry is displayed in different page.
Insert a text box in the footer section of the R_Orders report that will display the lowest value of the DateOfOrder field. Save the changes.