Question

In the query design view of the WorkshopAttendanceByType query, add an ascending A-Z sort order to the __________.

a. Date field
b. Attendance type field
c. Participant names
d. Workshop location

Answer 1

To add an ascending A-Z sort order in the WorkshopAttendanceByType query, you should choose the Attendance type field.

Step-by-step explanation:

In the query design view of the WorkshopAttendanceByType query, you can add an ascending A-Z sort order to any field you choose. In this case, since the query is about workshop attendance by type, it would make the most sense to add the sort order to the Attendance type field.

Answer 2

In the query design view of the WorkshopAttendanceByType query, add an ascending A-Z sort order to the Participant names.Option C is answer.

Step-by-step explanation:

To organize the results in ascending alphabetical order by participant names in the WorkshopAttendanceByType query, you would apply the sort order to the "Participant names" field. Query design view allows you to specify sorting preferences for each field involved in the query. This ensures that when you run the query, the output will be displayed in an ascending order (A-Z) based on the selected field. Sorting is beneficial for data presentation, especially when you want to quickly locate specific information or present the results in a more structured manner.

Option C (Participant names) is the answer.