Question: You want to set up Data Validation to provide an in - cell drop down that contains a list of accounts. Assume you have a

You want to set up Data Validation to provide an in-cell drop down that contains a list of accounts. Assume you have a list of accounts in a Table named tbl_accounts. You also have a named reference dd_accounts that refers to tbl_accounts. In the Data Validation dialog box, on the Settings tab, you would allow a List, and then use which value in the Source field:
Question 31Select one:
a.
tbl_accounts
b.
dd_accounts
c.
=tbl_accounts
d.
=dd_accounts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!