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 import Access table data from which of the following Office apps? Select all the options that apply.

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

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

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

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

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.

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

How do you rename a table?

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

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?

Which process is most like copying and pasting?

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

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

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

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

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

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

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