How do you filter records using the 'Advanced Filter/Sort'?

Filtering records using the 'Advanced Filter/Sort' feature in a database application like Access involves specifying precise criteria that can target multiple fields within a dataset. This functionality allows users to create complex queries that refine their data visibility based on specific conditions.

When employing the advanced filter, you can define conditions that consider various fields simultaneously, which means you can retrieve records that meet multiple criteria. For instance, you might filter a customer database to show only those customers who reside in a certain city and have made purchases above a particular amount. This capability is especially useful for generating focused reports and extracting meaningful insights from large data sets.

The other options do not accurately describe the process of using the 'Advanced Filter/Sort' feature. Exporting data to a new table involves moving data rather than filtering it within the existing structure. Rearranging the layout of a report does not affect the underlying data but only its presentation. Basic sorting options are limited to ordering data rather than applying complex filtering criteria across multiple fields. Thus, the correct answer effectively captures the essence of how advanced filtering operates in a database environment.