Exam 2: Formatting Workbook Text and Data

Which field is always on the "one" side of a one-to-many relationship between two tables?

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

Access sets the number of decimal places in a Number field, and you cannot change it.

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

The _____ property controls how many characters can be entered into the field.

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

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

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?

To move a field in Query Design view, you drag the field by its field selector.

Characteristics, such as Field Name and Data Type, are_____ that define a field.

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

If you move the City column in a table datasheet, _____.

You can right-click the status bar to display the _____.

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

To move a field in Table Datasheet view, you select the column and then _____.

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

To decrease the decimal places in a Number field in Report Design view, you can use the Decrease Decimals button or the Decimal Places property.

To delete a field in Table Datasheet view, you click _____.

When you import Excel data, you create a link to the data in the Access database.