FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formatting Workbook Text and Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) the City field also moves in Table Design view
B) you must switch to Table Design view and move the City field
C) you change the appearance of the table but not the structure
D) you must reassign properties for the City field

E) B) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) number of records in a table
B) Quick Access Toolbar shortcut menu
C) Database Views shortcut menu
D) Customize Status Bar shortcut menu

E) A) and D)
F) A) and B)

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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 _____.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.