Exam 3: Databases and Database Objects: an Introduction

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

What data type should Joe use for the Social Security Number field? Why?

To save the changes to the layout of a table, tap or click the Save button on the ____.

To exit Access, tap or click the ____ button on the right side of the title bar.

A field whose data type is ____ can store text that can be used as a hyperlink address.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

The DATABASE TOOLS tab provides commands to save a database with another name.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

In the accompanying figure, the database name, Bavant Publishing appears on the ____________________.

When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field?

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.