In Query By Example, what does the asterisk in Fields Requested signify?

In Query By Example, what does the asterisk in Fields Requested signify?

• A. Select all fields
• B. Select a single field
• C. Compute a derived field
• D. Exclude fields

Answer: (A)

In Query By Example, the Fields Requested area decides which columns show up in the results. The asterisk acts as a wildcard meaning you want every field from the tables involved in the query. This is the same idea as SQL’s SELECT *: you don’t list each column, you request all of them. It isn’t signaling a derived field or any calculation—those would require a specific expression or formula in the grid. It also isn’t about excluding fields; using the asterisk simply includes everything, and you would switch to listing individual field names if you want to limit which columns are returned.

In Query By Example, the Fields Requested area decides which columns show up in the results. The asterisk acts as a wildcard meaning you want every field from the tables involved in the query. This is the same idea as SQL’s SELECT *: you don’t list each column, you request all of them. It isn’t signaling a derived field or any calculation—those would require a specific expression or formula in the grid. It also isn’t about excluding fields; using the asterisk simply includes everything, and you would switch to listing individual field names if you want to limit which columns are returned.