Access Mod 3 Q1

To create a split form, select the table in the Navigation Pane, click CREATE on the ribbon, click the ____ button on the CREATE tab to display a menu, and then click Split Form on the menu.

• All Forms

• More Forms

• Tabular Forms

• Forms View

To move from Layout view to Form view, click the ____ button on the Access status bar.

• Open Form

• Edit View

• Data View

• Form view

To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.

• Selection

• Filter by Selection

• Find

• Replace

When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab.

• Remove Filter

• Filter

• All

• Toggle Filter

To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.

• Filter

• Remove

• Advanced

• Select

To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

• Text Filters

• Character Filters

• Common Filters

• Common Character Filters

To use Filter By Form to filter records, click the ____ button on the HOME tab and then click Filter By Form.

• Advanced

• Filter

• Selection

• Find

When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.

• Apply Filter

• Filter

• Toggle Filter

• Select

To filter records using complex criteria, click the ____ button on the HOME tab and then click Advanced Filter/Sort on the menu that appears.

• Filter

• Find

• Selection

• Advanced

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the HOME tab to view the results.

• Filter

• Selection

• Advanced

• Toggle Filter