Exam 1: Microsoft Access Basics

In VBA code, a(n) symbolic name can be assigned to a value.

FIGURE AC 12-6 In Figure AC 12-6 above, ____ show how the tabs will be arranged.

You ____ the empty field to the right of the Description field in the design grid to display the shortcut menu.

To add a condition to a field, click in the field's Criteria box, and then type the condition.

Queries are ____ that let you locate specific information in tables.

____ determine the type of calculation in the expression.

Which of the following events may cause data loss requiring a database restore from a backup?

When a(n) validation rule is created, data entered into the field must meet the rule requirements.

Navigation forms in the lower level of the hierarchy are produced ____.

When saving data entered with an input mask, if your computer has plenty of ____, it should be okay to save the values with the symbols.

Record navigation refers to moving within the records in a form.

A macro automates common, repetitive tasks you perform in Access, thereby saving disk space.

The ____ property specifies whether you must enter a field value in a record.

A(n) ____________________ is a computer program that is designed to reproduce itself by attaching to other programs in a computer.

The database ____________________ refers to the objects in the database and the relationship between these objects.

When you start the mail merge from Access, ____.

Sorting a field in ascending order arranges records from Z to A, or largest to smallest.

When moving a logo, you select it, place the mouse pointer over the logo and when you see the pointer change to a(n) ____-headed arrow, press and hold the mouse button, then drag it.

Whenever a user opens a database, the splash screen looks for an AutoExec macro.