If you want to create a single filter that utilizes criteria from multiple tables in the same query, which filter do you need to use?
You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the
Dependents and Address tables. You notice many employees are missing from the result set.
What are the reasons?
In a live data query, what are user-prompted filter types?
Note: There are 2 correct answers to this question.
When you use a column of type text as a measure in a pivot query, which of the following pivot functions are available?
Note: There are 2 correct answers to this question.
When you format a list report component, which actions can you perform?
Note: There are 3 correct answers to this question.