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
Get step-by-step solutions from verified subject matter experts
