Exam 1: Microsoft Access Basics

If you want to make the control label visible in the procedure, you need to add the syntax ____ after the name given to the label.

By default, the rows in a datasheet are displayed with ____.

A lookup property list of values can be from another field or in a query.

A(n) ____________________ is a collection of objects.

Another way to resize a report is to use the report ____, which appears in the upper-left corner of the report, where the horizontal and vertical rulers intersect.

It is easier to read and identify the purpose of a function if it has recognizable control names.

A red triangle report error indicator appears on the report selector when the report's width exceeds the width of a page.

When a report selector is selected, it appears with a dark ____.

A database is a collection of ____.

After setting the properties for the fields in your table, you can use Datasheet view to enter records in the table.

You manually create the subform controls in a Navigation form.

A(n) ____________________ is an action that can be defined in VBA code where you use statements to describe the action you want performed.

In previous versions of Access, you might have used a ____ for the purpose of creating menus in a hierarchical format.

You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab.

An unbound control is connected to a field in the record source and is used to display, enter, and update data.

____ is the program used to create macros.

When applying validation rules to data, a(n) ____ appears if the data is entered incorrectly.

You can use any document as a form letter, including documents that you create from scratch or a template.