Exam 1: Microsoft Access Basics

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.

A relationship is a way of telling the query which data you are interested in seeing.

To add a comment in VBA, you begin by typing a(n) ____ before the sentence.

The main navigation form is the ____ form.

____________________ refers to the specific information you are searching for.

FIGURE AC 11-1 In the accompanying figure, ____ points to the area where you click to display a list of actions.

FIGURE AC 12-6 As referenced in Figure AC 12-6 above, before designing a navigation form, you should decide on the type of ____ you want to use.

To create an input mask, you select the field for which you want to create the input mask, and then click in the Input Mask ____ in the Field Properties pane.

The Custom Print Wizard lets you create a report that you can use to print standard or custom labels.

FIGURE AC 4-1 Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.

To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.

A(n) ____________________ is a predefined format that can be used with fields that contain data, such as dates and Social Security numbers.

What types of actions can you take in the Refine recipient list section of the Mail Merge Recipients dialog box? An example given in the lesson was that you could print form letters in alphabetical order based on a specific field. Please give an example of a situation where this capability would prove useful.

If you click the File tab and notice that the Encrypt with Password option is ____, this indicates that the password and encryption are removed.

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.

Record operation options let you add a command button with a task.

When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.

When you save a parameter query, you can add ____ before the query name to easily recognize it as a query in a list.

When you enter dates in the Immediate window, you place a(n) ____ before and after the date to define when the date starts and ends.