Using Forms

Question 1

Which part of a form can a user edit after its creation?

Revolt · Accepted Answer

the name of the form

Question 2

Use the drop-down menus to complete the steps for filtering records in a form.

Revolt · Accepted Answer

✔ Home; 2. Click the tab.: Home; 3. In the Sort & Filter group, click , and click Filter by Form.: Advanced; 5. On the Home tab, in the Sort & Filter group, click the button to toggle the filter.: Apply Filter

Question 3

✔ AdvancedFilteringFindNew

Revolt · Accepted Answer

✔ Advanced

Question 4

AscendingDescending✔ Apply FilterToggle Filter

Revolt · Accepted Answer

✔ Apply Filter

Question 5

Use the drop-down menus to complete the steps to open the Lookup Wizard.

Revolt · Accepted Answer

1. Open the table in view.: Design; 2. Click in the column of the desired field.: Data Type; 3. Click the , and then click Lookup Wizard.: arrow

Question 6

✔ Data TypeData ValueField NameField Properties

Revolt · Accepted Answer

✔ Data Type

Question 7

✔ arrowasteriskcheck boxcolumn header

Revolt · Accepted Answer

✔ arrow

Question 8

What options are available under the Form Tools Design tab? Check all that apply.add controlschange fontschange viewschange marginsadd existing fieldsinsert rows and columns

Revolt · Accepted Answer

add controls; change fonts; change views; add existing fields

Question 9

In which situations would it be most helpful to filter a form? Check all that apply.The data needs to be filtered using complex criteria.The data includes a large number of values that are unique.The data needs to be filtered by a threshold that is not present.The data needs to be filtered by data equal to one specific value.The data includes only a small number of values repeated frequently.

Revolt · Accepted Answer

The data needs to be filtered using complex criteria.; The data needs to be filtered by a threshold that is not present.

Question 10

What are advantages of lookup fields? Check all that apply.shorter reportssimpler querieseasier data entryacceptable values fewer misspellings

Revolt · Accepted Answer

easier data entry; acceptable values; fewer misspellings

Using Forms Answers

More from this Course

TRY EDGENUITY HACKS