Exam 2: Formatting Workbook Text and Data

You can import table data from _____.

You typically increase the decimal places from 1 to 2 for a(n)_____ field.

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

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

When can you rename a table?

To move a field in the query design grid,click its_____,and then drag it left or right.

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

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

If a field named Price displays values with three decimal places,what should you do to display the values accurately?

Which of the following statements are true about one-to-many relationships? Select all the options that apply.

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

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

Changing the _____ property for a field does not change the actual data stored in the field.

You use the Insert Rows button on the Query Tools Design tab to _____.

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

What data type should you assign to a WeeklySalary field?

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

The _____ key field is the linking field on the "many" side of the relationship.

Which of the following are properties you can set for a Currency field? Select all the options that apply.

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