Question: To close a form in Form Design view and keep Access running, you _____. a. right-click the form tab, and then click Close on the

To close a form in Form Design view and keep Access running, you _____.

a. right-click the form tab, and then click Close on the shortcut menu.

b. click the Close button on the title bar

c. right-click the form in the Navigation Pane, and then click Close on the shortcut menu.

d. drag the form tab to the Navigation Pane

What are you doing when you enter data into a subdatasheet?

a. You are entering records in the related table.

b. You are creating an alternate view of the data.

c. You are entering properties for the fields.

d. You are enforcing referential integrity.

Access adds @ signs around date criteria in Date/Time fields.

a. True

b. False

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

a. True

b. False

What might you need to do after increasing the font size in a table datasheet?

a. Widen the columns.

b. Change the field sizes in Table Design view.

c. Reset table relationships.

d. Check the spelling of the data

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

a. Simple Query Wizard

b. Find and Replace

c. Filter By Form

d. query design grid

To apply the last filter you selected to a datasheet, you click the _____ button.

a. Clear All Filters

b. Remove Filter

c. Toggle Filter

d. Repeat Filter

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

a. True

b. False

How do you display the results of a query listed in the Navigation Pane?

a. Double-click the query.

b. Right-click the query, and then click Run on the shortcut menu.

c. Right-click the query, and then click Design View on the shortcut menu.

d. Click the query, and then click the Open button in the Navigation Pane.

What should you do before applying a new filter to a datasheet?

a. Save the previous filters.

b. Change the sort order of the records.

c. Switch to Query Design view.

d. Clear all previous filters.

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!