Question

Which of the following statements is true?

You can group records to show a list of properties by state.
You can sort records in reports but not in forms.
You can either group or sort records (but not both).
A sort can only be set on one field at a time.

Answer 1

The statement A. "You can group records to show a list of properties by state" is true. With grouping, you can organize and display data based on specific criteria such as state, city, or property type. Sorting can also be done in both forms and reports, allowing you to arrange data in ascending or descending order based on one or more fields. Additionally, it is possible to both group and sort data simultaneously, allowing for more sophisticated data organization. Finally, you can set sorts on multiple fields at the same time, enabling you to further refine and customize data displays.