What option shows all the records and fields in a query?

To show all the records and fields in a query, you can use the "SELECT *" statement in SQL. This command retrieves all columns from the specified table without needing to list each field individually. In a graphical query builder, you would typically select all fields from a table by checking a "Select All" option or similar. This approach allows you to view complete data entries from the query results.