After selecting tables for the query in the Show Table dialog box, which options are available in query Design view? Check all that apply.renaming tablesediting data in the tableselecting fields to displaysetting criteria for filteringchoosing how to sort the recordsmoving data from one field to another

In Query Design view, you can choose which fields appear in the results, enter criteria to filter records, and set sort order. Those actions correspond to selecting fields to display, setting criteria for filtering, and choosing how to sort the records. Editing table data or moving data between fields changes the underlying data, rather than designing the query.

AI-written and checked against the verified answer.