Exam 6: Access_Module_1

To open the Navigation Pane, tap or click the ____ Button.

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 Social Security Number field? Why?

The Access window consists of a variety of components. These include the ____.

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

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

Changing the column width in a datasheet changes the structure of a table.

____________________ refers to the process of determining the tables and fields that make up the database.

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________

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

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

When Access first creates a database, it automatically creates a table.

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

____________________ view has more functionality for creating a table than Datasheet view.

A unique identifier is also called a primary key.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

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 insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

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