Exam 2: Formatting Workbook Text and Data

You can set the Field Size property for a field with a Short Text data type.

You can use the _____ to copy data from Excel to Access.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

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

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.

____ makes a duplicate copy of the data in the Access database.

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

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

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

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

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?