Exam 1: Microsoft Access Basics

A Visual Basic ____ appears when you click the Create tab, and then click Module in the Macros & Code group.

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle leaves for lunch and when she gets back she has forgotten what her last sort was. She notices a small down arrow in the Pricing field of her product datasheet which indicates a ____ sort order.

To create an input mask, you must be in ____ view.

You click the ____________________ tab and if necessary the Info tab, to access the Encrypt with Password option.

The ____________________ takes you step-by-step through the process of creating an input mask.

____________________ formatting allows you to add formatting features to the data based on criteria you specify.

You can use a combo wizard to add a combo box to a form.

You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it.

To protect the data in the table, it is best to make a copy of the table before you run a(n) ____ query.

When a report contains more than one page, you can click the buttons on the ____ bar at the bottom of the Print Preview window to view additional pages in the report.

After the syntax Visible, you will need to add a(n) ____ and the word True or False so that the label will appear or not appear.

If you want to print form letters in alphabetical order based on a specific field, you can click the Sort link to open the Filter and Sort dialog box with the ___________________ tab selected.

When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table's ____________________.

You can use a form to ____.

A logo is automatically placed in the ____.

Using the Lookup Wizard to set lookup properties allows you to have more than one ____ of data appear in the list.

The controls in a report have multiple ____ that can be changed once they are added to the report.

A comment helps the person looking at the code identify the purpose of the code.

FIGURE 13-3 In Figure 13-3 above, item 2 points to ____.

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.