Exam 1: Microsoft Access Basics

When the condition has two or more parts to it, such as customers who have ordered a specific part and live in a certain zip code, the two conditions are called ____________________.

When a field is selected in the form, "Current field" appears in the ____ list box when you open the Find and Replace dialog box.

The default placeholder is the ____.

You can use the horizontal and vertical rulers at the top and left side of the report in Report Design view to place controls in the report.

Figure AC 7-1 In the accompanying figure, the completed expression will appear in the area represented by item ____.

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

FIGURE AC 11-1 In the accompanying figure, the area where you type the name of an action to search for is referenced by ____.

When testing functions in Visual Basic, the answer appears in the Results window.

An encrypted database cannot be viewed or understood unless it is ____ with the correct password.

Figure AC 7-1 In the accompanying figure, item 1 points to the area showing the table ____.

You can run a query by ____.

To create labels, select the record source in the ____, click the Create tab on the Ribbon, and then click the Labels button in the Reports group on the Create tab.

FIGURE AC 6-1 Referring to Figure AC 6-1 above, the following is NOT a field in the data source: ____.

A control has ____ parts.

To create a relationship between tables, click the ____ tab on the Ribbon. In the Relationships group, click the Relationships button.

You can specify up to three conditions for a field.

Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. Unfortunately, when the inventory form ran using the new macro, all of the forms did not close after the macro ran. This most likely occurred because ____.

At least ____ lower-level form(s) need to be placed on an upper-level navigation form.

When a form is selected, the tab appears ____.