Exam 1: Access 2019

OpenReport is an Access macro _____.

Why would you set the Limit to List property to No for a lookup field?

The goal of building one-to-many relationships between tables is to minimize _____ data.

You can change the margins of a report using the Margins button on the Print Preview tab.

When you add a field to a table in Table Design view, entering the field name is optional.

What happens if you apply the Currency format to a Number field?

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

To set a command button to be a hyperlink in Form Design view, you change the button's _____ property.

Where does a background image appear in a report?

Aimee wants to display labels as white text on a dark blue background. While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

If you do not enter a Caption property for a field, Access uses the field name to label the field.

A parameter query displays a dialog box that prompts you for field criteria.

The common field between two tables in a one-to-many relationship is the primary key field on the "one" side of the relationship and the _____ on the "many" side of the relationship.

To enter data in a table, open it in Table Datasheet view.

After Update is a typical event for a table macro.

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

In _____ view, you can make some design changes to a report while you are displaying the data.

Actions you take in Query Design view automatically update in _____.

You can use the Format property to display dates in a report using a Short Date format.

What do you click to perform the actions in a macro?