Exam 2: Formatting Workbook Text and Data

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

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

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

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

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

Which process is most like copying and pasting?

When you import Excel data into an existing Access table, you relate the data to the table.

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

When can you rename a table?

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

You can import table data from _____.

What happens if you delete a field from a table that contains data?

To relate two fields in a one-to-many relationship, you connect them using a _____.

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

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

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

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

How do you rename a table?

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

You can import Access table data from which of the following Office apps? Select all the options that apply.