Microsoft
MB6-890 · Question #76
You have a query that uses Table1 as a data source. You want this query to automatically update its fields when any fields are added or removed from Table1. What property changes must be made for…
The correct answer is A. Set the Update property to "Yes". See the full explanation below for the reasoning.
Question
You have a query that uses Table1 as a data source. You want this query to automatically update its fields when any fields are added or removed from Table1. What property changes must be made for this query?
Options
- ASet the Update property to "Yes".
- BSet the Dynamic Fields property to "Yes".
- CSet the First Only property to "No".
- DSet the Allow Add property to "Yes".
How the community answered
(32 responses)- A78% (25)
- B13% (4)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.