Exam 2: Formatting Workbook Text and Data

To rename a table, you must use the Navigation Pane.

To import data from Excel to Access, you would begin by clicking the ____.

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.

What data type should you assign to a WeeklySalary field?

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

The Import Spreadsheet Wizard helps you import Excel data into Access.

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

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

What Field Size should you set for a State field that stores two-character state abbreviations?

You cannot modify the Field Size property of a Short Text field.

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

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

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